Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro link to an Access table
I am developing Excel worksheets that are subsequently
imported into Access tables. A typical worksheet is entitled "Request for Information," and requires the user to input a unique number, such as 1. The cell is formatted to display "RFI_001", which corresponds to the key field in the table. The user must know what the next available number is in the table. I'd like to create a command button on the Excel form that includes a macro that does the following: 1. Opens Access. 2. Opens the database. 3. Opens the appropriate table. 4. Finds and reports back the next available number. Note: The importing process, as first set up in Excel with ranges, etc., and then completed manually within Access, works well enough, although perhaps not very elegant. For now, I just want the user to know what the next available number is without thrashing about to find it. Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking/amending the external source link to an Access table | Excel Discussion (Misc queries) | |||
How to make the Embedded Excel file link to the table of Access | Links and Linking in Excel | |||
Link an excel sheet to access table with pics | Excel Discussion (Misc queries) | |||
Pivot Table - ODBC Link to Access db | Excel Discussion (Misc queries) | |||
Link Access table to Excel worksheet | Excel Discussion (Misc queries) |