Search results for query: *

I recently used the Upsize Wizard for the first time, creating an ADP project. The tables and queries were upsized to tables and views or user-defined functions and I was able to fix any that weren't upsized correctly. My problem is with my forms which are bound to queries (views or...

I had created a mail merge using Access and Word that was working fine and then, it seems, all of the suddent I am getting an error "String is longer than 255 characters" at run-time while executing the code below. Clearly the code is longer than 255 characters, but there was no error...

The code below is performing a mail merge in Word, but it is opening the document twice, first the original then a new, unsaved version. Is there anyway to just open the document once with the correct new data source? Or possibly close the original, keeping it unchanged, and giving the user a...

I've been working on this mail merge for a while and can't get it right (Office XP). I want the document to merge from a query that is already in the database and then to be filtered to only the record that is showing on the form. The code I've found in other threads is all similar but doesn't...

I am trying to use a form button to open a Word MailMerge document and populate it's Merge fields with the data from only the record showing on the form. I generated the following code to do this by recording a macro in Word. ActiveDocument.MailMerge.OpenDataSource Name:= _...

I am trying to use a form button to open a Word MailMerge document and populate it's Merge fields with the data from only the record showing on the form. I generated the following code to do this by recording a macro in Word. ActiveDocument.MailMerge.OpenDataSource Name:= _...

I have a bound form based on a query that selects from multiple tables (6-8). Many of the foreign key relationships are integer ID numbers. The user will enter all of their data, and I have set up the BeforeUpdate event to fill in the appropriate key values to complete the records. However...

Has anyone else seen slowdowns in Access while using a Wireless Network Card? I've been having to stop the wireless card while using Access (working with forms/VBA) or else changing windows or executing commands take 10-12 seconds to complete. Any help is appreciated.

I wrote a large query that contains multiple subqueries and joins. I can execute the query and see my results, however when I try to save it, I get the: "Microsoft Access has encountered an error . . . and has to close." When I reopen, an empty query with the saved name is all that...

I think, while writing VBA code for error handling (or doing other work on my forms), I disabled all Access error messages. I am now trying to write a SQL query and no error messages pop up when there are errors in my syntax. Now, I can't figure out what exactly I did to cause this. Can...

On my form, I am validating and giving the option to save a record before closing. I coded a button to do this and disabled the 'x' close button, but how do I prevent the user from closing on the 'File' menu or using Ctrl-F4? I tried using the 'Close' event to perform validation but that's no...

I have a form with multiple subforms each of which I can view and edit except for one. There is just a gray bordered box where the subform is. None of the controls appear. As far as I can tell the properties are the same for this form as the others. Any ideas? Thanks for the help.