Search results

I have a continous form which has 1 field in which is a combo box which has a list of names. Once you select a name, the next record down is available for selection. This is because my tables PK is a autonumber. How do i filter the records to only show the names which have not been previously...

Hi, I have a 20 filtered dropdown selections, but you can only see 1 at a time. So once you fill in the 1st dropdown the other appears to select what name you want. I need to know, if say Joe Bloggs was selected in the first dropdown, i dont want him to appear in the second dropdown or any...

Hi, Ive just recently changed my database from a *.MDB to a *.ACCDB. Once i done this my ''New ADODB Recordet" no longer exists. and i ashume i need to use a DAO recordset. I need to add a new record and make the employeeId to + 1. Here is my code i had with the ADODB recordset. Can someone...

Hi, Ive recently changed my table from a *.MDB to a *.ACCDB and ive found an error which worked fine in *.MDB format but when i changed it over it gives me and error. Im wanting to change a field value from "Active" to "Archive" if i click on the archive button. Here is my code: The red...

Hi, I am creating a training database and i have a courses table. and i need to somehow record all of the different employees that attended a course? Any ideas on what i can do to make this happen? My employees have an employee number so is there a way of putting all of the employees...

Hi, I have 2 issues. I am new to vba coding and i am creating a new training management database for a colleague. Firstly i have a tab control which has 2 tabs, a required course tab which is a list of the courses that a enployee needs to take and i have a course dates tab which is the dates...