Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tstrike

    Clean and modify a text file

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

    Clean and modify a text file

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

    Clean and modify a text file

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

    Clean and modify a text file

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

    Clean and modify a text file

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

    How can I get my emails generated from MS Access to automatically send

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

    How can I get my emails generated from MS Access to automatically send

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

    How can I get my emails generated from MS Access to automatically send

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

    How can I get my emails generated from MS Access to automatically send

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

    Exporting Views to Excel Using Access

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

    Checking status of SQL Server Proc through Access

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

    Prompt user for field name in update query?

    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 =...
  13. tstrike

    Update Query give ISAM Error

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

    Report based on Day Of Week-Display certain records to certain fields

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

    Using Recordsets in VB Coding

    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 " &...
  16. tstrike

    Using Recordsets in VB Coding

    I tried rst.Open "qryDirectPurchInvoices" and also brining the sql from the query into the code. Neither one works. rst.eof still = true I thought by including the hole code, and then showing the problem erea, it would be easier to understand all that is happening. I will try to be more...
  17. tstrike

    Using Recordsets in VB Coding

    Roy, I am sory that you found my repost offending. That was not my intent. When I run this part of the code I get rst.eof = true. rst.Open "SELECT * FROM qryDirectPurchInvoices" All the rest of the code works fine. I now have 5900 plus records in the query that the record set is opening...
  18. tstrike

    Using Recordsets in VB Coding

    The problem is that the recordset says there are no records, where the query has 4,000 plus records. I am trying to update recordes based on the record set. I have tried all of the cursortypes, but I get the same responce. Access is saying there are no records in the record set. EOF is true...
  19. tstrike

    Using Recordsets in VB Coding

    I am having a problem with on of my recordsets. For some reason Access thinks there are no records in the Recordset, but when I open the query that the recordset is based on there are 4,000 plus records. Here is my Coding. Option Compare Database Option Explicit Dim Msg, Style, Title...
  20. tstrike

    Do Until EOF

    Thank you for your help every one

Part and Inventory Search

Back
Top