Search results

I can't seem to get this to work. So, I have another option. I have attached a picture of a subform on a Main form. On this subform is a list of files linked to the Customer record. It has a Description and an actual link to the file. The file can be any type and it opens in its native format...

I get a Runtime error '91' Object variable or With block variable not set and this line is highlighted in Yellow: fso.CopyFile asSource, asDest

FileCopy (asSource, asDest) gives a syntax error. I tried it without the parentheses and it errored it as a bad file name. Also, strFileName is in there.Should it be declared?

I changed it and got a syntax error on this line. It highlighted the whole line. FileCopy ("\\xxx1.xxxxx.org\xxxx-1\xxxxxxxxxx xxxxxxxx\xxxxxxx xxxxxx\xxxxxxxx\1-1111" & strFileName) ("c:\xxxxxx\xxxxxxxxx" & strFileName)

I added the slash, clicked off the line and got a Compile error: expected =, and the cursor went to the end of the line. I added an = sign, clicked off and got another Compile error: Expected expression

Here is my actual code for the FileCopy line. I replaced letters with an x and numbers with a 1. FileCopy ("\\xxx1.xxxxx.org\xxxx-1\xxxxxxxxxx xxxxxxxx\xxxxxxx xxxxxx\xxxxxxxx\1-1111" & strFileName) ("c:\xxxxxx\xxxxxxxxx" & strFileName) I get a Compile error: syntax error.

I made the changes and ran it again. I tried some variations of that and ran them several times. It highlights FileCopy and gives the message "Compile error: Argument not optional." Here is what I currently have: FileCopy "\\F1.F2.org\F3\F4\F5\F6\F7" &...

I was just now able to get back to this. I appreciate your quick response. This folder is buried and here is a path. FileCopy "\\F1.F2\F3\F4\F5\F6\F7?" & Forms!frmMain!frmMainSub.Form.frmGetNumber.Number & "*. *" "c:\F8" I get a message "Compile error Expected: end of statement" and the...

I have a set up where users have their own front-end linked to a shared SQL back-end. After opening the Customer record, they have a button to click that will transfer data from the SQL DB to a DB on their C: Drive. This data is used at off-site locations. Upon returning to the base, new or...

No. There are 5 folder types within Folder1.

I know a website would solve this problem but Access is the tool at this time. I have a front-end database with a SQL back-end. The user’s front-ends are on a shared S: Drive (\\Hold1\Folder1). The data needs to be used offsite on occasion. Here is the process for when the user goes offsite to...

We tried several. What is usu upgrading?

I don't know if this is the right venue for this but I need someone to help. For years, we have had Access databases with an ODBC connection to an Oracle database. Each time something was updated or changed on the programming or computers, we had to relink the connection. It was difficult but...

I have a subform that records date parameters, that is DateFrom and DateTo. The subform is set to continuous forms. When adding a new record, they use the blank record at the bottom of the list. If the user enters a date in the DateFrom field, I need to make sure the new date is not in one of...

I found it. It was in the load process. It updates when it is accessed by a user. Thanks.

My program uses an SQL backend. I do not have permissions to change anything in it other than data. One of the fields in a table is LastContactDate and I do not have any defaults for anything involved in using this field. When a record is opened for viewing and I close it, that field updates to...

I have a database that I use to store hyperlink files in. I have used this before in different versions of Access, 2003 to 2013, which is part of Office 365.The field in the table is a hyperlink field. I use a form where I right click on the hyperlink field, edit the hyperlink, and then find the...

We used to be able to see the tables but with Windows 10 and Access 2013, the ODBC connection is not there in 2013. Thanks.

I had a problem last Friday with connecting to two Oracle views from an Access database. New computers were installed and now had Windows 10 on them instead of Windows 7. About eight years ago the IT Department set up an ODBC connection to two Oracle views. When we first set it up, the IT guy...

I am using 2013 and it is really running slow. I used the Performance Analyzer on the tables and it returned several results. Most of the text displayed in the window was not viewable. The text was much longer than the window was wide. The hidden part is where the suggestions are. I tried...