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...
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...
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...
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???
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...
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...
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...
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...
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...
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)...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.