Re: OpenRecordset from query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi Sue,

hughess7 wrote:
I have a query which selects one record from the current record of a continuous form. When run normally as a select query this works but I am trying to use this query via code:

Set rs = db.OpenRecordset("qry CB Control Log Excel", dbOpenSnapshot)
Really spaces in the name? Then try:

Set rs = db.OpenRecordset("[qry CB Control Log Excel]", _
dbOpenSnapshot)


mfG
--> stefan <--
.

Relevant Pages

  • Re: "Subtracting" from query?
    ... Good point on the continuous form - I can see that ... even though I have programmed a custom message box, gets the Access message ... combo box that uses the CompanyTbl as the row source, ... I have been able to create a query which displays the companies that use the ...
    (microsoft.public.access.queries)
  • Re: Take Parameter from Record Selected on Continuous Form to Run Quer
    ... and a filtered continuous form below. ... query pulls all the Refferal data with the total included). ... Client Number on the selected record on the continuous form of the search ... I am guessing that your criteria are in the query's HAVING clause (which is ...
    (microsoft.public.access.queries)
  • Re: Take Parameter from Record Selected on Continuous Form to Run
    ... I have tried the following as criteria: ... SELECT Referrals.*, qryMoneyByClient.SumOfAmount ... and a filtered continuous form below. ... query pulls all the Refferal data with the total included). ...
    (microsoft.public.access.queries)
  • Form modifies record when it should not
    ... continueous form which is bound to a select query. ... program name and session name are locked fields and ... The user when they either update or cancel the continuous form, ... The second question is that when I try to load the continuous form, ...
    (microsoft.public.access.formscoding)
  • Re: Save selection
    ... continuous form. ... If the target is a report (not a query), and there are not too many records, ... "Darrell Childress" wrote in message ... What I am having to do is create a new field with a checkbox. ...
    (microsoft.public.access.forms)