Search results
-
R
Export an Access database structure (i.e. no data)?
If I want to duplicate just a table, I can easily select "structure only" under paste options. Is there an easy way to do the same thing for an entire database (tables, queries, etc.) all at once? In short, someone has a database. They're willing to share the database itself, but not... -
R
Adding a record to a different table
Obviously a VBA amateur here- I have a bit of code triggered by an event on a form. How do I insert a record into a table that is different from the table the form is based on? Is there a simple VBA statement I can insert into any code that pastes the data string into a different table...- Rhythmdvl
- Thread
- Replies: 7
- Forum: Modules & VBA
-
R
How do I get a field to remember previous entries?
I am entering notes into a memo field on a form. Beneath the field, I'd like to be able to enter keywords. At the end of the year, I'd hope to use a query-based report to make an index of the notes, but I'd like to use the same keywords as much as possible to minimize the size (and so I don't... -
R
Using an inputbox to set the default value
I have form for entering new records into a table. Each time the form is opened, one value (mailing) will remain the same for all records entered during that session. I'd like to have an inputbox pop up when the form is opened asking for the value, set the DefaultValue of that field, and display... -
R
Filling in fields on a form based on an outside table
I have two tables and one form. Both tables share the same structure. Table one: Inventory Items contains fifty thousand records, the entire nationwide inventory Table two: Missing Items is a list of inventory items not found during an audit Form: Simple data entry form (actually, it is a...