Search results

one would think one is here not because one is a pro but a total newb, else would not be asking for all of your expertise indeed :) .. much appreciated always... The issue is this there are 2 ppl at the area: either one of them can either start the log and/or edit the record created by the...

Hello, I'am trying to perform an update on my table based on the textboxes data; however, when the code is executed it generates a new record instead of updating. The issue is this there are 2 ppl at the area: either one of them can either start the log and/or edit the record created by the...

Thank you so much!

hello, I am sorry I do not know how to do that.. :(

Hello, I am executing the following command (operator enters the file number to be imported and press a button): DoCmd.TransferText TransferType:=acLinkDelim, tableName:="CsvTbl", _ FileName:="E:\Op60\" + MyTbl + Myextension, HasFieldNames:=True to open a desired CSV (I have 100s of...

worked restart my PC.... IDK what happened there thank you

sSource = Application.CurrentProject.Path & "\" ' "E:\OP60\Archive\" Dim sFilename As String sFilename = sSource & "Test data report" & "-" & result & "_" & Format(Date, "yyyy_mm_dd") & ".xlsx" DoCmd.OutputTo acOutputQuery, "QryLog", acFormatXLSX, sFilename, Autostart:=False Note...

"error" invalid qualifier here -> strFile.DateCreated

Hello, Updated OP with updated code, just need some minor tweaks... appreciate everyone's time and assistance

I understand your point; however, I have not clue as how to code the approach you are suggesting

tried it & there are 53 files created on 9/24/2021 and it shows only 2. & 300+ on 9/16/2021.. it does not look like it is loading all the 9/16/2021 either

just looked at the original folder and it shows the same issue with the dates haha

LoL you have noticed that as well :) I have never seen that before! that is why I said date created is the best way to go about it. I picked the range of 9/15-9/24 and see the attachment for the results. it only displays the 9/16/2021 date files and nothing else. I do have a lot of files created...

Yes see attachments please. This is what I see on the DB when I press submit nothing happens

appreciate the assistance, when I run this DB nothing happens... select folder, date range, hit submit and don't see anything... and I missing something?

GREAT! Thank you so much... question is there a way to "merge" all the tables" in to a single table? **Also it opens only for me all files created on 9/7/2021 (it does not obey the time pickers that is). **Tried changing fsofile.DateLastModified but the code did not take, I think it will be...

I had updated the code on the OP, I get no errors, but it is not doing a thing, no imports etc.. thank you so much for your help

Hello much appreciated... The files do not have a date on their name; what I need is to be able to open ALL the CSV files created between the 2 selected/specified dates. hope this explains things a bit sorry for the confusion

Hello, I have tons of CSV logs created daily, need to be able to specify a date range i.e. "9/20/2021 - 9/23/2021" and open all the files created during this period. Import them into an access 2016 table This is the code I have pieced together from the web; however, I am unable to get it to work...