Search results

Solved:Create Query in ADO I am trying to create an ADO create query since I don't have access to DAO anymore due to an system upgrade at work. Access is telling I don't have ADODB loaded into my system to run the create query. Any suggestions on what reference I might need? I have loaded...

SOLVED:Small Macro problem I am running trying to run this vba , but it errors @ the red print in the code and gives the following error: Runtime error '3075': Synteax error(missing operator) in query expression 'Sale_Area = WARM MIDDLE'. Warm middle is a name of area in my query. VBA...

I am trying to use this query to update a table, but it tell me,"Operation must use an updateable query". What am I missing? The field is a Yes/No field that is going to be updated. UPDATE [Daily Change] INNER JOIN DW_PRICE ON ([Daily Change].[SCUST#] = DW_PRICE.[SCUST#]) AND ([Daily...

I have a calculated field from another query that I am pulling in from. When I view the field on the original query, it looks correct, but on the secondary query the value goes to 0 or 100 or 50 percent. When I do the calculation in query, it still does the same thing. Calcuation is (Current...

I have a form that I want to display max date from a table, but every time I try to get it to display on the form, I get #error or #name?. I can run a query and get the information correctly, but it refused to display at all on the form. I have tried the following on an unbound text box:: =...

I got this script that I am trying to modify to add more restrictions to a query. Private Sub cmdOpenQuery_Click() On Error GoTo Err_cmdOpenQuery_Click Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim i As Integer Dim strSQL As String Dim strWhere As String Dim strIN...

I want to create a macro that will export a single query to excel, that can create multiple workbooks from a list. It is not realistic to create individual queries for each item (100+ items and changes often) and need each item in a list in a different worksheet (preferably in the same...

I am using the follow IIF statement and get zero results back - IIf([Forms]![Basic Form]![Pricing Region]="*",True,[Forms]![Basic Form]![Pricing Region]). If I change the True to 15, I get the information from Region 15 to come back, the result I need is all numbers to come back. I have tried...