microsoft.public.access.macros

Clearing Set Value for Date Entry Tue, 30 Sep 2008 08:42:01 -0700
Hello all, can someone help me with this asap please. I have a macro where if I put a checkmark in a checkbox the date will appear in the textbox. However I want the date to disappear if I remove the checkbox, how can I accoplish this. This is what I have [Forms]![frm_view_all_closed_issues]![Reopened Dat ...

how do I email my forms in PDF format directly from MS Access? Tue, 30 Sep 2008 08:31:03 -0700
I have figured out how to email my Scorecards (Forms) from MS Access database using Macro (thanks to all the feedback from you guys). However, I am limited to .xls and .txt format which I don't want. If I can do PDF, the report would look just like the form in Access without converting the data. Any sugge ...

Macros Tue, 30 Sep 2008 07:42:09 -0700
How do I find the Menu Index in a custom menu that I have created with macros? ...

Run macros in 16 other dbs from 1 Mon, 29 Sep 2008 07:54:01 -0700
I have 16 Access dbs and want to run their macros from a "central" db. Each db has a "RunAll" macro that runs all of the macros in the individual dbs. I think that I did this, or had it done for me, in 00 or 01 for another project. ...

How to stop reports printing with blank fields Mon, 29 Sep 2008 03:15:02 -0700
Hi. Newbie here. I have built a simple macro to open a report based on a query, print the reports generated from the query, run an update query to update all the records in a table as printed, and then close. This is with the intention that only records which have been added to the table since the last 'print ...

How to fix hal.dll problem? Sun, 28 Sep 2008 20:39:04 GMT
Was trying a different 2nd drive in my PC and this problem came up when I returned to my original hard-drive configuration: (Nothing was knowing changed on the system drive.) Now, on power up, I get a message: "Please select the operating system to start: Microsoft Windows XP Professional Microsoft Win ...

Original Macro to run Sun, 28 Sep 2008 08:11:00 -0700
I updated a data entry form and deleted the old data entry form. However, I did keep the same form name. A Macro was tied to the old data entry form which displays a warning MsgBox when inputting a social security security number which already exits on existing table. When I test the new data entry form b ...

Conditional Operation of Toggle Button Macro Sat, 27 Sep 2008 11:01:01 -0700
I'm using a toggle button on a form to execute a macro (created by Macro Builder) consisting of a string of OpenQuery operations of MakeTable, Delete, Update, and Append queries. I need to start the macro by comparing the minimum value of a date field in table "A" to the maximum value of the date field in ta ...

Overall Access "Close" Button Sat, 27 Sep 2008 10:13:01 -0700
How can I avoid users from using the upper most close "X" button? or if they click it, I'd like to open a form to confirm they actually want to leave access all together. They are accidently clicking the upper close and must re-open to complete the task. I have controls on the switch board screen that I ...

Saving A database to the desktop Sat, 27 Sep 2008 03:33:00 -0700
Hi to All, I would like help with the following question: Currently I have a database located on a share drive. 500 different user located throughout the country access this database. Their complaint is the database takes to long to open and after it does open it takes to long for the forms to load and r ...

page nr.: page nr. << back 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 next >>