Search results

Can you not instead export the query to an excel spreadsheet (small file size) using the outputto command, then send the file using the sendobject command??? Worth a go... Princess Bretti

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

try setting the control source to be the query for each one. Princess

Thanks for the reply, Unfortunately the ppl who will be using this, are not computer literate and not too bright so I wish to steer away from any non visual displays(datasheets), and multiple windows (can you imagine the clutter?). I think that you have made a good point however and that the...

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...

Thats great thanks! Princess

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

Nope, But thanks anyway Bretti

Thanks but it still doesn't work! Any more ideas? Bretti

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 Peter, What exactly is going wrong? error message, etc. Bretti

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...