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 Chriss Miller 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. charle525

    How to Adapt Bound Forms to Function in an ADP

    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?
  2. charle525

    How to Adapt Bound Forms to Function in an ADP

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

    String is longer than 255 characters

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

    String is longer than 255 characters

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

    String is longer than 255 characters

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

    String is longer than 255 characters

    ...OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB" _ , SQLStatement:="SELECT * FROM [qryStudentMinor] WHERE tblMinor.AdmitDate >= #" & Me!LetterDate & "# AND tblMinor.MinorType= 'General Education'", SQLStatement1:="", _...
  7. charle525

    Mail Merge Opens the document twice

    ...OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB" _ , SQLStatement:="SELECT * FROM [qryStudentMinor] WHERE tblMinor.ID= " & Me!txtID, SQLStatement1:="", _ SubType:=wdMergeSubTypeAccess ' Execute the mail merge...
  8. charle525

    Still can't get Word Mail Merge correct

    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?
  9. charle525

    Still can't get Word Mail Merge correct

    ...objWord.MailMerge.OpenDataSource CurrentProject.Path, , , , True, , , , , , , "QUERY qryStudentMinor", "Select * from [qryStudentMinor] WHERE [id]='" & Me!txtID & "'" objWord.MailMerge.Destination = wdSendToNewDocument...
  10. charle525

    Access to Word Mail Merge One Record

    ...OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB" _ , SQLStatement:="SELECT * FROM `tblStudents`", SQLStatement1:="", _ SubType:=wdMergeSubTypeAccess This code works to open all records from tblStudents as shown in the SQLStatement:=...
  11. charle525

    Access to Word Mail Merge SQL Query Problems

    ...OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB" _ , SQLStatement:="SELECT * FROM `tblStudents`", SQLStatement1:="", _ SubType:=wdMergeSubTypeAccess This code works to open all records from tblStudents as shown in the SQLStatement:=...
  12. charle525

    Trouble with key values on forms based on multiple tables

    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?
  13. charle525

    Trouble with key values on forms based on multiple tables

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

    Microsoft Access conflicting with Wireless Network Card

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

    On saving a Query, there is an Access error and program closes

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

    Blank / Missing Subforms

    I'm having this same problem. The subforms are just blank when there is no data. Has anyone resolved this yet? Thanks.
  17. charle525

    Accidentally disabled all error messages

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

    Accidentally disabled all error messages

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

    Accidentally disabled all error messages

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

    Ensuring validation before closing a form

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

Part and Inventory Search

Back
Top