Am hoping someone can shine a light on my problem as this has me ripping my hair out.
first off I've set up a subform in my main form to display a query using a linked table as the data(a excel exported csv file). nothing special.
however, I have had to use a link specification to determine how the table is linked. i.e. what fields should be defined as double (as access treats them as integers for some reason even though the numbers are too big!) and which fields need renaming.
without this link specification, the data will not be handled correctly.
ok no problem. I've had this working. The table links fine.
When i came to roll out the database, I set up the security in order that multiple resources can use it at the same time.
Now when I log in and use the form I get the following error.
'Text file specification <filename> does not exist. You cannot import, export or link using the specification'
Arrgh. :confused: I used the specificition to link the table in the first place! I've tried refreshing the link using the Link Manager, I've tried re-linking it and I've also tried linking the table and creating new specifications, all with no luck. I get the same message each time.
My next step is to import the data instead(again I'd need to use a link specification). But I'd really like to solve this as I can see no reason why it shouldnt work.
How to generate an export specification file by using Access 2007. Many instructions says click on "Advance" while exporting a text file manually but unfortunately i can not find that "Advanced" option in my access software.
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
Hi everyone. I am considering adding a new feature to our customer database. Let's say we recieve a letter from a customer, I'd like to be able to scan the letter into the computer, saved as a PDF (for example) and then, on the customer form, provide a 'browse' button so that we could browse to the file and then the address of the file gets saved as a text field in the relevant table.
Next time someone brings up the details for that customer, the letter would be accessible via a hyperlink to the file.
In an access db, I want to add a field called 'FileName' and simply add a link to a file. In tabular view, would I simply put 'filesmynotes.txt' into the database? Also, when I asp this to a web page, should it (or can it) show as a hyperlink?
Is it possible to link external file again when database is ready and the source file has been moved to other location? And going farther -> is it possible to create some kind of dialog wich prompts user to point the external file as linked?
Here is what I would like to do. I have a folder say with 100 pdf's. What I would like to do is from an access folder be able to point to the specific pdf and have it create a link within the access form to the pdf they point to... Does this make sense?
Is there a way from within an access form that you can have a button that lets the end user look in a folder and select the pdf... and then create and store the link in an access form???
look for the best method. I have another software to work with my access. End of each month, ProgramA will generate an excel file with the monthly data. I want to import/link it with my access. I first try to import it everytime I generate the new excel file. However, there are one line at the end of the excel file with does not match the feild requirment, and generate an error table in access saying a number field cannot have string.
Then I try the link method instead. This time, it would work at all. The first time is OK, but the next time, I guess more lines are generate than the orginal in the excel file, it could not open up. Number of columns is the same.
The best method right now is to delete the last line of the new generated excel file, however, because I am not the one using it, I want to have a better method for my co-workers.
Are there ways to import excel data except the last line; or Are there ways to import excel file without an error table generate
I am attempting to add a command button on a form that will allow user to browse files, then select a MS Project file to import, then have it linked to the current record (by a hyperlink or icon of some sort) so that clicking on it will open that MS Project file.
I found the above thread and have imported the modules and the fFindOpenImportFile in order to test in my database. I have made only slight alterations to the code, as I am still a novice w/ VB, but may not have done so correctly. In the Private Sub bImport_Click, I inserted 'tbFile' where sample "C:WindowsWin.ini" had previously been, so that it will import the file already selected from the bBrowse_Click. (If there is a cleaner/better way to do this, I would appreciate any help.)
Here is an exceprt from the code: Private Sub bImport_Click() On Error GoTo Err_bImport_Click
Me.tbHidden.SetFocus
If IsNull(tbFile) Or tbFile = "" Then MsgBox "Please browse and select a valid file to import.", vbCritical, "Invalid File" Else If Dir(tbFile) <> "" Then CurrentDb().Execute "DELETE * FROM tImport" 'FileCopy "C:WINNTWin.ini", "C:WINNTWin.txt" DoCmd.TransferText acImportDelim, , "tImport", "tbFile", False MsgBox "Your file has been imported into the Database." Else MsgBox "Your computer does not have a C:WindowsWin.ini file so the import example will not work.", vbInformation End If End If
I have 2 files with linking tables. Both are posted on the same network drive for the office to access. However some users have their drive link to drive E: and some to G:, etc. How do I get the file to automatically find what drive the user has and update the correct link in Linked Table Manager?
I'm trying to figure out how to link a text file to my database with VBA. I know how to do this for other types of data sources, using the DoCmd.TransferDatabase acLink command, but need guidance using this with TXT files.
I am new to Microsoft Access and have a little problem. I have searched the forum and nearly found the fix but I didnt quite understand what to do, so im creating a new thread.
I have a Access Database and have a client page that stores all the information about that client. We produce reports (scanned word/pdf) for each client and we store the report files in a client folder using the Client ID taken from Access.
My question is can I somehow produce a link from the Client Form in Access to the Client Folder or Files in explorer. I have seen the Hyperlink option but that is only availabe in Design View.
I have a database setup to keep track of spare parts in my inventory. I want to have a button on my form page that will bring up a file with pictures of the object.
The file C:Data.Txt contains 5 columns, separated by a semicolon with the first line containing the names of the columns. The concern is that when the linked table is created, I get a single column with all fields concatenated value. the following style :
Col1;Col2;Col3; : Column name Val1;Val2;Val3; : Row value
What does do to have columns separated with the corresponding values?
I am trying to set up a link to a file folder on the computer fore each individual, it is not going to the individual people, it is just going to the one person where I put the link to file.
I have a database that I plan to use to help us manage an old "Remedy" system.... There is a field for "Ticket number" I want to be able to click a button and have this ticket open in Remedy.
Remedy DOES have a link system. When I creat a link it creates a file like this:
Ticketnumber.ARTask
The contents of the file are simple:
[Shortcut] Name = NTRS-Trouble Type = 0 Server = samson Join = 0 Ticket = NTRS422904
The name of the file seems to be irrelevent. How can I programatically get the button to re-write the ticketnumber into that file, in that spot (after the letters "NTRS") and then have it open the link? I figure I can keep 1 file in the working directory and just re-write that same file over and over again... I just don't know enough about VB or macros to figure it out.
Basically it's trying to take all the files in a given directory and add them into a existing database.
I have a database called Permit. the database has a field called "SEAL" and they will be creating an additional field "SCART" to hold the contents of the file that exist in the directory. Each image file, in directory, is named the same as a unique record in Permit.
example: Permit-SC might have unique record 532442 An image file would be name 532442.
If the image file matches a record in Permit the image should be added to permit in a field called "SCART". At this point I'm not certain if I want a link or the actual image included in the record. since there's a possibility of including the permit file on the website it might be cleaner to have it included.
hi all, i found this forum recently and always seem to find my answers on it, this is the first time i havent.. so. firstly i am using access '97 (work is soon to upgrade to 2003 - finally).
my problem is i'm trying to export a query to txt file, which i'm doing by
the eParcelSpec i had to make via importing a text file, then on import text wizard, chose advanced, setup my field dilemeter to * and text dilemeter to none. this is saved and i can open it up going through the above process. however when my docmd runs i still get the standard output with "fieldvalue" , "fieldvalue2". instead of the * and no comma
its important for this to be the other delimeters, as the exported file is going to be used in a posting company's program that requires a certain format to import shipping address information.
also, is there anyway to add lines to before the data is exported? i need to have a start of file and end of file characters before any data and after the data.
Hi, I would like to rename my access file. My problem: I have many pivot in excel link to this database so if i rename it all the links will be down...How can i resolve this?:confused: (of course rebuild all pivots could be a solution but I have around 50 pivots behind my database) Thanks for your help!
I have a form displaying records. I would like the user to be able to select a button, browse for a file on a shared drive and link it to that record.
I have been exploring hyperlinking, which works for the most part, although I need it to display the share name rather than the drive assignment for that user. Such as drive1folder rather than C:folder.
Hyperlinking also unfortunatly requires the user to right click on a field select edit hyperlink then browse.
I'd like to import an excel file but the data begin from cell "A10", above there is a "privacy text".Is it possibile import or link the excel data in an access table directly from the cell A10?
I'm trying to create a file, save it, create an email with a link to the file in it, and send the email. But the link in the email doesn't work if there are any underscores ("_") in the file name or file path.
The folder that I need to save the file in and link to in the email has underscores ("_") in its name. I cannot rename the folder.
The attached database, when you click on the button, will create an Excel spreadsheet with "RED", "BLUE", and "GREEN" on it, save the spreadsheet in the path you enter with the name 'Test_File' with date and time appended, create an email with a link in it to the spreadsheet, and send the email. You must enter your email or an email address that you can use for testing in the form and enter what you want for the file path. Enter the file path with a slash at the end. Do not enter a file name. Then click on the button and wait a minute or 2 for the email.
When you receive the email, click on the link. It does not work.
If you change 3 statements in the code for frmMain, it will work:
Code: strNow = Replace(strNow, "/", "_") '<------ Change _ to - and it works strNow = Replace(strNow, ":", "_") '<------ Change _ to - and it works filename = "Test_File_" '<------ Change both _ 's to - and it works
Change as indicated.
So how can I get it to work with the underscores? I could actually do away with underscores in the file name but the folder that I need to hit has underscores in its name.
