Search results

  1. A

    Custom query from Form??

    I have a wonderful piece of SQL which does exactly what I want it to: Dim sqlstr As String sqlstr = "SELECT * FROM FromLegal LEFT JOIN FromCDG ON [FromLegal].[IDNumber]= [FromCDG].[IDNumber]" & _ " WHERE FromLegal.CounterpartyName Like """ & "*" & Me.CPNAME & "*" & """;" DoCmd.RunSQL...
  2. A

    Someone Respond please!!

    I have a wonderful piece of SQL which does exactly what I want it to: Dim sqlstr As String sqlstr = "SELECT * FROM FromLegal LEFT JOIN FromCDG ON [FromLegal].[IDNumber]= [FromCDG].[IDNumber]" & _ " WHERE FromLegal.CounterpartyName Like """ & "*" & Me.CPNAME & "*" & """;" DoCmd.RunSQL...
  3. A

    Where to implement

    Could someone explain where to implement this SQL (full explaination would be great since I am pretty clueless on this). Click the link. http://www.access-programmers.co.uk/forums/showthread.php?t=70751 thanks all
  4. A

    User Input For Query Criteria

    I need to look up records based on a number of fields. I want to do this with a query. So I want the user to be able to enter text into a text box on a form and then use that as the criteria in my SQL string. I do not know how to put the user input into the string. Thoughts, or is there a...
  5. A

    Excel with Access

    All of the code below works except for the "DoCmd.GoToRecord , , acNewRec" line. I get an error message saying I can't use GoToRecore in design view. However, I didn't think i was in design view. I need a solution, anyone will do. I just need to create a new record so the data from the...
  6. A

    Function calling

    Function Calling I have a form w/ command button. The button opens excel and then reads data from excel and inputs it into a new record. In my call the the get/set record function it stops working. I think this has to do with passing the variable "wb" of object type. I need to pass wb...
Back
Top Bottom