Search results

  1. J

    Making a selection on two tables and then RIGHT JOIN

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

    Form Subform refreshing

    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?
  3. J

    OLE objects into word?????

    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 =...
  4. J

    Default Printer

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

    Too many fields - report!

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

    HTML SQL connecting

    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...
Back
Top Bottom