Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrchinchin25

    Automatically save a word document upon closing

    Hello, I have an Access database, which is opening up a Word Mail Merge document, and automatically merging it with data from the database. This works fine. Is there any way of coding the Mailmerge document (with all the data in it) to save automatically to a certain location, and to make the...
  2. mrchinchin25

    Open a Word Document from an Access Form

    Hi, I'm trying to develop some VB code to open a Word Document from an Access Form. I did a search on EE and found the following code: Dim doc As Word.Document, wrdApp As Word.Application On Error Resume Next Set wrdApp = GetObject(, &quot;word.application&quot;) If Err.Number <> 0 Then Set...
  3. mrchinchin25

    Beginner Query Question

    I might be being thick, but I was sure that at one time I could use reports designer to test my SQL queries without running the actual report. Somewhere on the query building stage, you could preview you SQL query, and get the basic info shown that you would normally receive from a basic SQL...
  4. mrchinchin25

    Strange Access Problem with buttons on forms

    Hello, I have a problem where a database I am working on will no longer let me create buttons on a form. An error message along the lines of &quot;Cannot find module&quot; keeps popping up. I can't alter the existing form. I can't create a form from scratch. I can't import a working form from...
  5. mrchinchin25

    calculate no of weeks used

    I have a table with data like this: (this is abbreviated) Part Number, Week Number A1 52 A2 1 A3 1 A4 1 A5 2 A6 2 A7 3 I need some way using SQL or a query to get the system to work out how to calculate...
  6. mrchinchin25

    Queries and Sums

    If I have a query that is returning the following fields: Part No, Demand*Setup how can I get the Sum of Demand*Setup for different Part No.s??? eg. Part No Demand*Setup Part Total X 4 6 X 2 6 Y 6 8 Y 2 8 ie...
  7. mrchinchin25

    Outlook 2000 customisation

    Hello there, hopefully someone can help me with this little problem of mine. On Outlook Today of Outlook 2000, it lists a summary, showing a bit of your calender, your tasks etc. on the right hand side, it lists 3 email folders, inbox, drafts, outbox. how can i modify this? (i guess its...
  8. mrchinchin25

    Recordset / Combo Box

    yeah sorry, the references menu shows that a certain carAPI active x control module is missing, and I can't seem to find it anywhere. But we're in contact with the guy who created it.
  9. mrchinchin25

    Recordset / Combo Box

    I have no idea at all! I've never done anything before involving Libraries and .dlls and things.
  10. mrchinchin25

    Recordset / Combo Box

    yeah i do have a missing reference, and the problem is that its stored on someone's (i have no idea whose) local hardrive. I just thought that it was strange that this procedure wasn't working, as I couldn't see it looking at any kind of library etc. Thanks
  11. mrchinchin25

    Recordset / Combo Box

    I'm trying to fix a database with a missing library problem. who can tell me what this code does in english? (i'm hopeless at recordsets) Private Sub Combo8_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst &quot;[ID] = &quot; & Str(Me![Combo8])...
  12. mrchinchin25

    Filters

    I've got a form called (newguest) which has a subform on it called (guestSingle). I have quite a few filters on these forms, which are issued via command buttons. The filter code may be something like: (on guestSingle for example) me.filter = &quot;[Guest] is null&quot; me.filteron = true...
  13. mrchinchin25

    Find Record Problems

    Hi, I've just tried the new code, but its coming up with an error: &quot;The Find Record action requires a Find What arguement&quot; Now in my original code, I had this line: DoCmd.FindRecord [Thursday Guest], acEntire, etc and this brings back the error: &quot;A macro set to one of the...
  14. mrchinchin25

    Find Record Problems

    Yeah that should be fine thanks! I'll check it.
  15. mrchinchin25

    Find Record Problems

    I'm trying to use DoCmd.FindRecord to find a record which is null. Heres an example: In the Form, on each record: I have a textbox called Blank. This is blank (!). I have a textbox called Thursday Guest. Now when i click a button (call it find) i want the control to pass to Blank, and then...

Part and Inventory Search

Back
Top