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 ShaneJones

  1. ShaneJones

    Pull field from table with SQL, then put into variable with VBA

    Scoty Using this example, the code errors at My_Field_Name. Obviously I have my data in here, but that is the place. MyVariable = Cstr(DLookup("[My_Field_Name]", "MyTable")) Shane
  2. ShaneJones

    Pull field from table with SQL, then put into variable with VBA

    Scoty We are getting closer. When I use the Dlookup, I get a compile error saying "Invalid outside procedure". Any chance for help out of this one. I am still a newby, and am stuck again. Shane
  3. ShaneJones

    Pull field from table with SQL, then put into variable with VBA

    I am basically trying to get the first value in the first field of a table into a variable that I can use. I have been trying to manipulate the SQL query and play with that, but have come to a brick wall. Any suggestions on how to get the SQL to work or a new directoin would be greatly...
  4. ShaneJones

    VBA error when trying to save access data

    I can change the + signs to & symbols, but I still get the error about data being changed. I am using the DoCmd.RunCommand acCmdSaveRecord command to save, is that part of my problem?
  5. ShaneJones

    VBA error when trying to save access data

    Here's the partial code I have done. I have excluded the multiple variables and definitions to save space. 'Define variables Dim PitiAmt As String 'Set variables subfrmBuyerFinInfo!PITIPmtAmtb.SetFocus PitiAmt = subfrmBuyerFinInfo!PITIPmtAmtb.Text 'Combine variables with text and input into...
  6. ShaneJones

    VBA error when trying to save access data

    I am using VB to auto-complete a variety of text fields with other fields in the database. If you are still with me, I have delcaired all the varialbes, set them to the fields, and them set them in the remaining text. When I attemp to complete the merge, I get the following error: Run-time...
See more

Part and Inventory Search

Back
Top