Search results

  1. V

    Passing variable to another form

    Rob, Thank you very much for the xample mdb file. I was completely unaware of the DLookUp function. it is exactly what I need. To answer your question about the need to data-drive button labels at runtime... The client is an organisation with a large crew of volunteer labour that are split...
  2. V

    Passing variable to another form

    Rob, Thank you very much for the xample mdb file. I was completely unaware of the DLookUp function. it is exactly what I need. To answer your question about the need to data-drive button labels at runtime... The client is an organisation with a large crew of volunteer labour that are split...
  3. V

    Saving row data in ADO Recordset

    OK, I found a work-around for this. It is not elegant, and seems to me to be a "cowboy" fix, but it works. I would appreciate a comment from anyone who can explain why this is necessary. Immediately before the line of code , myTransRS.MoveFirst , I added myTransRS.Requery. This now saves the...
  4. V

    Passing variable to another form

    Hi Rob, OK, what you say is making some sense. Two things though. Firstly, how/where do I put the public sub? 2ndly, The table I am pulling these button labels from also contains the value that will be added to the transaction total. So when I press button ColdDrink1 with the label "Coke"...
  5. V

    Passing variable to another form

    Data-driven buttons Rob, Sure, here goes... I have a form that has a few rows of buttons on it. I want the caption of each button to display the contents of a field in a table. So, for example, 4 buttons in each of two rows, eight buttons in all. The table contains eight records (eg: Short...
  6. V

    Passing variable to another form

    Passing variable to another form... Hi Rob, Thanks for the prompt reply. Yes, that was what I was looking for. I had my public variable declared in the wrong place. On another topic... I have a need to data-drive the captions on some command buttons. What I want to do is search through a...
  7. V

    Saving row data in ADO Recordset

    Hi All, I need to create a new record/row in a Header table, create one or more orresponding rows in the child table and then return to the header row and save some extra data. I need to save the header row first to obtain the TransID which is an auto-increment field. This is used in all...
  8. V

    Passing variable to another form

    Hi All, I am new to MS Access, so although I am comfortable with programming concepts, I do not know how to make the contents of a public variable in one form available for use in another form. The environments I am used to allow me to set a public variable, fill it with some data and then...
Back
Top Bottom