| Thread | Last Post | Replies |
|
| access 97 macros | 12 May 2005 21:10 GMT | 1 |
I have a an access 97 database with macros. When i attempt to run a macro with the file opened in access 2003 I receive an invalid reference. It continues to work when opened in access 97. I tried converting the file but received the same error. Any help would be greatly ...
|
| Assistance on writing a macro | 12 May 2005 18:52 GMT | 2 |
Help, I am new at using Access and was hoping I can get some asssistance writing what appears to be a simpla macro. Here is my situation: I have a table that has essentially two columns, a RegID column and a Response column (the table is used to record test scores). Each test ...
|
| Macros Fail to Execute in Access 2003 Database | 12 May 2005 18:25 GMT | 2 |
A database I created in Access 2002 utilizes macros to open certain reports. However, when a user opens is up in Access 2003, the reports do NOT open and I believe it's because of the macro security. I tried setting the macro security level to "low" but it will still not open ...
|
| download microsoft visual foxpro where | 12 May 2005 18:11 GMT | 1 |
download microsoft visual foxpro where
|
| E Mail from Access | 12 May 2005 00:52 GMT | 1 |
I am designing in 2003 for a training company to manage it's course delegate data. I need a routine/macro that sends e mail to the addressess of all dlegates on a particular course. Delegates share a common course number. Looking to lookup the email addersses from the access db ...
|
| combo box recordset question | 11 May 2005 15:24 GMT | 4 |
In Access 2003, I added a combo box to a new form (Combo0), set the Row Source to a table and then added this afterupdate event. Private Sub Combo0_AfterUpdate() MsgBox (Combo0.ListIndex & " - " & Combo0.Recordset.Fields.Item(0).Value)
|
| Combo Box - Event Not in List | 11 May 2005 13:18 GMT | 3 |
Access 2000/2002 On my customer details form I have a combo box which is used to find a customers surname and customer reference number and then display the related customer details etc. This all works fine.
|
| How to bold max values | 11 May 2005 08:16 GMT | 1 |
I have hourly data for 30 days (24 data points per day). They are in the same column. I'd like to write a macro to bold the daily max values? Can anybody help me out? Thanks,
|
| TransferText .csv | 11 May 2005 00:46 GMT | 12 |
I have a macro which uses OutPutTo , to output results from a query to excel, which works fine. In the same macro I needed to add to create a .csv file for the same query. I am using TransferText to do that, but unfortunately none of the field
|
| TIME CALCULATING MACRO | 10 May 2005 16:40 GMT | 2 |
I am looking for guidance on a macro which is to "set the value" of a field in Year and Months and Days, as the time difference between two fields entered as dates. I would like to store this value in a format so that it can be searched at
|
| Re: Data Import of Text File | 10 May 2005 16:11 GMT | 1 |
I have created an import process pulling into Access XP a series of Text files using an Import Specification of the "Import Wizard" of ALL text fields/columns for 49 columns. Even the headers are set to text. However, when I run the process, I get a bunch of Import Convertion ...
|
| MS Access - How do I find and fill in blank record? | 10 May 2005 16:11 GMT | 2 |
I have a situation where I want to find the first record that has a blank (or null) value (in a certain field), and then copy the value of the record right above it. Here is a sample type of data file:
|
| Security Warning: unsafe expressions are not blocked | 10 May 2005 13:26 GMT | 2 |
Hi, as i open my database in access 2003, i have the following error: security warning: unsafe expressions are not blocked. Thereafter i get instructions on how to block unsafe expressions, by downloading microsoft jet 4.0 service pack 8 or later.
|
| auto_fill empty cells in a column with existing value from cell ab | 09 May 2005 22:46 GMT | 2 |
I should be grateful for any help/ guidance on the following: I currently get a report in excel format that is very lengthy and worse still gives a field value when it occurs for the first time but not subsequent occurances - ie. the blank cells underneath, in the subsequent
|
| change query using macro in access | 06 May 2005 23:23 GMT | 1 |
I send several reports to several different people on a daily basis. I would like to set up a macro to change the criteria in the queries that I have set up. I know that I can set up the criteria to ask me for the information, but I am looking to automate some of the process. ...
|