Search results

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

That gave me a compile error right after pasted it in. I had also tried several iterations of - If Len(DLookup("[Part Manufacturer]", "[accupi_export_sheet]" & "")) = 0 Then But all those did was not open the message box. I can get it to either never open the box or open it all the time.

Good afternoon. I have this if statement in VBA - If (Not IsNull(DLookup("[Part Manufacturer]", "[export_sheet]"))) Then If (MsgBox("Delete PN's w/o manufacturer names?", 4) = 6) Then DoCmd.RunSQL "DELETE FROM export_sheet WHERE [Part Manufacturer] IS NULL", -1 End If...

I know there are options already selected by default. I am assuming those values are stored somewhere in the registry. IDK if I could create a new registry entry that would add what I need to that default list.

I was hoping for something like a registry hack.