Search results

  1. J

    Remove HELP Box from Menu Bar ?

    In Access 2002 - When displaying a form, a HELP box appears on right side of the screen level with the menu bar ("Type a question for Help"). Have used a custom menu built in a macro. Have Main Menus and Toolbars shut-off in STARTUP, yet this little monster keeps appearing. Can't find anything...
  2. J

    Changing margins & page layout programmatically

    Can you programmatically set the margins and page orientation of an Access 97 report ? For some reason one of our reports insists on changing it's pre-defined items when it needs to be printed. Only occurs once in a while. So for consistency we would like to be able to 'tell it what to do'...
  3. J

    Access Reports to PDF format

    We've been looking at two products which allow selection to print PDF files from an Access Report when printing. What we would like to know has anybody used either of these products and most importantly can either (or another) be programmed using a macro or VB code to bypass the SAVE AS window...
  4. J

    Code to Mark Record w/Date Data Changes

    Does anyone have the code for marking a field like "Date Updated" with today's date ONLY IF DATA HAS CHANGED on that record's input via a form ? Any suggestions greatly appreciated. Access 97 version. Thanks. JT
  5. J

    Communicating with OLE server and Drawing Joins

    In our training room this week where we recently re-imaged the hard drives of the PC we had the following two problems. Hopefully someone can shed some light on ways to correct them. We are using Access 97 and Windows 2000. 1) After opening a database, then when opening a table the students...
  6. J

    Writing Access Data to Excel

    Is there a way to send Access to Excel and specify to 'Which Sheet' I want it to go to. For example if I wanted to send data to a sheet named "January" in an Excel workbook file named "2003 Data.xls". Any suggestions would be greatly appreciated. Thanks. JT
  7. J

    Calendar-style Report

    Has anyone ever created a monthly calendar style report in Access whereby a user enters a list of items to a table through an input form and they would fall where they belong on a particular day(s) in a monthly-look calendar when printed ? Is this a 'dream' wish or can it become a reality ...
  8. J

    Using Ctrl-F to bring up Find Window

    In my database I've always told the users they can go to a field on the screen and press Ctrl-F to activate the Find window, but I notice yesterday under Acc2000 that it brings up a Find/Replace window. Can I limit what it brings up to the old fashioned FIND option ONLY ?? Don't want them using...
  9. J

    Going from Tab to Tab on a Form

    Using this example works for going from Page 0 to Page 1, but when I use the same code to go from Page 1 to Page 2, etc. I get a run-time error 2163 : The page no you used as an argument doens't exist in the form. The actual form I'm using has a page index property which runs from 0 to 5 (6...
Back
Top Bottom