Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by barboza

  1. barboza

    Pass variable from form code to macro.

    Hi Darryl, Please forgive my using the wrong term for Macro - my familiarity is with vba in excel. All macros in excel are in vba, and that is all I write in. Just used the wrong term. You are indeed correct, it is a matter of scope. In excel/vba any code called from a form has access to...
  2. barboza

    Pass variable from form code to macro.

    How can one pass a variable form form code to macro code. StrA is a variable with the value of 8 used in the vba code of a form - frmCustody We have a macro called Test how can macro test run the line: MsgBox strA and have the value 8 appear in the message box. Thanks, B
  3. barboza

    Make value from macro appear in a form

    I have written the following macro that is in module 1. Sub Test() DoCmd.SelectObject acForm, "frmCustody" frmCustody.Me.Controls("F9").Value = "Ag" End Sub I get the following error: Object required. Any ideas how to get the value to show up in the form when the macro runs?? Thanks, B...
  4. barboza

    Delete record with Yes/No prompt in VBA

    Hi PHV, Thanks for the quick response. Works perfectly. B
  5. barboza

    Delete record with Yes/No prompt in VBA

    Hi, I am trying to delete a record without getting the message: Do you want to delete record Yes/No?? Any ideas?? Thanks, B
  6. barboza

    Punctuation aggravation

    Perfect. That is exactly what is needed. Thank you so much!!! Worked like a charm. I have found the biggest problem I have had is figuring out the punctuation. Thanks again!!! B
  7. barboza

    Punctuation aggravation

    It took forever to get the following line to work in VBA: Set rst = dbs.OpenRecordset("Select [LocationName] from PWS where [LocationNumber] = '" & Me.LocationNumber & "';") Now I am trying to get the following line of code to run with no success: Set rst = dbs.OpenRecordset("Select...
See more

Part and Inventory Search

Back
Top