Search results

  1. E

    Solved Adding Number To File/Folder Name w/ MoveFile

    If I am heading in the right direction, what function would I use to count folders and files? CountIf?
  2. E

    Solved Adding Number To File/Folder Name w/ MoveFile

    I was kind of hoping someone was going to say to use this function instead because it automatically does what you need. Thinking about it now, I am thinking about an IF statement to see if the ZIP folder is already in there. If it is in there count the occurrences of the base folder name and...
  3. E

    Solved Adding Number To File/Folder Name w/ MoveFile

    Good morning. I am using this code to move a ZIP folder from desktop to an archive folder: Dim filPath Dim folPath As String filPath = Dir(C:\Users\EzGoingKev\ & "*.zip") folPath = "C:\Users\EzGoingKev\ArchiveFolder\" Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject")...
  4. E

    Access - Exporting Data As Text File Using UTF-8 with BOM Encoding

    Did you read this part of my OP - "And FYI - Before anyone tells me this a bad way to do it and that I should be doing it this way instead - I have no control over this at all. This is the way I was told to do it. I do know if you do not open and re-save it with the UTF-8 with BOM selected the...
  5. E

    Access - Exporting Data As Text File Using UTF-8 with BOM Encoding

    The export_specname tells it the first row are fields, tab separated, no text designator, etc. IDK how it would export right without that.
  6. E

    Access - Exporting Data As Text File Using UTF-8 with BOM Encoding

    I have tried using the 65001 at the end when exporting using the following code: DoCmd.TransferText acExportDelim, "export_specname", TableName, "C:\Users\Name\Desktop\FileName.txt", True,, 65001 I also tried: DoCmd.TransferText acExportDelim, "export_specname", TableName...
  7. E

    Access - Exporting Data As Text File Using UTF-8 with BOM Encoding

    Good afternoon. I have to build load sheets for a web based third party application my company uses. - I build the data in Access. - I export the data out to a text file using DoCmd.TransferText. - Once the text files are saved I need to manually open each one. Once open I use File -> Save As...
  8. E

    Solution: Kind of 'UnCrosstab' code

    Honestly I have never even heard of it.
  9. E

    Solution: Kind of 'UnCrosstab' code

    I had a union query. I found some issues with the source data and had to make some changes. When I went to run the union query I got an error message. I did not want to go through the 20 separate queries to figure out what worked and what did not. This data is used to build load sheets. My...
  10. E

    Solution: Kind of 'UnCrosstab' code

    Another question. This is setup to put this data into a table. Is there a way to call the data up from the module in a query?
  11. E

    Solution: Kind of 'UnCrosstab' code

    I figured it out. There format of the numbers was different depending on the field. Examples of what I needed are: 0.90 2.405 61.00 24.05 This is how the data is stored in the table that feeds Query3. I do not need the Nz function on all the fields so I removed them. I added a Format function...
  12. E

    Solution: Kind of 'UnCrosstab' code

    No. Half of the attributes are text and the other half numeric. I know I can manually go in to each field in the query and write a format statement. I do not want to do that. The data sets support specific product lines. The one I am working on now has (20) fields. My other product line has...
  13. E

    Solution: Kind of 'UnCrosstab' code

    If you are talking about setting the Property Sheet for the field in the query to something like General Number, Fixed, or Standard with two decimal places I have tried that. It looks like the code converts all the Attribute Data to text. I have used union queries in the past. I have about...
  14. E

    Solution: Kind of 'UnCrosstab' code

    Waking this thing up from the dead. I am using this code and it is working great with the exception of one issue. Here is what I am using for code: Option Compare Database Public Function ReverseCrosstab() Dim rstin As DAO.Recordset Dim rstout As DAO.Recordset Dim fieldloop As Integer Set...
  15. E

    Solved Linking/Importing Excel File w/ "Dirty Data" Into Access

    That worked perfect! I tried "If Not IsNull([Expression]) Then". I did not know to add the "rs!" to it.
  16. E

    Solved Linking/Importing Excel File w/ "Dirty Data" Into Access

    Are you saying that I should have two mapping tables, use one for cleaning and the other for importing?
  17. E

    Solved Linking/Importing Excel File w/ "Dirty Data" Into Access

    @arnelgp - I have a question on the CleanExcel function. I am working with (52) fields. It takes (12) minutes to format the data. In an attempt to shorten that time I tried leaving the expression field in the mapping table blank for the fields that do not need formatting. I get an invalid use...
  18. E

    Solved SQL UPDATE Statement Help Needed

    @arnelgp - that is pretty much what I did. The data that I am importing has a date field denoting when the data was either added or changed. It is changed due to errors. I needed the previous date so I can see what has been added or changed since the last update. Thanks everyone for your help.
  19. E

    Solved SQL UPDATE Statement Help Needed

    I used the one you initially posted. That was what was there when I clicked on the link. I updated it and am getting the result I need. So now how do I use it in an update statement?
  20. E

    Solved SQL UPDATE Statement Help Needed

    No, it is not. I do not want the most current date. I want the date just prior to the most current date.
Back
Top Bottom