Recent content by VbAaron

  1. V

    Sending Emails based on table field value

    This is great, I'll have a look at this and will update this post once I get it to work. Again, much appreciated.
  2. V

    Sending Emails based on table field value

    Thank you for responding. I understand how to insert query results in to an HTML table email. However, I need a little more. Example: PO VBU VBU NAME EMAIL 1234 5 Cheese mail@cheese.com 456 5 Cheese mail@cheese.com 789 6 Butter...
  3. V

    Sending Emails based on table field value

    Hello all, I scoured the forum and couldn't find any useful relevant information concerning my current issue. With that being said, below is the issue I am stumped with: I have a table with various purchase orders and relevant header data (Arrival Date, Ship Date, Days Late, Vendor etc.). I...
  4. V

    Trimming Text File Names in VBA

    Thanks again for all your help!
  5. V

    Trimming Text File Names in VBA

    Hey Mark, Thanks for everything that you have provided! I am using the following code to successfully rename the files in my folder: Function rename() Const fdr As String = "C:\Users\afharris\Documents\_a_ RONA Conversion\New folder\" Dim oldnm As String, newnm As String oldnm = Dir(fdr &...
  6. V

    Trimming Text File Names in VBA

    This will always be the case yes.
  7. V

    Trimming Text File Names in VBA

    What you're saying makes sense. My idea then is to code: For every file that contains the 'extra text' in a folder, run the split() script for those file names and rename based on the output array. Can I assign a variable to that output array to call it into a name loop? Again thank you...
  8. V

    Trimming Text File Names in VBA

    Thank you for this Mark! My next question then is a tough one to ask due to my limited understanding of this process, so bear with me. Essentially the array is a result of that function you recommended I use, does this mean that the output array can be used to identify the table that file (used...
  9. V

    Trimming Text File Names in VBA

    Hey All, Had a look through the forums and didn't find any mention of my specific issue. Here goes, I have a series of files that are being transferred across an FTP server. The file naming follows a predetermined format that was agreed upon by both parties on either side of the transfer...
  10. V

    Update timestamp/id of specific record using a Form

    Absolutely perfect. Thank you so much! :) :D
  11. V

    Update timestamp/id of specific record using a Form

    Hey All, I have searched for the past 1 hour and couldnt find the exact situation I am in. I will try my best to explain where I am at: I have a form that is bound to a table that users can access to comment on specific issues pertaining to an item. Each row in the table is a unique set of...
  12. V

    Identifying decimals in a calculated IIF statement

    Ahhhhhh yeeeaaa. Thanks for the reply. Had a feeling that it was something so simple. Have a good one.
  13. V

    Identifying decimals in a calculated IIF statement

    Hello I have a statement as follows: ohc: IIf(([oh]/[csqty])>1,[oh]/[case_qty] & " (LTSU?)",[oh]/[case_qty]) The intention was that it would add " (LTSU?)" to the calculated number where it was less than 1 (or not a whole number). Stupidm, me didnt account for fractions greater than 1 (ie...
  14. V

    Importing text files into access within date range

    yeah that! lol Sorry, brain fart. I'm at work dealing with requests and what not. Yeah, the code is embedded on a form, and the 'Me' is intended to reference that form. Is that redundant?
  15. V

    Importing text files into access within date range

    'Me' is intended to set focus to the two text boxes on the main form where the two date's are entered by the user.
See more
Top Bottom