Search results

Oooops Also set the DB = nothing When using your recordsets try to use snapshots for reads eg SET rsGET = currentdb.openrecordset(sqlText, dbOpensnapshot) Snapshots cannot be used for writing so SET rsWRITE = currentdb.openrecordset(sqlText, dbOpenTable) Opening a table for writing can be...

Sorry for the slow reply: You may be running it via VBA but it is still a SELECT query. Take the query SELECT Ship2Attention, InvNum, Address1, Address2, Address3, Address4, Address5, Address6, City, State, Zip, Country, PurchaserEmail, ProdCode, PrductDecrip, Size, ShipDate, PO, LotNum FROM...

Yes! You are using a standard SELECT query. You need a summary query. Open your query with the query editor. Click the SUMMARY icon (Summary Option attachment). Ensure you select either GROUP (eg for Customer) or SUM (eg for Quantity) or COUNT (eg for OrderID) HTH t BTW: The recordset is ok...

On a form several rows of data are displayed in the detail section. The user can multi-select rows just like a list box by SHIFT/CTRL clicking the record selectors. I want to scan the selected rows and extract data from them. Using the Forms recordset or Recordsetclone (or any other) is the any...

You appear to have set the Tab Stops to YES so the Tab key should take you to the next active tab field. Remember, though, that 1. the subforms are also controls and will also accept focus from the Tab key. 2. another issue is the order of the Tab stops. Each control has a unique Tab order...