Search results

How do i pass the parameter of a query in VBA? My line is: cldDetail.SourceObject = "Query.qry_CDs", but the query requires a parameter (customer number).

How do i insert the current date/time into a table? I'm using: RPT = Me.Combo87.Value Application.CurrentDb.Execute "INSERT INTO tbl_ReportLog (DateTime, Report) VALUES ('" & Now() & "', " & RPT & ");" The RPT bit works fine but i cannot get the other field!

Sequential numbering in a continupus form based on a query - how?

I have a subform that i have added a button that runs a delete query. The query selects the record to delete based on the subform record ID. If i open the subform on its own it works fine, but from the parent form it acts as a parameter query, asking for the ID. So it's obviously an addressing...

Can someone help me with this syntax problem... dim D$ D=Date Insert INTO tbl_AutomatedEmail VALUES (D); <--access dont like this! the table in question only has one text field to hold the inserted date.

... then i'd like to catch that, display a message to that effect and cancel the report or form or whatever i'm trying to open. Does anyone have some examples of catching zero records returned queries that i could utilise for my own application?

I have users entering data into a form that contains two linked subforms. They want to be able to go back into a particular record as and when they need to in order to continue adding data but I dont want them to have to navigate all the records. How do I reopen the form for data entry at the...

Thanks for the reply. I am still missing something though. I altered the query (by typing the 'outer' word in sql view - is there another way of doing this?) but get exactly the same results! The sql now reads: SELECT tblAreas.Area, Count(tblHeader.Date) AS CountOfDate FROM tblAreas LEFT OUTER...

This is probably really simple... I have two tables, one has the work areas (tblAreas), the other has info about what each area produced (tblHeader). They are linked 1 (areas) to many. I want to write a query that lists all the areas, and a count (not sum) of their data entries, even if that...

I have one table that has area names, area1, area2,... (the 'one' side of a join) and another table that holds records related to a specific area (the multiple side of the join). I want a report that lists the area as a heading, then all the records related to the area, then the next area, and...