Minty and Isladogs,
As for the DISTINCTROW in the query SQL I posted above, I should say I've never really written my queries in SQL. I normally build all my queries in the access query design window by adding tables and the fields I want to see; add any desired sorting; and then any necessary...
Thanks for your reply Isladogs. See my reply to Minty above to understand my current internet situation. Hopefully, I'll be back up and running tomorrow or Saturday.
BTW: I couldn't see any of the links you provided because I didn't have 10 posts yet here on the forum. This post makes 10 so...
Thanks Minty! Sorry it took so long to reply. Utility workers inadvertently cut my internet cable so I couldn,t get online. I'm now at an outside venue with a public wifi so won't say any more right now. I do appreciate your reply!
ZT
RE: My Popup Frm being "read-only"
Here ya' go MajP...
Without more details it is hard to tell, but there are lots of things that could cause it.
1) You set allow edits / additions to false
Not that I know of??? In Design View:
Form Properties:
Data Entry = No
Allow Additions = No
Allow...
Thanks MajP! I appreciate your help with the ACDIALOG parameter! That worked fine to pause my code. As for the read-only problem, do you have any idea what might be going on with that? I tried adding another docmd.OpenForm parameter (ACFORMEDIT) but that didn't help!
I do really prefer the look...
Thanks much Minty! I do appreciate your help! However, because of the "read-only" problem I was having with my custom pop-up form, I decided to go ahead and fool around with the InputBox instead of the custom form.
The InputBox does indeed pause the execution of my code until a value is...
Thanks much MajP! It took a bit of fiddling to get this new (to me) acdialog parameter to work correctly but it did seem to stop execution of the code; so I'm further along than I was before.
The new problem is that when my pop-up form opened, it would not let me enter the value I'm trying to...
I may yet take you up on your suggestion to take a step back and explain this but, at the moment, I'd prefer going forward with MajP's advice and try the acdialog route.
Thanks for your help! I'll keep you posted! ZT
Nope! I tried setting the pop-up form's border style to "Dialog" but that didn't seem to help. The form opens correctly but the underlying code continues to run!
Any suggestions are welcome! ZT
Thanks Minty for your reply and your welcome!
"Calling form?" Not sure what that means but my pop up form is being opened from code in a "public function" located in a module rather than from code in another form.
I finally got the pop-up form to open and display the correct record based on...
That is indeed a "different thing" and is exactly what I need help with! I realize this post is quite old but hoping Gemma-the-husky is still around to help with this.
I'm not interested in making access wait for a specified time but rather trying to make my access code module (which opens a...