Search results

Hi, I have a search form that takes values from 7 combo boxes and builds an SQL query which then outputs a filtered list. The code is : Private Sub cmdOK_Click() ' Pointer to error handler On Error GoTo cmdOK_Click_err ' Declare variables Dim db As DAO.Database Dim qdf As...

Hi. I am looking for a way to look up the latest reference code of a record, increment it by 1 and then store this new value on the main data entry form - this ref and other newly added data (entered on entry form) then to be added as a new record to the main data table. Main table is cvlist...

Hi all. Over the last couple of weeks I have had some excellent help from the guys in this forum which has meant my DB is very much getting to where it should be. It has to be presented in draft form on Wednesday!! :eek: :eek: :eek: However, I am now at a stage where I require assistance to...

Hi, I am trying to make a sub form that will show ALL the qualifications for an employee on the main Employees details form. The qual details are held in seperate tables. I can make a subform that shows each record singly but it doesnt tally with the record showing on the main form. How do I a)...

HELP!! Can't get multiple records to display Hi all, I am a relative newbie to Access development and have hit a problem I canot seem to solve!! I have a main employees table, a qualifications table and a qual code table. They are all linked appropriately BUT I cannot find a way to display...