Recent content by tstrike

I have the Access VBA part down, the part I need help with is creating a VB script that will execute the Access vba script so that who ever is loading the data can get the cleaned and compiled text file to load into our reporting system. Thank you Trevor

Andy, I had earlier created the cleanup process in access 2007. Can I create a VB script that will check the text file date and then execute the save export in access without the user going into access? Thank you

Andy, Thank you for your help. I think this will work. Trevor

Andy, Thank you for your response. Trim will do the job for Problem one. However, I am not sure how split will help me. Where the 100 is will be other numbers like 502, 504, 506, 508, or many others up to 899. I need to replace these numbers with 000. Can split do that? Thank you Trevor

I am getting a text file that I need to modify in order to use is properly. I was able to bring the file into MS Access to modify it, but need to be able to have the file automatically cleaned so that the file could be brought in durring the nightly process. Here is a sample of the file...

Jambai, Thank you for your help, not sure how putting this in an AutoExec macro would change the fact that the emails are created, but not sent. It does not take long to hit the send button on them all, but would rather it be seemless. Thank you for your advice Trevor

Thank you for your help. My goal is to send through lotus notes without having to view the email. I also do not want to have to save the object I am sending to a drive. The sendobject command will let me do that, but does not actually send the email. At this point, everything works accept...

Thank you for any help or direction you can give me. Trevor

I can get the Emails to gerenate as I want them, but in order to send them, I need to go to each email and manually send it. I know in the past I was able to send with our seeing the emails, but that was awhile ago. I am using MS Access 2003 amd Lotus notes 8.5.1 Here is the code I am using...

I am trying to Export several veiws to Excel using Access. I tried Using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "dbo.qryMNADLDSM", "c:\temp\MNADLExport.xls" When I run the code, I get the following error: Microsoft Office Access can't find the object 'dbo.qryMNADLDSM.' I...

I have some Procedures that are being fired off by access and I need to make sure they are done before Access continues to process the rest of the code. How can I do this? Your help is greatly appreciated.

Instead of using a access query try using a VB script query. Idea: Use a form for the user to select the column to update. Either using a combo box or a list box. Then create a button and attach this code to it. dim strSQL as string, strColNme as string Sub Button_click() strColNme =...

When I try running an update query to update the text field of a SQL Server table. When I run the Query, I get this Error. Updating data in a linked table is not supported by this ISAM. I whas able to add records to the SQL Server Table, and Update one of the ID feilds. I went into the...

dhookom Thank you That link looks like it will help me with something that has been requested of me.

Changing the code from rst.Open "qryDirectPurchInvoices" to strSql = "SELECT tblIntercos.Reference, " & _ "Sum(tblIntercos.[Amount in local cur]) AS [SumOfAmount in local cur] " & _ "FROM tblIntercos " & _ "WHERE (((tblIntercos.Cleared)=False)) " & _ "GROUP BY tblIntercos.Reference " &...