1 Topic by tcsplinters

(1 replies, posted in General)

Hi

Just went to MVD home page and couldnt download the latest 6.5 version of MVD.  Can anyone help with where the latest download can be found.

Thank you

Go to forum: General

2 Reply by tcsplinters

(8 replies, posted in General)

Hi Derek

Thanks for your work.  Will have a rummage today.  Thinking about re building the whole project.... so scope there to improve!

tc

Go to forum: General

3 Reply by tcsplinters

(8 replies, posted in General)

Hi Derek

Yes that is correct, each appliance belongs to one customer. These are test carried out on behalf of particular customer - so each appliance is associated with a single customer.

I would be interested in some tips to associate the customer to the appliance...

Thank you
tc

Go to forum: General

4 Reply by tcsplinters

(8 replies, posted in General)

Hi Derek

Thanks for the work. Loved the dataview button, and the sqllite suggestion.

I thought yesterday that when I went from the Business info form to appliance search using the appliance button, it auto filled the combo box customer details on the form... today it doesnt..

Could you have a look and see why it doesnt?  Using your vrsion 2

Also how do you do the tabbed form?

Thank you
tc

Go to forum: General

5 Reply by tcsplinters

(8 replies, posted in General)

Hi Derek

Thank you very much.  Looks pretty much what I thought it should do

Two questions
a. How did you look at the data in the tables?
b. Did you do anything particular to key the records?

Thank you
Tony

Go to forum: General

6 Topic by tcsplinters

(8 replies, posted in General)

Hi

I have been working on a small application, and run into a problem that I struggling to fix 'properly'

Structure
Each customer has
   Many appliances
      Each appliance has many tests

So How do i ensure the each test is linked to one appliance and one customer?

If I insert a counter field, all the existing records wont have that counter value?

Can I I fill in each form in the string with the inherited values... ie use a combo box on an appliance form, and fill it with the customer name that was clicked?

Thanks in advance...

I have attached my database... please excuse all the beginner errors... any suggestions would be appreciated.

Go to forum: General

7 Reply by tcsplinters

(8 replies, posted in General)

Hi Derek

Thank you for that.  No problem with the changes, will use yours as an example

Many thanks
tc

Go to forum: General

8 Reply by tcsplinters

(8 replies, posted in General)

Hi Derek & Dmitry

Derek, I dont see any error message in the version you sent me - could you explain what you resolved?

Dmitry - interestingly enough, today I dont see any errors in my database at all - so I may have acciedently fixed something.

Thanks to you both
tc

Go to forum: General

9 Reply by tcsplinters

(7 replies, posted in General)

Hi

Thanks Derek, yes I missed the on change event.  Thank you for your clear instruction.  All fixed.  Will look at using standard features to make a selectable option for the dates.

Thanks for all the help
tc

Go to forum: General

10 Reply by tcsplinters

(7 replies, posted in General)

Hi ehwagner

Tried your scripted version.. but cant get the change date version to work

Not sure what I am missing!

procedure frmResults_OnShow (Sender: TObject; Action: string);
begin
    frmResults.dtNextDue.DateTime:= frmResults.dtTestDate.DateTime + 365;
end;

procedure frmResults_dtTestDate_OnChange (Sender: TObject);
begin
    frmResults.dtNextDue.DateTime := frmResults.dtTestDate.DateTime + 365;
end;

begin

end.

Thank you

Go to forum: General

11 Reply by tcsplinters

(7 replies, posted in General)

Thank you both for the assistance. 

Does MVD have the ability to have a radio button, (ie options that allow only one to be selected).  Can only see checkboxes, and they allow multiple selections

Have the sual problem of 'creeping' elegance... want to keep improving

So idea being
Radio buttons to select 3month / 6 month or 12 month, with calendar updating.

thank you

Go to forum: General

12 Topic by tcsplinters

(7 replies, posted in General)

Hi

I am trying to find my way with visual database.. got most things working but need to make it easier to use

I have a form with to options for date using the date picker

Box one, is set to todays date (test date)
Box two is to be set 365 days later (ie next test due)

How can I do this? Think it is in sql, but not sure

If sql, can you give an example
If sql where do I put the sql, and how to apply it

Thank you

Go to forum: General

13 Reply by tcsplinters

(8 replies, posted in General)

Hi

File attached.

Thanks
tc

Go to forum: General

14 Reply by tcsplinters

(8 replies, posted in General)

Hi

Realized my description was not the best

So my project compiles fine, and works
But whenever I edit a button / tablegrid I get an error message

Access violation at address 0040697F in module
MyVisualDB.exe. Read of address 0E214F98

Feel sure it is something I have done, as I have just started to design in MyVisualDB

Thanks in advance
tc

Go to forum: General

15 Topic by tcsplinters

(8 replies, posted in General)

Hi

I have struck a small problem with my project.  Everytime I edit a search box / table grid I get an Access violation.  I am not sure where to look to resolve this.

Attached is my project, but would appreciate any help to resolve.

Thanks
tc

Go to forum: General