| Thread | Last Post | Replies |
|
| Search macro that only open the one record in the form PLEASE HELP | 16 Jun 2006 23:11 GMT | 2 |
I have a search macro that is search from a command button on a form. Here is my problem. when I use the search it only open the one record you can not then page and see any of the other records. you can close the form and re-open it and then see all the records. Please help ...
|
| Restore Deleted Macro | 16 Jun 2006 20:37 GMT | 3 |
Still slow after the England game and deleted a macro this morning by mistake which I need to restore. I've not shut down the database as I remember something about keeping it open means you can recover deletions? Can't find the original article I saw a few months ago...
|
| email / hyperlink field / outlook express taking over | 16 Jun 2006 19:29 GMT | 1 |
I have a form that includes an email address. first of all i would like to avoid having to type "mailto:" in front of the email address, but if i don't, the program tries to open the website. if i have notmynamex@yahoo.com, it goes to the yahoo website, instead of opening
|
| CHECK FIELD FOR PRINTING | 16 Jun 2006 19:23 GMT | 4 |
I have a field on a tbl I update witha update query. I want to check that field, that record, for >= 50.00. If it is, I want to show a form asking if usr wants to print a report (coupon) or not. If yes, I want to subtract 50.00 from the fld and print the rpt, if not, end. I tried ...
|
| Help text when using Switch board Manager | 16 Jun 2006 14:43 GMT | 2 |
Hi, I am not sure where to ask this question, but I want to do the following: I have created some macros to update tables in a database. I have added these macros to the Swichtboard as a separate switchboard page. Now I want to have a message appear when the user clicks on this ...
|
| Body uitbreiden naar meerdere regels | 16 Jun 2006 14:26 GMT | 2 |
Hoe kan ik mijn body naar meerdere regels uitbreiden? Heb een makro waarin body staat. Al wat daar ingevuld word komt op de pagina van de e-mail. (Sub Mail_workbook_Outlook-->With OutMail-->.Body = "Dit deel uitbreiden naar meerdere zinnen"
|
| Data transfer | 16 Jun 2006 09:47 GMT | 2 |
I want to transfer data filtered by a query from Table 1 to Table 2 and delete it from Table 1 how do I do this using a macro? Thank you for the assistance.
|
| Exporting tables to Excel | 16 Jun 2006 09:40 GMT | 13 |
I am trying to export an Access table to an excel spreadsheet with the date appended on to the filename i.e. OutputTo excel with today's date on the end of the filename, any ideas how I can do this?
|
| Macro button to search directory | 16 Jun 2006 07:55 GMT | 1 |
I want a command button within a form that will search a specific directory on my hard drive for a .jpg file. The macro should use the field "Type" from the form and find the .jpg file that has the same name as the current value "Type"
|
| Output To Action - Auto Save | 16 Jun 2006 07:47 GMT | 1 |
I'm using Output To Action to an excel file. The file overwrites the existing excel file each time. I'm using scheduler to launch the macro. unfortunately, I can't seem to get rid of the "Do you want to overwirte the existing file prompt" so the overwrite doesn't complete if ...
|
| MDE Macro Problem | 16 Jun 2006 07:41 GMT | 1 |
I have a database that I created that contains several macros. The macros work fine on my PC (in both the MDE and MDB versions), but when I go to another PC, the macros will not work. It says there is an unresolved conflict. I am using a shared drive that both myself and my
|
| Macro on switchboard | 15 Jun 2006 21:09 GMT | 3 |
I have created a macro to print a single page report without viewing the report and placed it on my switchboard. When I click the command button associated with the macro it not only prints my report, it also prints out a picture of my switchboard. Did I not do something right?
|
| Exporting Data | 15 Jun 2006 20:58 GMT | 1 |
I'm trying to write Sql Server view from 3 tables into a query and then export that data in view to a text file. I want to do the transfer on click of a button. I'm trying to do it through TransferText but It does not recognises the view created in the SQL Server.
|
| exporting data to excell | 14 Jun 2006 22:11 GMT | 6 |
I am trying to run a macro to export the results of a query to an excell spreadsheet. I know you can specify the path of the file to output the file to, but can you specify which cell to start in? What I really want to do is have the spreadsheet set up with some formulas and ...
|
| Run Macro without Prompting user | 14 Jun 2006 13:19 GMT | 5 |
I'm have a macro that clears out a table and then adds new data. My question is how can I make it so that it will do it without prompting the user yes/no to delete the rows or add new rows to the table?
|