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 Wanet Telecoms Ltd 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 3239

  1. 3239

    VBA SQL CODE HELP

    Thanks for the tip Skip!! Running my code in the SQL Editor will save me from pulling my hair in the future!!
  2. 3239

    VBA SQL CODE HELP

    Hello everyone, I have been looking at this code for hours and just can't find the error in it. It is giving me a syntax error in the JOIN operation. The code is below, please help. Thanks DoCmd.RunSQL "INSERT INTO TempAll ( ID, SDate, NAME,Screener, PROVIDER," & _ "MatName, LotID, Quant )...
  3. 3239

    Multi-Select List Box as Query Parameter

    Hello everyone, The code I have below works if the arguments are passed to the query as text. My question is how do I pass arguments to the query as a numbers? Thanks, ' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria...
  4. 3239

    Passing parameter to query from form

    I found the problem. The Date field in my PurchaseOrder table data type was set to text instead of Date/Time. Now everything is working fine.
  5. 3239

    Passing parameter to query from form

    Hello everyone. I am having a problem figuring out why my query is returning incorrect results. I have a form that accepts a date range from the user and passes the values from the text boxes on the form to the query. Sometimes the query returns the correct results but in some cases incorrect...
  6. 3239

    Insert Record From List box into table

    Yes I fixed it joelflorendo. Thank you for your help.
  7. 3239

    Insert Record From List box into table

    Thank you very much Randy!! That worked!! Thanks to all of you for your help!!
  8. 3239

    Insert Record From List box into table

    It seems like I'm getting somewhere now thanks joelflorendo but there is an error I'm getting. It is error: 3075 Syntax error in string in query expression "23.993". In the code below. "23.993" is the value of column 3. I'm new at writing sql code in vba so I don't quite understand the quotes...
  9. 3239

    Insert Record From List box into table

    I thought of using an append query but I don't know how code it to append a record based on the selection in the list box. In other words, I can't figure out how to get the append query to insert the record selected. Below is an example of some code I found on the web. I couldn't get it to work...
  10. 3239

    Insert Record From List box into table

    What I have is a list box that displays data that is queried from an external database. What I am trying to do is insert data that is being pulled from the external database into a table based on my list box selection. I hope I am making sense. Please let me know. Thanks
  11. 3239

    Insert Record From List box into table

    I am really struggling with this. I am trying to insert a selection from a list box into a table. I've looked for information on the web but nothing has worked for me. Thanks
  12. 3239

    Select Query in VBA

    I'm new at writing queries in VBA. I Just wanted to know if it is possible to write select queries in VBA and if so, how? Thanks.
  13. 3239

    SQL in VBA Help

    Thank you PHV. That was very helpful.
  14. 3239

    SQL in VBA Help

    No matter how much I try to correct the syntax of my VBA sql statements, I always get errors every time. Does anyone know where I can find tutorials explaining the syntax of sql statements in VBA? It's like hit or miss with me. Sometimes I get the syntax right. Most of the time I don't. The...
  15. 3239

    Run-time Error 13 Type Mismatch

    Thanks a lot guys!! It is working now.
See more

Part and Inventory Search

Back
Top