Search results

Ok, I have a lovely database setup for call loggin. I have a table that contains a primary key [autonumber], with all the details about a call e.g time of call [time short] date of call etc. I would like to add a call refernce field that is automatically generated for each new record. But...

Have changed names, just did not re-paste them. Also annotate my code and use indents for future proofiong. Funnily enough also produce flow charts for my code.

Still the same problem. Any other ideas?

I have not got the syntax error anymore but when I try to select the value from the second combo I am persented with: enter parameter value tblMaster.Instrument "Field to enter text" Ok button or Cancel. any ideas?

Searched through for help but to no avail. I'm usnig 2 combo box the with the following code in the after update event of the first/master combo box: Combo34.RowSource = "Select tblMasterDB.Instrument " & _ "FROM tblMasterDB " & _ "WHERE tblMasterDB.Hospital Name = '" &...

no I haven't. So original question still remains. how to insert the time(), into a memo field on a new line so that if I click it every 5 mins the memo box would look like: 12.00 12.05 12.10 not just overwrite the previous time. Thanks

Sorted it out, dependant upon the value stored in the field, that calls up various pre defined text.

Hello, I have a couple of buttons on a form that I am havinga little trouble with. The first button increments an integer variable which changes the colour of a box dependant upon the value. When a new record is opened I want it to be 0 which sets the colour. So on the form load event I have...

using DMax() with prefixes, you've totally lost me there!

Hit post too quickly, is there anyway to change the auto number? Rather than using 0001 etc. Can I preced the autonumber with REF00xxx etc or somethign similar? I guess I could do this by using the input mask? Cheers.

Ok, fair point.

fwiw me.textboxname.text = Now() should be: me.textboxname.value = Now() just to help any one who reads this thread.

Many thanks will use something along those lines.

Ok I've searched through and read about normalization can someone just have a quick once over my grasp of this concept. I am designing a database for service recrods, the database will detail Customer contact details, service records, location and instruments. so I have 4 tables: 1 listing...

Hello (Again!) I have a form that is mainly used for data entry (for call logging). Ideally it will be linked to 4 different tables, however I need to get the basics working. My new problem is being able to look up data that is selected in a combo box to see if it is out of date. I shall...

Thanks for all the help, will test 1st thing on Monday.

Almost done, only prob is I can't figure out how to stop the timer. Obviously I want to do it when the stop call button is pressed but I don't know what the command is. Once again many thanks for all this help.

I can't seem to get the call duration to work, using the start of call - end of call only works when I have closed the call , what I really need is some means of showing the call duration in real time, I'm just getting stuck with the timer click event!

not to worry I've got it sorted by putting the control source as the required field. I'll just get the call duration sorted and date insert and job is a good un. Many thanks.

Ok so I now have a button that will input the start time and stop time into the respective fields. However it does not write these values into the table, I'v almost sorted it! thanks for all the help btw, I'll probably be posting some more questions also, so please bear with me. Cheers.