Search results for query: *

The other database is a cancer database with close to a million records in it and each is over 20,000 bytes in length. We add on average about 28,000 cases each year for just our state. This function was needed because the other program is unable at present to create a batch of similar files for...

Thank you. A variation of that worked.

I wish to create multiple records in an Access table based upon a single record from another Access table. Yes, the records will be identical. Also, the number of records will vary based on user input. These records will be exported to another custom-written database where more data will be...

Thank you. Still nothing happens. As a note of interest, both programs are running on the same PC using the same version of Access. I do know that the module is being called because it asks for the number of labels to skip. It's just not skipping when it reaches the form.

Problem is that a module in one Access database behaves properly. The same module imported into another Access database and connected to the properties "On Open" comes up, asks the question, and then fails to do what it should. Instead of skipping x number of labels, it fills out an entire sheet...

Setting up a web-based Access database is something I haven't done before. Basically, I need some guidance on what I need in the way of resources or what actions I need to perform. A department in our office wants to set up a database on the Internet so that some remote users (3 or 4) can enter...

Please consider this question closed. The simplest solution was to let the user mark a field that the record was to be used for the append and subsequent deletion. Then two queries are operated by pressing a button on the form. If the record isn't marked for append and delete, nothing happens to...

I should clarify that as meaning aside from what Access creates behind the scenes. I know there are procedures set in place and have viewed some of those, particularly the one for the delete function I created on the form using the Wizard.

Nope, it doesn't use any VBA.

My office maintains a tracking database using highly confidential medical records. When a case is closed, we delete the record from the tracking database. What we want to do is copy the non-confidential DateReceived (date), Level(numeric), and Completion status (text) fields for statistical...

The information I posted may not be correct. Upon trying to order a copy of Microsoft Query as was stated was needed in one of the Microsoft FAQs on their site, we learned there is apparently no such product. This left us scratching our heads as to what Microsoft meant in their FAQs. We now...

This problem occurred in my office, too, but my research indicates that the problem could lie with Microsoft. Apparently, the later versions of Word and Access now require a new product, Microsoft Query, in order to handle a mail merge using data from Access going to Word. Old Word documents...