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

Thanks for this Scott. However when I try this it doesn't actually print the merged data - instead it prints the template! What are you setting wApp as? Cheers Graham

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

This helped me to do exactly what I wanted - many thanks.

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

Funnily enough all I did was de-select the library that the code was a member of, clicked on "OK" to go back to the code, went back into "Tools-References" and then re-selected it. It now compiles fine........not entirely clear why I had to do this but if it works it works...

Thanks guys - I think I've got this fixed now!

I've checked through all of the ticked libraries and their pathnames do match, but in all cases there are multiple copies of the same file in various locations. Do you think this is what will be causing the problem? I'd rather not remove them unless I'm completely sure!! Thanks again Graham

French, when you're in the Visual Basic Editor click on "Tools - References" - this then brings up a list of items with checkboxes next to them, these are all the libraries that can be used with Access. You'll only need a certain number checked e.g. DAO Object Library, etc. I think...

Thanks for your responses - all of the correct libraries are installed and I've had Access re-installed twice, but same problem! I'll play around with removing and adding references as suggested though. Thanks again.

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

Got it to work! Thanks to everyone who helped me with this. Graham

Had a crack at using this logic, but my syntax is wrong somewhere along the line - this is an example of what I'm using: strDateWHERE = "qryPerformance.dtmPerfDate = " & "#" & Format("Forms!frmPerformanceReport.lstPerfDate.ItemData(varDate)", "mm/dd/yy")...

I tried isolating the date WHERE and it returns nothing. The date format thing is something I considered but I'm passing a value into the query in the same format as the records it's looking up to, so surely they would match, even if they were wrong? Also, I'm not sure how I'd go about telling...

Seems to make a lot of sense.......thanks for your help again, mate. Graham

I've concatenated the data into one field. What I want to do is somehow get the listbox to read this data back into it so that they appear selected when the user goes back in. Is this easily done? Thanks for your response.