| Thread | Last Post | Replies |
|
| Macro to move through a list of Names | 30 Apr 2007 16:56 GMT | 1 |
Please help, I am trying to build a macro that copies the first name on the list, pastes this to a locaiton, pauses to allow for other calculations to occur and then moves to the next name on the list. The past location
|
| Shift + F9 | 27 Apr 2007 10:42 GMT | 2 |
Morning All i require some advice how do I create a Shift + F9 command as a marco to refreash my data within a form,, i can see the data wihtin the querry however the form only updates after the above command,, i have tried the refreash and
|
| how to run a query upon a form closing | 25 Apr 2007 23:44 GMT | 1 |
I'm building a macro that will open a form and once the form is closed by the user, I want the macro to then run an append query. How would I accomplish this?
|
| SendObject Macro email address incorrect for newversion of Lotus | 25 Apr 2007 21:30 GMT | 1 |
I have a macro set up to e-mail (via Lotus notes) a report in Snapshot format to several different e-mail addresses. It had been working fine, but one of my users recently got a computer upgrade and now in the e-mail address line gets totally messed up when they use the macro.
|
| Combining query statements | 23 Apr 2007 17:54 GMT | 1 |
I have a macro that runs a query to update a field in my Access table from a linked table from another database: UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.UCDEF =
|
| TransferSpreadsheet | 23 Apr 2007 16:19 GMT | 2 |
I have a macro where I use TransferSpreadsheet to export a table into excel. The file path where the file is saved is always the same and the last character of the file name would vary every week: example - Input_Week1.xls, Input_Week2.xls...
|
| MS Access Macro - Yvonne Martinez | 23 Apr 2007 15:04 GMT | 2 |
Hello, I am sending out an e-mail using an MS Access Macro. It works fine but I need to shut off the pop up security message " A program is trying to automatically send e-mail on your behalf..." How can I default it to always pick Yes. If I need to do a VBA Module please let ...
|
| importing external tables by code | 23 Apr 2007 01:30 GMT | 1 |
i need to import external dbf tables into an access database in CODE. i can do it easily by hand by going to File/Get External Data/Import. but i need to automate it. how can i do it in vba or as an access application within visual basic.
|
| Create a custom form to maximize and minimize a form | 23 Apr 2007 01:28 GMT | 1 |
Would somebody tell me how can I create a custom form popup to maximize and minimize my access form Thanking you in advance for your help! Fred's
|
| one question | 22 Apr 2007 13:00 GMT | 1 |
Please tell me how can create splash form in access. Tank you.
|
| Auto Confirmation after running update query | 21 Apr 2007 22:28 GMT | 1 |
I am running the following query through a macro at the end of every day through the windows scheduler: UPDATE ItemMaster INNER JOIN AMFLIB_ITEMASA ON ItemMaster.ITNOIM=AMFLIB_ITEMASA.ITNBR SET ItemMaster.UCDEF =
|
| Macor and Action Argumants | 20 Apr 2007 12:04 GMT | 1 |
I have a Macro running from a command button on my "offer form". In the Macro I have one Action "Open report" with Action Argument "Print". I would like that only the "offer report" is printed for which I wrote the offer - that means I would like to filter the "offer report" by ...
|
| How can I transfer data from a table to othere table? | 19 Apr 2007 21:14 GMT | 1 |
I Want to transfer data from table1 to add in table2
|
| Creating E-mail appointments or Tasks | 19 Apr 2007 19:59 GMT | 1 |
Good Morning all, I have a maintenance DB. in this DB i create Work orders. In our last meeting they wanted to have the accessability to send an e-mail(appointment) or task to the individual that was responsible for repairing the problem.
|
| Looking for a way to make a Query or Find and Display multiple records using only part of field | 19 Apr 2007 05:56 GMT | 1 |
I want to be able to enter only part of a field like in the Find command, but I want to display all records that match the partial field entry. Example: I want to find and display all records that begin with 'sm' or 'a & b', because the database table has lengthy
|