Search results for query: *

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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