| Thread | Last Post | Replies |
|
| Macro Errors | 18 Jan 2006 18:21 GMT | 2 |
When I click a button on a form I get an error saying that a field can't be defined more than once. It then goes to give infomation on 2 macros that I have (name, action, arguements). If anyone could tell me how I could fix this problem it would be greatly appreciated.
|
| Macro's date criteria doesn't work for "last month" | 18 Jan 2006 18:19 GMT | 7 |
I have a form that uses a combo box for filtering dates... when clicked the combo calls a macro and shows records that match e.g. "Today", "This Week", "Last Week", etc. This works great on a single form... however, I now integrated a subform
|
| Go to specific mail merge record in Word | 18 Jan 2006 18:14 GMT | 1 |
Is there a way to go to a specific mail merge record in a Word document after the document is opened using the RunApp Access macro query command? The record to go to in Word will be the same record that is selected on the Access form
|
| Passing a parameters to a macro | 18 Jan 2006 18:13 GMT | 1 |
I have a macro that executes several queries. In one of the queries I prompt for a value to be used within my query. I would like to run my macro without prompting for a value but yet retain that portion within my query. How do I automate this process? Thanks.
|
| Need help with Excel macro | 18 Jan 2006 18:03 GMT | 1 |
I need some help with this problem. I have four ranges in the same worksheet. For example: rangeA (d5:d15)
|
| Import udated data tables | 18 Jan 2006 12:10 GMT | 2 |
Can any one help me with a macro that will import updated data tables into current tables of another database. Thanks Russ
|
| report with combo box | 17 Jan 2006 23:03 GMT | 2 |
I want to dispaly my reports listing (10-20 reports) through a combobox to run it. How can I do that. Please help
|
| find all records within a specified zio code radius in Access | 17 Jan 2006 21:56 GMT | 3 |
How do I create a way to key in a zip code and specified radius in order to have all records in my Access database within that radius come up? I am not an experienced programmer. Thank you!
|
| use combo box /macro to sort | 17 Jan 2006 18:11 GMT | 6 |
I want to be able sort a form by two fields. I don't want to add another command button to the form, so I thought I would use a combo box to select the sort field and then exectute a macro on change. So far, my attempts to exectute this have been futile. I'm able to get the
|
| Import data from a single sheet on an Excel workbook | 17 Jan 2006 17:31 GMT | 1 |
I'm using the TransferData command in an ACCESS macro to import an Excel spreadsheet as a table, and I'm having trouble telling it which sheet to select. Can you give me the syntax? Thanks.
|
| AutoExec Macro problem with ODBC connection failure | 17 Jan 2006 13:21 GMT | 7 |
I have an autoexec macro that exports 2 different queries using TransferText to .txt files. The queries are built on tables that are linked via ODBC to outside product. The first query always transfers/executes right away. The second one fails and I get the ODBC ...
|
| Common Code | 16 Jan 2006 14:11 GMT | 5 |
Access is great for linking tables between databases to share common data bretween databases. Is there any way to share code between databases? I tried to put the code in a comon database and 1 - Delete the module if it exists. This fails because the subroutines and
|
| refresh | 15 Jan 2006 23:40 GMT | 1 |
hi, its me again finally i think my problem is a refresh problem, so: i cannot find any command to refresh my subform. the only thing i could find is runcommand --> refresh, but that wont refresh
|
| Set column width in a datasheet vith VBA | 15 Jan 2006 06:37 GMT | 1 |
Is it possible to set column width for each field in a datasheet with VBA code? Is it possible to hide/unhide columns to? //Lasse
|
| Running DELETE queries from code with no Confirmation prompt | 14 Jan 2006 23:41 GMT | 6 |
I'm running a DELETE query using the DoCmd.RunSQL method. This runs OK, but it comes up with a- "You are about to delete xxx records, continue?" prompt. How can I turn off these prompts for VBA-initiated actions only?
|