Search results

Thanks for the replies guys. I changed up some of the queries so they use less resources and it has been running fine. If I have the issue I will add the MakeCodeWait sub. One question I do have is when you get an error like that is there a way to know if the coding is bad vs too many...

The workbook is not already existing. It is created by the first TransferSpreadsheet function. They are not really that big or complex. When you run them in Access they open right up. Each query has one calculated field where it is calculating the sum of some fields in a table. The Excel...

Option Compare Database Public Function ExportToExcel() Dim strPath As String strPath = "C:\Users\MyName\Desktop\fi_cv_polk_" & Format(Date, "mm_dd_yyyy") & ".xlsx" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "42_aces_detail_no_ids", strPath, , "vio_by_aces_apps"...

I created a function to export five Access queries out into five sheets in the same Excel 2016 workbook using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "QueryName", C:\Path\ExcelFileName, , "SheetName" Sometimes I run it and it runs fine. It creates the workbook and...

Access either does not see them or ignores them. Using the import process in the previous posts the deleted records are not imported. I linked to the table and the deleted records are still not there.

That is not an option. The program that uses the DBF files has a "Show Deleted Records" feature. If you turn that on you can see the history of what was deleted. You can also recall something that has been deleted.

Something new - One of the DBF files contains records that are listed as deleted. When I do the import it drops these records. Is there a way to stop them from being dropped during the import?

Thanks for all the help guys, it is greatly appreciated. On another note, I want to take some classes to on SQL and VBA. I was thinking SQL first with some online courses. Has anyone here taken a good online SQL class?

Your code includes this: Dim strFilename As String strFilename = Dir("C:\OldFolder\data*.xls") I have doing something like this: strPath = Dir("C:\OldFolder\data*.xls") but without using the Dim portion. It functions but should I be adding: Dim strPath As String to my code?

I used the Dir function this way and it worked - FileCopy "C:\OldFolder\" & Dir("C:\OldFolder\data*.xls"), "C:\NewFolder\data.xls" I have schooling on writing VBA, I am just picking things up as I go along so I am not sure if that is how you meant for me to use the Dir function.

The big thing I do not understand is how some people said it worked fine without the need for any other functions.

There is only one file in the folder at a time.

Good evening. I have an Excel file name "data123.xls" in one folder and want to copy it into another folder. This here works fine: FileCopy "C:\OldFolder\data123.xls", "C:\NewFolder\data.xls" Sometimes the data file will have a different numerical sequence. I cannot this to work: FileCopy...

Thanks that worked. I would swear I tried that and it did not work. Maybe I typo'd it the first time.

VBA

I tried doing this here - strPath = c:\thedbguy\testing\ And tried several different iterations of this - insert into qualifie select * from [dBASE III;HDR=NO;IMEX=2;ACCDB=YES;DATABASE=strPath].[qualifie] Can it be done or does it need the path typed out for each DBF file?

No worries. I am not a developer. 95% of the what I can do I learned on the fly to resolve an issue. If I can copy/paste something and it works then great. If it does not work I look at it. In some cases I understand the coding and can trouble shoot. In most cases I cannot.

Thanks for the replies everyone. Doc - I imported the class module and put the code from your reply in a module. The "Return CSResult" turned red as soon as I pasted it. I wound up using pbaldy's solution and it worked great. Thanks again for the help.

Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...

After reading this I changed the way I checked the data for nulls in the Part Manufacturer field. I have everything working the way I want it to. I do not want it to just delete the data where there are nulls. I wanted it to ask as it would be dependent upon what I am doing. Sometimes I am...