Search results

I have recently removed a table which was much larger than necessary and replaced it with a smaller table linked to others (which effectively does the same job as the original table). I have also added a handful of new forms and queries to accommodate this change. As a consequence, the mdb file...

I have a form which is used as the basis of a query to choose which people a user wants to e-mail. Once a user has selected various options on the form (used as the basis of the query) I want them to click a button which makes the first form invisible and opens a new form containing a text box...

Not sure if this is appropriate for the code repository but anyway… here is one solution to a problem I couldn’t find a post relating to, and I thought it might be useful to others, especially novices like me. *Note -it will modify all the relevant data in the RecordSource of the relevant form...

Probably a very simple solution, but I've search the forms threads and nothing seems to be coming up: How do I change the default height of a form using code? Eg - to set the width and height of a form showing continuous records to 17cm. Thanks Is

I have an autonumber field in a table which is linked to fields in multiple other tables. These existing numbers cannot be changed without having to change all the corresponding data in the other tables. I have been testing the database by adding test records to check queries, new pieces of...

Not sure if anyone's posted anything similar before, but the below, which is derived from code passed on by Bob Larson (thanks again Bob), is for a 'backup this database' button for users who need clear instructions how and reminders to regularly backup a standalone database. I found that...

The below piece of code, which backs up the database which is currently open by opening another database, has suddenly stopped working in Access 2000 - it gives a "permission denied" error and the option to debug the code. The Visual Basic editor indicates that it is the line which copies the...

I'm trying to open another database and close the original by clicking on a button on a form (the second database will then backup the first). I'm very much an MVB novice and am blundering around a bit, but I've almost got it working using a Call Shell command. Only the path I am using for the...