Search results for query: *

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

In the newer versions of Office there is the ability. It's under File -> Permission. You have to be using a Windows Rights Managgement client though.

A great site for Excel charts is: http://www.andypope.info/charts.htm I have used it many times.

What about the FollowHyperlink to the path of the application .exe in the OnClick of the button?

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...

Not sure what you are trying to accomplish, but it sounds like you may have normalization issues. Check out http://r937.com/relational.html

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

should read "As far as email them, you should be able to send the databases (.mdb files) as an attachment

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...

Are you calling it when the form opens, or when a user performs some action in that form?

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?

Expanding on my reply, is this something that has to run each week, looking for items since "last friday"?

Build a query with the criteria field for the day/date you are looking for greater than the date for "last friday

Go to http://www.peterssoftware.com and scroll down the page for Inactive Shutdown Control.

Exactly like that. Thanks!