Search results for query: *

I'm not sure if I'm following your post. So, is there any way to update multiple tables via one bound form? Or, must I use an unbound form and write my own Inserts?

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

My biggest problem has been with this "Data Link Properties" dialog that often opens when the Word document opens. It wants me to confirm my data source. So, everytime I get the merge to work without seeing this dialog, albeit with long SQL strings hard coded and extra arguments that...

Ok, well I solved the problem for this string, but I still have issues with other strings over 255 chars. I use the SQLStatement argument to further filter the query that the mail merge is based on. Now, for other mail merges I have SQL statements that are over 255 characters. Is there...

The problem is clearly like to be with this long connection string, below. However, when I cut it down as suggested, I get a Data Link Properties dialog box from Word forcing me the verify my database and table/query to use. The only time I've been able to keep this dialog from appearing was...

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

Thanks, but I'm not sure that will work. My code matches what multiple people have suggested but doesn't work. I still get this dialog to confirm data source when Word opens. I'm wondering if something is set wrong in the db, in Word, or if I need to create an ODBC DSN?

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:= _...

Thanks for the help. I would like to maintain referential integrity, so I need to make sure my updates are done in the right order. How can I control what order the updates work on a bound form?

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'm having this same problem. The subforms are just blank when there is no data. Has anyone resolved this yet? Thanks.

Well, things are working now. I closed and re-opened the database. Still not sure what caused it.

Thanks, but I don't think that helped. The problem is taking place throughout the database, not just in my forms. Would your solution solve that? I tried, but no luck. If I cause an error while writing a query in the query window (for example invalid SQL syntax), or with a table (for...

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

I should have mentioned this before. That code works well and I've used something similar before, but many of my forms have subforms, and each time a user clicks on a subform, they would get prompted to save or not. It would get annoying to be prompted everytime they click on or off a subform...