Search results

Ok heres my code: Dim strSQL As String strSQL = "select [First name], [last name] from [contact details] where [client reference number] = " & Me.Client_Reference_Number Me.txtName = "Appointment Details for " & strSQL But of course this just types out the sql statement instead of running...

Hi, I need to pass a value from a function from one form to a procedure on another form, how can I do this??? Cheers Princess

I have a database that can have any number of appointments booked for each client. Thing is how do I neatly display all of these appointments? I thought I would use a tab control, that would self build based upon the number of appointments. This I have done quite easily however I now need...

Hi, is there anyway to check if a particular form is open, from a different form? I need to update two or more popup forms if a main form is clcicked upon. Thanks Princess

Hi, I have a problem using the seek command, here is the code: Dim rstQuest As Recordset Dim dbsBDC As Database Set dbsBDC = OpenDatabase("BDC.mdb") Set rstQuest = dbsBDC.OpenRecordset("Questionnaire", dbOpenTable) With rstQuest .Index = "ID" .Seek "=", Me.ID If .NoMatch Then...

Hi, I have made an electronic questionnaire for using MS Acess that runs on a laptop and exports data to a floppy disk. I have used a spreadsheet as the output for reasons of size. I have created another database stored on a network that when the user enters a company record they have the...

Hi, I have a combobox which enables me to select surnamess from my database, and another combobox which selects firstnames. At the moment when I select the first names the entire list from the database appears for me to select from. I wish to limit the firstnames to match the surnames ie: if I...