Search results
-
T
Query based on changing field and criteria - help please!
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... -
T
carry over previous inputs in form from last session??
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... -
T
Change text colour on report dependant on combo box selection??
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... -
T
Preventing duplicates of two pieces of data?
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... -
T
prevent clicking on sub-form trying to update 'master' form
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... -
T
moved: Update record dialog with exact confirmation on which fields to be updated?
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... -
T
Update record dialog with exact confirmation on which fields to be updated?
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...