finding temp tables in access2007146 (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 error051 (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 rowsource746 (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 transaction036 (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
how to max record based on two fields251 (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
access 2010 error 25011361 (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 image547 (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 2mins343 (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
Table entries require aliases.267 (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 rowsource746 (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)
access 2010 error 25011361 (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 image547 (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...1145 (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 2mins343 (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 vba756 (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?2538 (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)