Re: Refresh of a DBGrid
- From: "Bill Todd" <no@xxxxxx>
- Date: 28 Sep 2005 09:30:35 -0700
Save the primary key value(s) for the current record. Close the query.
Open the query. Call Locate to find the record that was current.
--
Bill Todd (TeamB)
.
Relevant Pages
- Re: Problem with Access concatenate query
... records in the final query. ... You probably need to INNER JOIN the tables, although on what column, I am not sure. ... PriceID -- Primary Key ... ItemID --- Foreign Key ...
(microsoft.public.access.queries) - RE: Processing thousands of records
... Jerry Whittle, Microsoft Access MVP ... Access automatically creates an index for primary key fields. ... that the query is working faster, you don't need the 1stVisit02 query. ... where do I read about fundamental indexing and normalization? ...
(microsoft.public.access.queries) - RE: Processing thousands of records
... Access automatically creates an index for primary key fields. ... that the query is working faster, you don't need the 1stVisit02 query. ... Jerry Whittle, Microsoft Access MVP ... where do I read about fundamental indexing and normalization? ...
(microsoft.public.access.queries) - Re: Determining if a form has a table or query recordset source
... how to obtain the primary key of a query? ... the generic answer is: "who says any query has one?". ... > set for insertion into an audit trail table, ... > Dim audID As Long ...
(microsoft.public.access.security) - Re: [PHP] peer review (was php framework vs just php?)
... those POST/GET elements, the global elements and the development of the sql ... generation of a SELECT query ... html with embedded php variables ... //get the primary key for the table ...
(php.general) |
|
