Ok. That was the simple part. What if the form is not open and consequently not passing a value to the query. You get prompted to enter the value for the form and list or combo box. Is there a way that if the form is closed or is passing a null value to not prompt for the parameter value but...
In linking to a task folder, is there a way to get all of the fields from a specified task folder? (at least instead of the 4 or 5 fields that are inserted into the Access table)
Application.Echo False
code to open
code to output
code to output (cont)
code to close
Application.Echo True
... and they won't know you took the easy way. Happy OutputTo-ing.
That makes it too easy. However, it does work. I thought it a conflict between a timer_interval in my automatic database shutdown in the event that the user did not use the db for 30 minutes. The funny thing is that it works (without opening and closing) in design mode where you override...
After doing a bit of digging, I found that I have the same problem. Just didn't think nothing of it until trying to output the reports automatically to email as an attachment.
Here's what you need to do.
1. Save the forms as a report.
2. Go to the main form and locate the subforms.
3...
I have a similar problem. However, I set Box and in certain cases, Box2 = to a string. Box and Box2 are the names of unbound text boxes. I can set other fields or control values to the value of box. However, even step through in Visual Basic, box2 becomes (and before some changes box did...
If it gets too big, you could make a button on your startup form. You'd have two databases -- one with pop-windows and one without. The code attached to the button would open the other db and then close the current database.
I like the look of hiding the access window. However, all windows...
There is a FAQ on how to do this. It works well. Unfortunately, I don't have FAQ number. Do a search for "Hide Access Window" and you should be able to find it. If not, email me, I will forward the code that the expert posted to the FAQ.
The new look is impressive -- however, you...
It is said, that if it isn't broke, don't fix it. However, I believe computer folks strive to make things better and faster.
My mail merge with Access and Word works fine. In word, though, I use templates vice documents. Is this just personal preference or is there significant performance...
See Microsoft Knowledge Base Article - 207703
or cut/copy the following link. I used it and it works pretty good. I added some code to make it more versatile. Make sure you head the warning in the article: If while copying, the file changes, it could corrupt the copied file (destination). I...
I am having the same problem. My autokeys macro was working just fine -- set to function keys. Now they don't work. In fact, I tried creating a new database with a new autokeys macro. It doesn't work there either. Is there a setting within Access that allows the autokeys macro(s) to be set...
{F1} is the default for Help. I created the Autokeys macro and it runs the code associated with the key pressed. It may be fairly safe to say that the autokeys macro overrides/takes precedence over any defaults. If I need to be corrected, please let me know.
Thanks for the info. As soon as I sent the reply, I figured that there was a control that needed to be referenced -- I added the status bar control. What I am looking to do is affect the Access Window status bar vice the form status bar. Can the form status bar be set as the Access status...
I tried this. However, I receive an error that variable is not defined. "StatusBar1" is highlighted. Does this have to be defined or is there a reference that must be selected. Thank you,
Myk
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.