Search results

  1. R

    running SQL in VBA with parameters

    I want to run an append query with parameters. I believe this can only be done from within VBA by explicitly writing the SQL (as I cannot pass a parameter into an access parameter query using VBA code). Is the best way to do this using the 'DoCmd.RunSQL' syntax, and if so, how do I refer to a...
    • RT
    • Thread
    • Replies: 4
    • Forum: Macros
  2. R

    Refering to fields on a continuous form

    How do you refer to a single field on a continuous form, as for example, if you have a 'client' text box, all records shown on the form will have a text box called client and any reference to client seems to be ambiguous. Cheers Rich
    • RT
    • Thread
    • Replies: 8
    • Forum: Forms
  3. R

    Displaying dates on a report

    I am trying to display the current month name in the header of a report. I have managed to get the month number using the Now and Month functions, but I cannot find a way of converting this into the month name. Is this possible or is ther another way round it?
  4. R

    Calling Accesss macro from within Excel macro

    I have been having a bit of trouble trying to find the correct syntax for running an Access macro from within an Excel macro. Could anyone please help.
Back
Top Bottom