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

    "The Data Has Been Changed..."

    You are correct AceMan. When I tried the Requery of Form A, it made the first record the current record, which is not what I want. Saving the primary key before the requery and returning to it after preserves the position of the current record. I will go ahead and use the Requery method to...
  2. Wrangler36

    "The Data Has Been Changed..."

    Thanks MajP. I tried the Requery method instead of the Refresh method and it does indeed work. I'm not sure why the Refresh method does not work because no records are being added or deleted, the data is only changing and the recordset still meets the query criteria. I guess I have no choice...
  3. Wrangler36

    "The Data Has Been Changed..."

    I have two forms. Form A is bound to Table X. Form B is bound to Table X and Table Y, but only one field from Table X is ever edited in Form B. The problem is, once that field that the two forms have in common is edited on Form B and Form B is saved, when I return to Form A (using a back...
  4. Wrangler36

    Word Automation - Eliminate Screen Flashing on Open...

    JerryKlmns, I put the WA.Screenupdating=False command just before the .Documents.Open strPath & "File#.doc" line, but it had no effect - I still see the screens flash as the 3 files are opened. Are there any other ideas???
  5. Wrangler36

    Word Automation - Eliminate Screen Flashing on Open...

    I am using automation to open three Word files from within Access. I would like the Word application to be invisible until the three files have been opened. They are each being opened in their own windows. I am trying to eliminate the screen flashing that the user sees when the three Word...
  6. Wrangler36

    Format text after using Find command...

    Thanks fumei. That's what I was missing. It works now!
  7. Wrangler36

    Format text after using Find command...

    I'm having a little trouble formatting some text in a Word document. I'm using the "Find" operation to find the first, and only, occurrence of some text. The steps I need to carry out are: 1) Find the "Registered" trademark symbol 2) Set it as Superscript 3) Find the web address...
  8. Wrangler36

    Attach a template to a Word Document...

    Thanks PHV. That worked great! I now have another issue with Word, but I will start another post, since it is unrelated to this one.
  9. Wrangler36

    Attach a template to a Word Document...

    I did a search on the forum and could not find an answer to this question: I need to attach a template file (myFile.dot) to a Word document (myDocument.doc) located on the local disk drive (C:\myLocation) from WITHIN Access, then I need to open the Word document (myDocument.doc) and leave it...
  10. Wrangler36

    Pass parameter to query...

    Ok. I will give your method a try. Thank you!
  11. Wrangler36

    Pass parameter to query...

    Thanks Seaport. Can you briefly explain the reasoning behind your second suggestion. Are you saying that each query object is tied to each user's logon name? So if you delete it using CurrentUser, you are only deleting one user's copy of the query and creating a new one for them - and the...
  12. Wrangler36

    Pass parameter to query...

    Seaport, the next step after I get the selected items from the listbox is to output the data from the query so that a mailmerge can be run from the data in the query - this is the next stmt: DoCmd.OutputTo acOutputQuery, "myQuery", acFormatRTF, strDataSource, False Two questions: 1) Can I use...
  13. Wrangler36

    Pass parameter to query...

    My apologies! I left out some important information. I define the query definition with this stmt: Set qrydef = db.QueryDefs("myQuery") The next stmt is supposed to assign the items selected from the list box to the parameter in the query (this is where my error is)...
  14. Wrangler36

    Pass parameter to query...

    I have a listbox and I need to pass all the items selected to a query. 1) If the result I want to pass is: In (2,3,4,5) 2) and I store this in a text box on my form named "textbox" 3) And the query definition is: qrydef![Forms!myForm!textbox] = Forms!myForm!textbox I'm getting the...
  15. Wrangler36

    Duplicate a recordsource from a Form to a List Box...

    Thanks MajP. This will accomplish the job!
  16. Wrangler36

    Duplicate a recordsource from a Form to a List Box...

    MajP, If the listbox has the same recordsource as the form and I requery the listbox after the form is updated, instead of displaying all five records, it will only display three records - because remember that the user has updated two of the 'Name' fields since the form has been opened. What...
  17. Wrangler36

    Duplicate a recordsource from a Form to a List Box...

    I want to populate a listbox using the records displayed on a form, but I can't use the form's recordsource because after the form is opened using the recordsource, the user will make changes to certain fields that will change the contents of the recordsource if the form were to be re-queried...
  18. Wrangler36

    Display data from multiple records in a single field...

    Thanks PHV! That is exactly what I needed. I have to remember to check the FAQs before I submit my posts.
  19. Wrangler36

    Display data from multiple records in a single field...

    I have a table that displays data in the following format - (same field/multiple records): ANIMAL TYPE: DOG CAT HORSE RABBIT LION TIGER I need to display the names of the animals in a single field of a data entry form in the following manner: ANIMAL TYPE: DOG, CAT, HORSE, RABBIT, LION, TIGER...
  20. Wrangler36

    Is the active object a form or a report?....

    Thanks MajP. I knew there had to be a built-in function available. The Application.CurrentObjectType works great!!!

Part and Inventory Search

Back
Top