Thanks for the help. Unfortunately I still can't get it to work using either method. When I use the wizard to create a button to "open the form and find specific data to display" I can't see any of the fields that are in the listbox. The only thing that comes up is 'List0'. It's...
I've searched and can't quite find an answer to my problem. I have a search results form with a listbox in which I would like the user to be able to select one of the records and then open up an existing data entry form baased on the selected record. I assume that since the record pkey exists...
Great post.
For the most part I got it to work beautifully. I do have a problem when entering date criteria such as '<1977' . It doesn't work when entered into the search form but the very same criteria entered into the query itself works.
Thanks much,
Trent
Does anyone know how to automatically extract text from a word document into an new access table. I have text from a book. Each paragraph description is separated by a page break. Within each description there are key phrases that would let me extract dates and other information by querying...
Thanks, Bill, for this good advice.
Can you, or anyone else tell me how to get more information on the method described below? (Maybe using less code if possible) Seems to make perfect sense but I can't seem to find any elaboration in the threads. Thanks much - Trent
An additional way to...
Kevin,
Thanks for the tips. I guess the trouble is that even though I have a pretty goog understanding of the logic, I'm not a programmer by any means. Would you know how to put together the VB to make this work?
Thanks-
Trent
Thanks, Tex. I've been experimenting with the fe - be routine and it seems to be the answer. Do you convert your front ends to .mde? Seems this is the route to go if you have inexperienced users. Also, have you found a solution to eliminate two different users from updating the same record...
Great advice, Daniel! Sorry to take so long to respond. I've been on vacation.
I definitely think this is the right track. The circumstances you describe having trouble with fit exactly. Unfortunately none of these seem to work completely. The problem may have to do with one of the forms...
Can anyone explain what might cause an "Error accessing file. Network Connection may have been lost" error?
The debugger takes me to this script:
Private Sub Command255_Click()
On Error GoTo Err_Command255_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...
Can anyone explain what might cause a "Error accessing file. Network Connection may have been lost" error?
The debugger takes me to this script:
Private Sub Command255_Click()
On Error GoTo Err_Command255_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...
I've developed an application that needs to allow multiple user to access and edit records but when more than one tries to open it up they generally get an error message that says that records have been locked or placed in a "state" by another user. I think it's two different problems...
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.