lesperancer's articles:

Items(107) /11 Next >> Last >|

finding temp tables in access2007 1 46 (3/5/2012 4:44:00 PM) comp.databases.ms-access if I scan through all currentdb.tableDefs, there's a table called ~TMPCLP13171 I'd like to delete it but can't find it in the list of tables even after changing the 'navigation options' to include show hidde... Roger

access2007 creating a transaction - timeout error 0 51 (11/23/2011 12:33:26 AM) comp.databases.ms-access using access2007 and sql server 2005 linked tables trying to create a transaction with many UPDATEs, INSERTs and SELECTs this is required to get new autonumber IDs as they are created I tried using DAO and ADO... Roger

access2007 combo box - how to update rowsource 7 46 (11/22/2011 3:39:35 PM) comp.databases.ms-access I've got a continuous form with a bound combo box (suffix) the rowsource for the cb is "SELECT * FROM qryQuoteBookingDetailSuffix WHERE quoteId = 34" which returns one record ('A') the cb is bound to a field ... Roger

access2007 error creating an adodb transaction 0 36 (11/22/2011 12:04:11 PM) comp.databases.ms-access I'm trying to create an ADODB transaction that updates records, reads records, etc tblQuoteDetail is a linked table to sql server 2005 this vba works fine Dim cnn As ADODB.Connection Dim rsQ As ADODB.... Roger

access2010 DoCmd.TransferSpreadsheet centering data in cell 1 63 (11/21/2011 12:26:22 PM) comp.databases.ms-access I'm using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml,.... to create an xml worksheet where alpha column are left-justified and numeric columns are right justified if I want some columns ... Roger

how to max record based on two fields 2 51 (11/12/2011 2:04:47 PM) comp.databases.ms-access I've got a table with fields bookingId, quoteId, bookingDate I want to get the max(bookingDate) for the max(bookingId) for a given quoteId select bookingId, max(bookingDate) from table where quoteId = 1 group ... Roger

using the printer object, how do I tell what my default printer is 3 56 (11/10/2011 12:19:36 AM) comp.databases.ms-access I want to set the margins on a report to specific settings so I'm thinking this will set the prt object to my default printer Dim prt As Printer Set prt = Application.Printers(0) but it doesn't and ap... Roger

access 2010 error 2501 13 61 (10/30/2011 6:37:53 PM) comp.databases.ms-access I have a cmd button with this code On Error GoTo fExit DoCmd.OpenForm "frmImportShootSheet", acNormal, , , acFormEdit fExit: On Error Resume Next and the form's open event does cancel = true ... Roger

access2007 printing a screen image 5 47 (10/24/2011 4:04:06 PM) comp.databases.ms-access I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have form tab control 1 (2 ta... Roger

access2007 control.listindex takes 2mins 3 43 (10/4/2011 4:22:57 PM) comp.databases.ms-access baanitem is a combobox with an existing value when the rowsource is changed, that value is no longer valid, so I want to clear it the baanItem.listIndex in the first example takes 2+ minutes and returns -1 ... Roger

lesperancer's replies:

Items(422) /43 Next >> Last >|

Table entries require aliases. 2 67 (11/24/2011 5:03:39 AM) comp.databases.ms-access I have Access2010. I have a "tblProducts" in my database linked to "frmInvoice". Some of the products require different names for the same thing, for example a "Green Detergent" could be named "Supersoap" or... pj (34)

access2007 combo box - how to update rowsource 7 46 (11/22/2011 3:39:35 PM) comp.databases.ms-access I've got a continuous form with a bound combo box (suffix) the rowsource for the cb is "SELECT * FROM qryQuoteBookingDetailSuffix WHERE quoteId = 34" which returns one record ('A') the cb is bound to a field ... lesperancer (740)

Permission problem editing SQL table from Access using ODBC 2 53 (11/11/2011 1:49:38 AM) comp.databases.ms-access My client has a SQL Server 2008 backend with an ACCESS 2007 front end. Most of the tables work fine linked using ODBC. However, two of them do not let me edit them as linked tables. I can make changes to the da... jim.mandala (2)

using the printer object, how do I tell what my default printer is 3 56 (11/10/2011 12:19:36 AM) comp.databases.ms-access I want to set the margins on a report to specific settings so I'm thinking this will set the prt object to my default printer Dim prt As Printer Set prt = Application.Printers(0) but it doesn't and ap... lesperancer (740)

access 2010 error 2501 13 61 (10/30/2011 6:37:53 PM) comp.databases.ms-access I have a cmd button with this code On Error GoTo fExit DoCmd.OpenForm "frmImportShootSheet", acNormal, , , acFormEdit fExit: On Error Resume Next and the form's open event does cancel = true ... lesperancer (740)

access2007 printing a screen image 5 47 (10/24/2011 4:04:06 PM) comp.databases.ms-access I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have form tab control 1 (2 ta... lesperancer (740)

A nudge please... 11 45 (10/5/2011 12:00:22 PM) comp.databases.ms-access Hi everyone It's been at least 2 years since I have done any Access work as I am doing more in Excel than anything nowadays, that said..!! I have an old DB I built for a friend a long, long, long time ago wh... noodnutt (61)

access2007 control.listindex takes 2mins 3 43 (10/4/2011 4:22:57 PM) comp.databases.ms-access baanitem is a combobox with an existing value when the rowsource is changed, that value is no longer valid, so I want to clear it the baanItem.listIndex in the first example takes 2+ minutes and returns -1 ... lesperancer (740)

access2007 hourglass while stepping through vba 7 56 (9/26/2011 9:38:45 PM) comp.databases.ms-access access2007, sql2005 form bound to a linked table combobox bound to a field (baanItem) with an afterUpdate event the event has a 'stop' statement so I can step through and view variable contents in the intermedi... lesperancer (740)

How to normalise? 25 38 (9/14/2011 9:15:58 AM) comp.databases.ms-access We have trial where young children are tested for their levels of cholesterol to determine if they have hypercholesterolemia. The children visit the GP and may be accompanied by their mother and/or father or... m.a.joomun (19)