| Thread | Last Post | Replies |
|
| Using TransferText | 23 Jul 2004 11:56 GMT | 1 |
I am using a macro to export a file. How can I make the text qualifier {none} so that the values that I export will not be contained withing quotation marks. Thank you for your help.
|
| RunCommand ClearGrid | 23 Jul 2004 05:28 GMT | 4 |
Why can't RunCommand find ClearGrid when a macro calls it? ClearGrid shows up in the Command listing of the macro page and acCmdClearGrid appears in VBE. Thanks.
|
| Using a Macro to export a query to a .csv file | 23 Jul 2004 04:57 GMT | 4 |
I have a macro that I am using to export a query to an excel file. I was wanting to know if I could export this to a .csv file, without exporting the field names, and with no text qualifier. If I open the query directly, and
|
| multiple macros on one event | 23 Jul 2004 03:25 GMT | 14 |
Is it possible to have multiple macros run for one event (e.g., to run a few different macros on the "On Open" event)? If so, how? Thanks,
|
| OpenForm Macro and If/Then Logic | 23 Jul 2004 03:17 GMT | 1 |
Hi- I have very limited knowledge with Macros and logic expressions. I have created a db with several tables to track employee maintenance. On the main form, the user indicates what type of transaction (a list of values for a field) is to be performed. Based on the value of ...
|
| E-Mail Macro based on date | 22 Jul 2004 15:10 GMT | 1 |
I have an Access Database that resides on our hosted internet site. The database has several fields with customer entered dates. The customer would like an e-mail notification when that date has passed. Is there any macro, .asp script, or program that will allow me to do such ...
|
| Exporting and Adding field | 21 Jul 2004 20:43 GMT | 1 |
I have created several queries in access which needs to be exported as table to in a another database. While exporting the table I want to add another field which is a an autonumber field. Is there any way of doing this??. Any help is appreciated. Thanks in advance.
|
| E-mail warning | 21 Jul 2004 08:03 GMT | 3 |
I Created a macro to autosend HTML page from access 2003 through outlook 2003, but the virus behaviour warning stops the automation till I say yes, send I use this to send lots of e-mails, i need to disable that warnning,
|
| Sendobject | 20 Jul 2004 22:08 GMT | 1 |
I have a database that is in MS Access 2000. But recently we got MS Office 2003. We didn't change the databases that are in 2000. Sendobject used to send a mail with precomposed email text properly when we had office 2000.
|
| Microsoft Outlook - Auto Email | 20 Jul 2004 22:03 GMT | 2 |
Need some help getting an auto email to work Previously I had the macro open the email for me with the distribution group selected. I change the macro to send automatically at the end of the job. But I did
|
| Can the function Format() do | 20 Jul 2004 04:37 GMT | 2 |
let's look at the 1st statement: ? Format(21, "0000") it returns "0021" <-- in debug window I want to raise a question, look at the 2nd statement:
|
| email addresses in a record, click to open email program | 19 Jul 2004 16:42 GMT | 4 |
How do I enter an email address in a record and then be able to click on it to open Outlook/Outlook Express with the email address filled in? Inserting a Hyperlink inserts the same email address in
|
| Send object error | 19 Jul 2004 12:31 GMT | 2 |
I have a report in an Access database that I wish to mail to the interested parties once a week. I'm trying to automate this using a macro and the 'Send Object' method. I have tried different fomats for doing this.
|
| macro to set value in subform | 19 Jul 2004 07:24 GMT | 1 |
This is a repeat cry for help (from forms)! I have a "OrderForm" which contains "Item Buttons" where a user can choose to add items to a subform called "OrderDetails". "OrderDetails" is set to display
|
| removing misspelled words from a list | 18 Jul 2004 18:47 GMT | 1 |
I have used hours on this but I cannot work it out! I want to remove all the misspelled words from a large list of words. In word I do a spell check and then when a misspelled word is found I close the spell checker, remove the word and then do the same again.
|