Please excuse my inexperience, but how does one use the above search method (which I have working) and then upon finding the correct record propagate all of the remaining fields on the form with the data for that record?
Basically, I want it to sort of act like the built-in search function that...
Thanks for clarifying that Dreamboat! It worked great. I had no idea that you could do that. That's a huge wait off of my shoulders. Thanks again.
Aidan
First off, I would like to apologize for my lack of knowledge. I have run into the same problem and I wanted to know exactly where to put the above code into my query in order to have the input mask carry over to the Word mail merge. Please let me know.
Thanks.
Aidan
Hi all,
I have just come across a problem recently and am wondering if anyone else has dealt with it before.
I am using the mail merge function (wizard) from word, which in turn uses a query that I created in Access. Everything works fine, except when I do the mail merge in Word it gets rid...
Yes, Steve these points really do help! Thank you. I would still like to hear if anyone else has some other points to make for or against the idea in my previous post.
Here's another question for everyone that is more in response to Steve's post:
I have heard of people always having their...
I wanted to get a good idea from some of the experts out there on the pro's and con's of using one form for most (or at least your main) data entry. Let me explain my scenario.
I want to make things as simple as possible for the end user in order to avoid confusion and in turn increase the...
I apologize, I know this thread has started to get pretty long, but how would one go about doing this with an option group trying to disable (Enabled = False) instead of hiding multiple fields? I have this code already working:
Function =ShowHide100()
With Forms!frmRegistration!strField1...
Thanks so much Greg. I have not been able to try this yet as I am in the middle of working out another section in my database. I will post when I get a chance to try this, hopefully in a day or two. Thanks again.
Aidan
Further to my last post, ideally I would like to have one command button that when clicked, would look in Table1 and mail merge all records where chkGolfer = True to DocumentA, all records where chkHoleSponsor = True to DocumentB, and all records where chkPrizeDonor = True to DocumentC. Once...
Thanks for the quick response. That definitely gets me started, but how does one go about automating it to select different Word documents depending on the information being merged?
Basically, I want to have one button to click on that will call Thank_You1.doc or Thank_You2.doc or...
Hi haven't been able to find anything in the archives or FAQ on this.
I am relatively new to database design and am currently faced with a unique scenario (I think). I want to try and get some direction on the best way to approach this before I attempt to tackle this task.
I have a db that I...
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.