Recent content by gfcaim

  1. G

    How do i pass the parameter of a query in VBA?

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

    'Insert Into' code

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

    'Insert Into' code

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

    'Insert Into' code

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

    'Insert Into' code

    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!
  6. G

    Numbering records in a continuous form

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

    Numbering entries in a report

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

    Delete from subform (simple)

    thanks thanks - quite right, it does work.
  9. G

    Delete from subform (simple)

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

    Simple 'Insert Into'

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

    Simple 'Insert Into'

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

    Simple 'Insert Into'

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

    If query returns no records...

    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?
  14. G

    If query returns no records...

    ... 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?
  15. G

    Reopen a form on a particular record

    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 more
Back
Top Bottom