Thomas -
With a little modification your code worked perfectly. Thanks. All I did was change from an option box to individual buttons, using the code in the OnClick.
OK, here we go
You cannot send a report from Access in a .pdf format (at least I have never been able to figure it out). However, here are instructions for sending the report in a different format.
1) Create a form that will have fields for all the criteria your query will be looking for...
I have searched the posts and have not found an answer to my particular problem.
I have several subforms on a form. For performance reasons I would like to have one unbound subform control that I can change the source of with the click of a button (well, really several buttons). I don't want...
Try the two links below.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/dbrepjet.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/intrjet4.asp
We have a paging program that sends pages to certain people via email. When the page is sent (via Outlook) Outlook's pesky "A program is trying to access....." comes up. Is there a way to configure Outlook to allow just the paging program around that check?
Sending the email directly from...
If you haven't disabled the Shift bypass key, hold down the shift key while opening the database. If you have, search this site, there are several threads on how to re-enable the key.
Check out Duane Hookom's "At Your Survey." It may be what you need, and if not, should get you well on your way.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
Create a query in Acces that combines the fields you need
Output: OS & ", " & CPU & ", " & RAM & ", " & HARDDRIVE
Save your query and right click on it, select Export. Change "Save Type As" to Microsoft Excel, Select your destination file and click OK.
Create a new database where you want the forms/queries/tables etc. Go to File - Get External Date - Import (or link for tables if that's what you want to do). Select what you want for options and click OK. You will have them in the new DB.
As far as emailing them, you should be able to just...
A command button does not have a "pressed/not pressed" value. Clicking (or double clicking) a button triggers the OnClick (OnDblClick).
Is this "button" part of an option group?
Where are you calling your code from?
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.