Search results for query: *

Hi I have a button on an Access form that opens some Word files that are linked to queries (via Mail Merge) and prints them. My problem is that it's printing multiple copies of each letter and I don't know why. Most of the queries linked do not have any records in them - not sure if this is...

This is a really strange one! I've got an import button written in VBA that reads in a CSV file to a temporary table and then appends the records to another table. This works fine until I create an MDE file, when for some reason it seems to be trying to append double the number of records (the...

Hi I have some Word documents that are Mail Merged to Access queries. I've written some VBA to an Access form which opens each document, prints them all and then closes Word. It all works fine apart from the fact that for each document, you manually have to click "OK" each time on...

When you're in an Access form, you can use the "modal" property to stop the cursor tabbing to the next record accidently. However someone's pointed out to me that if you use the scroll button on your mouse it takes you out of the current record and scrolls through all other records...

I want to display the "Print Preview" toolbar on occasions when a user clicks on a print button. I put code behind the button to show this toolbar and for most PCs in here it works, however on others the toolbar is not shown. All the ones that don't work only have a runtime version...

We have recently migrated some data from an Access database onto SQL Server. Part of this migration included us moving the largest tables into SQL Server and setting them up as "linked tables" from Access. One strange happening is that one of those linked tables is much slower than...

I've recently had MS Access 2000 re-installed and since then various functions within VBA are not compiling. For example, functions such as "Format" and "Str" are returning the error "Compile Error - can't find project or library". I'm assuming that the...

We have a new server that we want to keep multiple Access databases on. Each of these databases curently have their own MDW files. Is it possible to allow each of these databases to sit on the same server but still be joined to different MDW files? I always thought that the workgroup file was...

If you select some values from a multi-select listbox, then save and re-open the form that it's in, these selections disappear. Do you know if there's any way that when the form is re-opened, these selections can still be there? I know you can do this for combo-boxes using VBA but I'm...

I have a report which is based upon a series of user selections in a form, the last of which is a listbox containing dates. I have a RUN REPORT button which takes all criteria into account (builds up a WHERE string) and then uses docmd.OpenReport and the WHERE string to display the report with...

I have a database which all of a suddent will not open! When I try to open it I get the message "You do no have the necessary permissions to use the "databasename.mdb" object. Have your system administrator or the person who created this object establish the appropriate...

I'm trying to do the above in VBA code. I have a report that has the RecordSource property set to a certain query name, however on occasions I want this report to run and base it's results on other queries. I've used the [Filter] part of the "Docmd.OpenReport" method to do this but...

I've used this to package up a couple of databases so that I can get users who don't have Access on their PC to use a run-time version of them. The user can install the databases ok using the "setup.exe" file, but when they try to open them a username and password are prompted for -...

I have 2 tables: one that stores details of projects (project name, manager, sponsor, etc) and the other stores status reports that are basically project updates. Each project record will potentially have many of these updates. What I want to do is create a query that will display only the...

I've got a query that I want to restrict so that it only shows one record. Because it is sorted by date in descending order, I'd have thought that if I set the "Max Records" property to 1, then the latest record would be the only one there. WRONG! The query still returns all records...