| Thread | Last Post | Replies |
|
| need to combine 2 table rows into 1 | 21 Apr 2004 08:32 GMT | 1 |
Hi I'm pretty new to Access but have done a bit of macro programming in Excel, autocad lisp and a specialized toolscripting language for CNC machines I've got a pretty simple database with an individual table (for now) that I need to manage a list of timbers. The database gets ...
|
| Combining multiple inclusion conditions in Report Printing Macro | 20 Apr 2004 23:08 GMT | 3 |
I have a mailing label form which prompts the user to check one or more of 6 inclusion checkboxes (member types)and one option box with 2 additional inclusion options (all -or- only those with no email address). What is the best way to deal with programming the variety
|
| Open ODBC table and concatenate field | 20 Apr 2004 19:54 GMT | 1 |
I want to design a marco that will automatically open up a table and concatenate several fields into one field call the NEW GRANT ID. Is there a way to perform this??? If so can you fully explain. Keep in mind this is my
|
| Macro to create report html with current date in filename | 20 Apr 2004 19:50 GMT | 1 |
We need to generate a report html every day automatically. The same report, but have it write the filename out as: OrderStatusMMDDYY.html
|
| Copy from Form to Subform | 20 Apr 2004 14:41 GMT | 2 |
I am trying to copy data from a field in a form to a combobox (dropdown field) in a subform using a macro. GoToControl Application RunCommand Cop GoToControl Forms![_Product_OLD_DATA Query]![Move Productxx].Form![Combo34]
|
| Macro opening Word document | 20 Apr 2004 13:36 GMT | 15 |
I have an Access 2000 db linked to Word 2000 documents with merge fields and Word logic fields. On a form in the db users can click command buttons and open corresponding linked Word forms. The command buttons
|
| Using Conditions In Macro | 20 Apr 2004 10:14 GMT | 1 |
I have a macro, which prints a report (let's call it report 1). The report is based on a crosstab query, which counts "X, Y and Z" (for simplicities sake) values in a table. However, sometimes there's no "Z" to count, and I
|
| How to delete records in Macro? | 19 Apr 2004 23:28 GMT | 1 |
I have created a table structure that I want to keep. However, the records in the table need to be deleted before next appending takes place. How can I keep the table design w/out going to the table to select all
|
| Faxing from Access | 19 Apr 2004 21:32 GMT | 1 |
I am trying to run a macro in Access to fax a report. I am following the instructions from the Microsoft Knowledge Base Article 299016. I get to the macro and then nothing.
|
| Create a variable from a record in a table | 19 Apr 2004 21:21 GMT | 4 |
I want to create a series of tables from a series of Excel spreadsheets. I have set up a table with the list of the spreadsheets called 'stcknames'. I then used a command to go to each record in that table. That seems to work. But I don't know how to access that record and use it ...
|
| Asking for Parameter | 19 Apr 2004 20:05 GMT | 1 |
Hi, I have a database in which the user inputs data into a form and hits the print button and it prints the record they are on (using a macro). Everything was working fine with the user opening each form individually and
|
| Finding Where a Macro is Used? | 19 Apr 2004 04:22 GMT | 1 |
I am attempting to find a problem with a MSAcess app that was written by someone else. I am trying to find where a macro is being used in the app. Tried using the documenter on all the macros but it did not help.
|
| Repeating Macro | 17 Apr 2004 00:16 GMT | 4 |
I am trying to open a form (OpenForm), go to a control (GoToControl), requery (Requery)a specific field within my form, then move to the next record. I have done this but I need it to move through all the records until it reaches the last one. As of now I would have to enter this ...
|
| Copy a record | 16 Apr 2004 20:53 GMT | 1 |
Hi There - I have a database set up with purchase orders. I have two tables which are pretty standard tbl_orders and tbl_orderdetails.
|
| Send Object w/Outlook | 16 Apr 2004 19:49 GMT | 1 |
I have my send object set up to send a report via outlook. It works fine, until I use the startup feature to not show the database window. It will not work and provides a message that reads.... "The command of action "Output To" isn't available now. *You may be in a read-only ...
|