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).

Bat17, I love you and want to have your babies! Thanks a lot for your persistent help. I renamed my field 'DT' and everything is now tickety-boo. Thanks again.

thanks for the reply - i copied and pasted your line but it is exactly the same - no joy. RPT is numeric

nope - it dont like that either, although the suggestion makes sense. I used hashes but no joy - no error message, just nothing!

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?

...and in a form? How do i do the same thing in a continuous form?

thanks thanks - quite right, it does work.

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...

Er... one last thing - how do i supppress the confirmation message?

Thanks a lot for your reply - i have altered my work as you recommend.

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.

Tried that... In the 'On No Data' event i put 'msgbox "no Data"' just to try it and it dodn't show - any idea why? What about queries and forms that have no data?

... 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...

see attached .jpg

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...

Er, I'm still missing something... 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...

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...