Message for Jrjr

[fredfox]

Can you please also help me with this, it is the database that I am trying to set up for a Shopmobility Sceme and need to tie up some loose ends before I go live.

I have condensed the original database and left the relevant part in.

On the Usage form when I enter a vehicle number I would like it to automatically show Type, Make & Model

And when I type Membership Number in I would like it to automatically on the usage form show Authorised, first name & Last Name.

Also on the usage form. when I enter Time Out and Time Back it gives me a total in the field but does not show up in the usage table.

Many thanks for your last input that is now working fine.

Fred fox

 

[Smart]

re the time out back problem

On the usage form
field Total properties, data change control source to Total
On the other tab change name to txttotal

On the properties for field Time back
event,after update
place the following code
txtTotal = [time back] - [time out]

The total will now be written to the usage table

 

[fredfox]

Thanks for help

What do you mean by "On the other Tab change name to txttotal".

Fred

 

[jrjr]

In design mode of your form, at the top left is a square with a black square in it. Right click that and choose properties. Up will come the property sheet for your form that has several tabs. One of these is called "Other"

Sorry I didnt get back to you sooner but I have not been in here for a few days. You can just generally ask for help, you dont have to ask me. There are many others here that are far more knowledgeable than I am!

 

[Pat Hartman]

Calculated values shouldn't be saved to the table. They should be recreated as needed. The reason will be obvious if you follow the instructions you have been given to calculate the value in the AfterUpdate event of the [time back] field. Open any already saved record and modify the [time out] field.

 

[fredfox]

Still Stuck

I have tried this and still can not get it to work, can someone altert the attachement so I can see it work and then post it back to me.

Fredfox