Search results for query: *

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

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

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

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?

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

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