Search results

well, no because the you need to add in customer, line,plcd subc, and jobber type ( the joins) to see exactly what records are going to updated.

All tables are shown. Daily Change and Dw_Price are tables. No other relationships in place at this time. No SQL options are being used that I have selected. I would love not to have special characters, but on the DW_PRICE table is a table that I cannot control and out on a A/S400 system...

any suggestion on how to get this to go?

Really?!? Too many joins? what a piece of junk! I need those joins to identify the correct items to update. Neither one is a query, both are tables. I have another update query that is using the same amount of join. Both are tables also. UPDATE tblFlexPricePrevious INNER JOIN tblFlexPrice ON...

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

Thanks a lot. The CDbl was exactly what was missing.

Well thought I had this solved, but the solution that I used will not work for my problem I have again. SELECT [Net/Net Sum].WEEK_ID, [Net/Net Sum].[Sale Area], [Net/Net Sum].Category, [Net/Net Sum]![SumOfCurrent Units]/[Net/Net Sum]![SumOfPrevious Units]-1 AS [Comp Unit Totals], [Net/Net...

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

Thanks all for the information. The field that was being lookup'd was standard us format converted from non-standard format. The date field in the table for the lookup was set to short date for US. I did eventually find my answer. I had do a dlookup against the table. Using...

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

Sorry, but that is not going to help me. I could use a sample of the coding. That site did not allow for multiselections with different requirements.

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

Well, I found my error. It was in the Excel export module. xlApp.Quit rst.Close Set rst = Nothing Set xlApp = Nothing Exit Function Those 2 needed to say ApXL instead.

Thanks, Bob for the Code again. I am now having one last problem. I get a '424' error every time it run. I can hit OK to the error and it creates all the worksheets without a problem, other than the error popping up. If you look at the part marked in red, that was the solution to my problem...

The Automation error was due to DAO360.dll not being registered. Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll" Now the problem is that it tries to create a new workbook every time and it repeats its information - recreate Region 9 4 or 5 times then moves to...

Here is my almost working code. Now I am getting: class does not supports automation or does not support expected interface. I does open an excel sheet now, but it only has 1 tab and only has headers. Private Sub Command0_Click() Dim strSQL As String Dim db As DAO.Database Dim...

Here is my current code: Private Sub Command0_Click() Dim strSQL As String Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim rstAreas As DAO.Recordset Set rstAreas = CurrentDb.OpenRecordset("Select Region From STORE INFO") Set db = CurrentDb For Each qdf In...

I tried that. Does not work. It give me an error of : ByRef Arguement type mismatch Call SendTQ2ExcelNameNewSheet (MyTempQDF, "Region " & rst!Region, "C:\KML\Regions.xlsx") and without the () it give a syntax error. I don't know if it makes a difference but I am using Access 2007.

Ok, I fixed that last error, using SendTQ2ExcelNameNewSheet (MyTempQDF, "Region " & rst!Region, "C:\KML\Regions.xlsx"). Now it is giving me expected: =

Thanks a lot, Bob I think this is going to really help. One Problem - I keep getting a Compile error: ByRef Arguement type mismatch on the enlarged name: SendTQ2ExcelNameNewSheet MyTempQDF, "Area " & rst!Area, "C:\KML\Regions.xlsx"