Recent content by tmc

Hello, Could anyone please help with a query I have that doesn't work! Basically I have a form and want the query based on the input of two combo boxes In the 'field' area I have put: Expr1: [Forms]![my combo box form name]![product category combo box] and in the criteria section I...

hello, I've got some vba code working great to carry over the previous inputs into the next record in a form to save putting it in over and over again when inputing multiple records. However, is there any way to carry over the last input from the last session?? i.e. i have to exit and...

Hello, I have a report that details peoples employee status for the day (on duty, overtime, sick etc) This is gained from combo box selections in a switchboard. My question is - how do i get certain selections to display in specific colours on the report? i.e. i'd like when overtime is...

It's not included on the form because the form only records the employees id number, the location and the date they work. The id number is linked to the employee name in another table. This way when you input the id number on the 'main' form, the employees name matching that number comes up...

bob, a sincere thanks for your time. I'll give those suggestions a go tonight. Thanks again for the help.

I've also just looked at your multi-field index link and will also try this. which method would be most suitable / easy? Would the multi field index work on access 2003?

Hello & thanks for the reply. I do use a form but thought the best way to prevent the duplicates over the two fields was at table level, sorry - i'm a real noob at this! If i was to use the beforeupdate function then what would i have to put there to prevent the duplicates? I've used the...

Hello, I wonder if anyone could please help, I have created a table for logging employee attendance and dates, among other things, and would like to find out how to prevent the same employee ID being entered on the same date, twice. My table structure needs duplicates of the ID number and...

Hello, I wonder if anyone can please help? I have created a form with employee id numbers (among other fields) and within it a subform that is linked to the ID number form and will display the employee's name when the ID number is input. So far so good! However i would like to disable...

Dcrake, Thanks very much for your reply - i understand what you are saying and my form has only 8 controls but one of the controls is the employee id number, lets say No: 14. Then i''d like the dialog box to say - 'about to update No: 14 - John Smith' without the user having to type john smith...

message to mods: please don't delete as a duplcate post again - i only moved it here because i put the original post in the wrong section. I explained there that i have moved it here. I really need help with this and deleting it won't help! thanks! Hello, I hope you could please help. I'm...

sorry, i just realised this is probably most suited to the forms section. Moved.

Hello, I hope you could please help. I'm setting up a simple access programme for work but one particular problem i'm stuck on. Basically before i update a record with persons employee id, work location, duties etc i have got it to come up with the 'you are about to update record, ok to...