Search results for query: *

You are my hero. It worked like a charm! Thanks, PROXI

Can you please elaborate on what you mean. I am unsure where to alter the code to get to those results. Thanks, PROXI

If I make only one selection from the listbox the SQL works perfectly. If I make multiple selections, it pulls everything (I.E. As if you didn't put in any criteria for strWhere). Any help would be really appreciated. Private Sub CmdExport_Click() On Error GoTo Err_CmdExport_Click Dim...

Alright... Sorry for the delay in responding. I had other projects that pushed this one to the side. Thanks PHV for finding the missing ". The code worked, but then I found that I didn't have one of the fields in the code. This is what I have now, but it is giving me a "Type Mismatch" Error...

I have a similar statement that I can't get to work either :( any help on this one PHV? :-D StrSQL = "INSERT INTO 222 ( Field2, Field3, Field4 ) " & _ "SELECT Sum(a.DOLLAR_AMT) AS Field2, b.TRUST, a.PROCESSED_DATE " & _ "FROM...

Thanks PHV... I modified it a bit, but your suggestions made it work perfectly :) Here is what I ended up with. I added a textbox to the my form that pulls in the DMax of the table on form load to give me a starting point and just have it run through today. Thanks again :) Private Sub...

StrSql = "INSERT INTO ForfTest ( CASE_SEQ_ID, PROCESSED_DATE, TRNMSTR_SEQ_ID, AMOUNT ) " & _ "SELECT PUBLIC_PPAK_ACCT_ACTIVITIES.CASE_SEQ_ID, PUBLIC_PPAK_ACCT_ACTIVITIES.PROCESSED_DATE, PUBLIC_PPAK_ACCT_ACTIVITIES.TRNMSTR_SEQ_ID, PUBLIC_PPAK_ACCT_ACTIVITIES.DOLLAR_AMT AS Amount " & _...

I'm retarded. Had the "If" statement set to <> instead of =. If Nz(Me.PPA_NBR, "") & "" = "" Then MsgBox "Please input an administrator number", vbOKOnly, "Input Error" GoTo Command10_Click_Exit Thanks, PROXI

...DoCmd.Close Case vbCancel Cancel = True strSQL = "DELETE * FROM " _ & "PPA_Watchlist WHERE PPA_NBR = '" & PPA_NBR & "';" DoCmd.RunSQL strSQL End Select End...

I always hate it when someone solves a problem and doesn't share the way they did it to help anyone else that may have that same problem. I figured a way of doing it that is much simpler than any other form of the running sum I could find. The best part is that it doesn't involve making...

Hello everyone, I am trying to do a running total in my report. I have no problem with the running sum in the detail section of the report. The problem that I am running into is that I want to have a starting point. I have a textbox in the header that has a value in it that is pulled from...

...= "TblDailyfiles" strFolderPath = "C:\Documents and Settings\parkes23\My Documents\Billing Recon\" strImportFile = Dir(strFolderPath & "\*" & strFileExt) strFile = strFolderPath & strImportFile strnew = "\\Ohlewnas0240\psrp\zoo0212\FACT\Accrual-Billing\Completed Daily Files\" Set objFS =...

...".txt" strTableName = "test" strFolderPath = "C:\Documents and Settings\parkes23\My Documents\Billing Recon\" strImportFile = Dir(strFolderPath & "\*" & strFileExt) strFile = strFolderPath & strImportFile strnew = "\\Ohlewnas0240\psrp\zoo0212\FACT\Accrual-Billing\Completed Daily Files\" Set...

...".txt" strTableName = "test" strFolderPath = "C:\Documents and Settings\parkes23\My Documents\Billing Recon\" strImportFile = Dir(strFolderPath & "\*" & strFileExt) strFile = strFolderPath & strImportFile strnew = "\\Ohlewnas0240\psrp\zoo0212\FACT\Accrual-Billing\Completed Daily Files\" Set...

Alright... What is the best way to go about doing that. I would need it to just overwrite the data that is in the table each time since I just need the last file name. Thanks, PROXI

That is the thing. I need it to be there the next time that I log into the database. That is why I am trying to set the label caption to the variable. I want to avoid losing it when I log out. Thanks, PROXI

...".txt" strTableName = "test" strFolderPath = "C:\Documents and Settings\parkes23\My Documents\Billing Recon\" strImportFile = Dir(strFolderPath & "\*" & strFileExt) strFile = strFolderPath & strImportFile strnew = "\\Ohlewnas0240\psrp\zoo0212\FACT\Accrual-Billing\Completed Daily Files\" Set...

...case someone else may use it later: [code] PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime; TRANSFORM Sum(IIf([Trans]=83,[Amount]*-1,[Amount])) AS Amounts SELECT TblDailyfiles.Date, Sum([Amounts]) AS [Sum of Amount] FROM TblDailyfiles WHERE (((TblDailyfiles.Trans)=79 Or...

Hello, I am working on an accounting database. There are many different trans codes that I work with. There are a few that cross between the financial ledgers that I am trying to work with. Due to them crossing the ledgers, depending on which account I am trying to work with they may need to...

I took that out and now I am getting the 3011 jet error. The error is saying the the database is trying to look for the file that was just moved to the completed directory. It seems like the strfile variable isn't updating to the next file in the list. Thanks, PROXI