Search results for query: *

This query works fine with Access 2007 and on 2 other PCs running Access 2010 but not on mine since a bought a new laptop and loaded 2010. In real time I run the Query from my VBA Code but get the same error if I just try to run the Query direct. This is the error I get :- Undefined function...

I have an access accdb database created in Access2007. It is loaded on another Access2007 PC in the office where it is shared by 2 other PCs using Access2010. It has been running fine for years with around 11,000 records. Lately we have encountered a bug which has happened on two occasions weeks...

I am having problems with Access 2007 which opens a Word Document then does a Mailmerge. The following code works fine to the default printer (which I want to use) BUT !!!!!!!!!!!!!!!!!! I want to set the printer to duplex and use Tray 2 (which is the main bulk paper tray) The tray selection is...

I have a MainForm with a RecordSource of Current_Marshal. In that there is a SubForm with a RecordSource of WWtable They are linked with Ref_No. On the SubForm there are 5 Controls, 3 come direct from the WWtable and fill fine of course, these are 2 comboBoxes and a TextBox.The other 2 are...

I have an Access Table called LogTable which is updated from various events within the Database. It is quite a simple table with 5 fields, Number, Text, Date/Time, Number then Text. I can export the table to Excel ok but sometimes the output stops at a particular record (call it Record x) which...

I want to run various filters on an Access Form then click a Command Button to send an email to all the Filtered Records. The email needs an attachment which is a mail merge document. The fields in the document come from the Form (or its underlying table) that you are viewing. I have used a...

I set up an Activity Table (TestTable) which logs various details as I open/close the database by calling the Function below. This worked ok until I wanted to copy the database to a laptop for remote use and then back to the office PC with this added to the Activity Table. I read that you cannot...

I set up an Activity Table (TestTable) which logs various details as I open/close the database by calling the Function below. This worked ok until I wanted to copy the database to a laptop for remote use and then back to the office PC with this added to the Activity Table. I read that you cannot...

I have DPNSS Route between a Mitel SX2000 and a Nortel CS1000. The SX2000 is connected to the Public Exchange. A call comes in from the SX2000 to the CS1000 and I can see the CLI (say my mobile number for a test call). If I transfer the call to another CS1000 phone the CLI is there. If I...