Search results for query: *

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

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

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

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

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.

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

I keep getting this error. The code is looking for duplicates in my Autonumber field which is long data type. What data type do I have to use to get this code to work. Please Help!! Thanks. Dim lngPOID As Long Dim lngLinkCriteria As Long Dim rsc As DAO.Recordset Set rsc =...

Hello, I am trying to create a function that sets the record source of a form by passing a query to the function. I am a beginner in writing functions and don't how to accomplish this task. Here is a snippet of the code that I am trying to turn into a function. Thanks. Public Sub...

Please help! I am getting the following error: "To few parameters. Expected 1" when I try to run an action query in vba. Here is my code. Dim QryPO As String 'Insert record into POarchive table before deleting QryPO = "INSERT INTO POArchive" & _ "( POID, [Date], Buyer...

I'm am just getting my feet wet in programming functions. There is one function that I have found off of The Access Web website http://www.mvps.org/access/api/api0008.htm, written by Dev Ashish, that allows you to retrieve a user's network User Name. What I am trying to do is use this function...

I'm fairly new to running SQL in a code module and I'm having a "Compile Error Expected: line number or label or statement or end of line error" with the folliwing code: DOCMD.RUNSQL "SELECT SEND_REQ.PurchaseOrderID, SEND_REQ.OrderDate, " & _ "SEND_REQ.Comments, SEND_REQ.EmployeeID...

Hi everyone. I have a query in my current database that pulls information from an external database. What I am trying to do is insert the records from the external database into related tables in the current database. Thanks.

Could Someone Please help me with this code. I keep getting a Data Type mismatch in criterior expression. Run time Error 3464 Private Sub cboEmployee_AfterUpdate() Dim D As Database Dim rstEmp As Recordset Dim strSQL As String Set D = CurrentDb strSQL = "Select * from tblEmployee Where"...

I am trying to learn how to program using VBA and SQL. I created a Sub routine that I want to use to insert records from an unbound form into a table. When I call the procedure from the Click event on the button of my form, I get an error message "Run-time error 2498 the expression you entered...

I am a beginner when it comes to creating functions in code modules. When ever I create function in a new module and use Call to invoke the function , I always get an error message. I know that I am doing something wrong but I don't know what. Could anyone let me know what steps to take from...

How do I get Page 1 of my tab control to switch to Page 2 once I press enter? Thanks

I have a form the has Beginning date textbox, Ending date textbox, and Facility textbox. The expression's for the Beginning date and Ending date text boxes work fine and produce results in my query. But when I try to build and expression for the Facility text box my query produce no results...

Whenever I enter a decimal number into a table, Access rounds the number. How could I prevent this from happening?

How do I get access to automatically add a number to an existing number for each month into my database. For example, lets say that I have a database that keeps track of an employee's vacation time, And each month every employee earns 10 hours of vacation time. How would I get access to...

What would be the best way for me to learn how to create an option group?