Recent content by Rhythmdvl

Ouch, methinks. I'm awfully sorry to be pedantic about this, but I'd like to be sure I explained myself before I give up the proverbial ghost. There's no built-in function to flush all tables? This is something I could do myself, but since the people I'm asking are not my client, are doing...

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...

Hello again, I really hate to be thick about this, and hope I am not wasting anyone’s time. I do thank everyone for the help that I’ve gotten so far, but I have some nagging questions that mean either a) I wasn’t clear enough in what I was trying to do, or b) there really is no simple way to...

Hi Rich, Do I need to create an append query within the code every time I want to add a record to a different table? There is no way to refer to a different table without all of the steps involved in making the query, something like a variation on DLookUp? Here is a bit about what I am trying...

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...

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...

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...

Answering my own question Whew. Thanks very much for the help above. I just figured out how to accomplish what I wanted to do in my last post. I pushed the lookup boxes into the form's header and put regular ol' bound text boxes in the detail section. I added a button in the search area that...

Getting there… I have placed two combo boxes at the top of my form, one keyed to Property Number and one to Serial Number. I have a toggle button that lets a user switch between the two. I can display the results of all needed fields on my form using ComboBoxPropertyNumber.Column(X). The...

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...