Search results

  1. A

    Merge PDFs in Access 2013

    Hi, we are moving from Access 2003 to 2013 using Windows 8.1 64bits. We used Leban's code and library to create and merge pdfs. C Creating pdfs can be done with built-in functionality in Access 2013. But I can't find a way of merging pdfs. I've tried Leban's Dlls files but I am getting...
  2. A

    Running .mdb 2003 file in Access 2010

    Hi, We are experiencing the problem with running Access 2003 .mdb file on Access 2010 on XP, it works fine in Access 2003 and even in 2007. The application works, but few subforms displaying blank with white background. Has anyone experienced this problem before ?
  3. A

    Local machine overwrites windows and Access printer settings

    Hi, I've got this problem which I can't figure out the cause. I have a report in Access which is printed through VBA. The VBA code, prior to print, sets the application printer, then prints out. All these works fine on my local machine. But once I login to another machine on a network...
  4. A

    Duplex printing

    Hi, I am having problem with printing in duplex with HP printer: "HP LaserJet P4010_P4510 Series PCL 6" programmatically using VBA. I can print duplex on a different printer ie "Brother" made, but not with HP. Because of this I am thinking it must to do with HP printer driver than my VBA...
  5. A

    checking current ODBC Connection

    Hi, I am trying to connect via ADO to either local SQL instance or remote depending on what ODBC connection my Access is connected to. So for example if my Access application is connected to local instance through ODBC driver, then I would make ADO connection to a Local instance. If it's...
  6. A

    Inserting data from SQL query to Access Table

    Hi, I have a SQL query written in Excel VB Module, which generates the data and stores in Recordset. Like this: Set rst = New ADODB.Recordset rst.CursorLocation = adUseClient rst.Open sqlString, connectionVar, adOpenKeyset, adLockPessimistic With this I can copy the data into Excel...
  7. A

    Linking SQL Server Tables to Access via ADO

    Hi, I wrote a module which connects to Jet database (Access) through ADO and runs a query. The code runs only when i import those tables from a SQL server. When I try to link those tables (so that every time code runs a query generates updated results) I get "ODBC Connection to Server...
  8. A

    Filtering Time range in Time field for records

    Hi, I am trying to filter those records whith overlap times only. For example: field1 TimeStart TimeFinish rec1 13:00 15:00 rec2 14:00 14:30 rec3 15:00 16:00 rec4 14:30 15:00 This should output rec1, rec2 and rec4. But not...
  9. A

    Select records only on the same dates

    Hi, I am trying to pull records from tables which have the same dates within a field in a table. For example if a table has following records: Field_1 Field_2 ref1 date1 ref2 date2 ref3 date3 ref1 date2 The query should output only 2...
  10. A

    Eliminating Duplicates with different field values

    Hi, I searched all the mails with this subject, but still do not have a difinate answer. I would like to eliminate duplicates within a field in a query with other fields been distinct. So for example: Col1 Col2 Col3 ref1 val1 val2 ref2 val10 val11 ref2 val5 val11 ref3...
Top Bottom