arnelgp ..forever waiting... waiting for jellybean! Local time , 03:24 Joined May 7, 2009 Messages 20,276 Aug 25, 2017 #21 BETTER repair, Stellar Phoenix Access Repair.
S static Registered User. Local time Today, 20:24 Joined Nov 2, 2015 Messages 823 Aug 25, 2017 #22 How is £70 better than a bit of work you can do yourself for free?
Lanason Registered User. Local time Today, 20:24 Joined Sep 12, 2003 Messages 258 Aug 25, 2017 #23 thanks static for your help for the last little bit - how to I read the filename from the directory? do I need some sort of loop to read all the form names in the directory??
thanks static for your help for the last little bit - how to I read the filename from the directory? do I need some sort of loop to read all the form names in the directory??
S static Registered User. Local time Today, 20:24 Joined Nov 2, 2015 Messages 823 Aug 25, 2017 #24 Yes. Use the Dir() functionin a loop Code: Const folder As String = "c:\...\*.txt" dim FileName as string FileName = Dir(folder) Do Until FileName = "" select... ... End Select FileName = Dir Loop
Yes. Use the Dir() functionin a loop Code: Const folder As String = "c:\...\*.txt" dim FileName as string FileName = Dir(folder) Do Until FileName = "" select... ... End Select FileName = Dir Loop
Lanason Registered User. Local time Today, 20:24 Joined Sep 12, 2003 Messages 258 Aug 25, 2017 #25 many thanks - forms working and imported now working on query and reports etcx
