Search results

Cheers! That worked a treat cheers!!!! :D

Hello, I want to comine the following queries into one so that I can alter the parameters from a webpage. I have a users table that has the department in and I have a TimeTable Table which has dates and option codes. I need to select everybody in a department in the example it's Logistics. I...

The on chance does run the code the problem is that the text box that I am typing in does not take the value until I loose focus. So the criteria at point of running is always nill.

Hello, I have a form that has 2 text boxes that I want to use as criteria for a subform. I want the subform to refresh everytime a key is pressed. The problem seems to be that the control does not hold the value until I have finished typing. Is there a way around this?

Ok this ones a little tricky. I want to automate the transfer of records to a word document. I have the following code that creates the word doc and inserts text base on a field on my form. Private Sub Command8_Click() Dim WordApp As Word.Application Dim Documents As Object Set WordApp =...

Printing Problem I've found that if I change the default printer on there machine it works fine. So there appears to be something wrong with the drive. Cheers for ya help anyways.

Hello I work on a network were to sites have access to the same database. I have create databases that use reports which are all setup to use the default printer. However a printer was removed and since then everyone that had that printer as there default can no long preview or print...

Hello, We have added 2 lookup text boxes to a report but when we try to view the report we get the message "Too many fields Defined". All the queries are working ok and we've used the same text boxes on other reports and it has worked fine! HELP! Regards, Matt

if you atre only after the name try using the Dloopup command.

OK what I want to do is build a webpage that displays a list from a query either from SQL or an access query. I dont want any fancy formatting or any edit options. It will only be on a local intranet so there are no problems with that respect. Im just after some advice on how to connect my...