Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dcurtis

    Dynamically change subform

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

    Multi-Stage Command Button - Query Criteria -> Record ->Pdf -> Email

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

    Dynamically change subform

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

    Combining Multiple DBF's

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

    Disable the ability to forward e-mail..

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

    Additional Powerpoint charts

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

    How do I open a app

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

    Disable Outlook's Confirm send for one program only

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

    Copy record from 1 table to another on Click

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

    Tools | Startup

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

    Datasheet question

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

    Copy Forms, Queries,Reports, Tables . . .

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

    Exporting Access to Excel (with a wrinkle thrown in)

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

    Copy Forms, Queries,Reports, Tables . . .

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

    Is Not

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

    Is Not

    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?
  17. dcurtis

    Query Based on Last Friday

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

    Query Based on Last Friday

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

    Automatically close the database

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

    Loop through combo boxes and add to table

    Exactly like that. Thanks!

Part and Inventory Search

Back
Top