Search results

Thank you for the code. I will try this. Also, I have no control over the network and Access users are at the bottom of the totem pole. I back up the data consistently.

All of our databases, front-end and back-end, are on a shared network. I have to put in workarounds for the various interruptions, which occasionally corrupt the database. When it gets corrupted I get Chinese characters in some of the fields. I would like to be able to use an If Then statement...

It is not called controlname. Thank you.

Got it. strCustID = Forms!frmMain!frmMainSub!Form!controlname Kill "C:\Folder1\Folder2\ " & '" & strCustID & "'"

# strCustID = Forms!frmMain!frmMainSub!Form!control Kill "C:\Folder1\Folder2" & '" & strCustID & "'" # Like this? Also, the control is not named control

Can you give me an example of using code tags.

My mistake. I did. Kill "C:\Folder1\Folder2" & '" & strCustID & "'"

Here is my last attempt. The control is on a subform. Start of Code strCustID = Forms!frmMain!frmMainSub!Form!control Kill "C:\Folder1\Folder2" & '" & strCustID & "'" End of Code I get a syntax error on the second line.

Nothing happened. But, the Customer ID will be a number with six digits.

Dim MyVar As String MyVar = "C:\Folder1\Folder2" & CustomerID If Dir(MyVar) <> "" Then Kill MyVar

Tried several variations and could not get it to work.

I have a database and use part of it for billing. I create a file and upload it to a site. The structure of the file is M123456.1. The next file generated would be M123456.2, and so on. In order to keep the folder cleaned out and make it easy to identify the file to upload, I get rid of similar...

Got it. Thank you.

Yes. How do I do that?

That did it. Many thanks for your help.

I tried that and it doesn't work. I get the same error message.

I use this same format elsewhere in other databases and it works. START OF CODE InvoiceAmount = DLookup("InvoiceAmount", "tblInvoices", "[Invoice] = '" & Me.Invoice & "'") END OF CODE Here, it doesn’t work. I have tried this with a query and a table as the RecordSource of the form. Here, I...

Ranman256, This looks as though it may solve my problem. I am not that good with the code. I am trying to figure a way to get the corresponding files from one location to another. The naming convention we use is to name the files with the Customer ID and a brief description. On the...

In experimenting with the above, I added a button to the subform that opens the folder that holds the linked files. I am using: START OF CODE Dim Foldername As String Foldername = "\\xxx1.xxxxx.xxx\xxxx-1\xxxx\xxxx\xxxx\1-1111\" Shell "C:\WINDOWS\explorer.exe """ & Foldername & ""...

We tried this in different ways and it hasn't worked, yet. I have another idea. Let me explain. We have a networked database with a SQL backend that is on a network drive. The users have a frontend, also located on the network drive. They work offsite a lot. Since this is not a web based...