I am trying to link a table from an admin system in Access. I'm not real confident that I will be using the correct terms here, so please bear with me. We recently migrated our admin system from Unix to NT. When we did that, the ODBC driver that we used to use to link to a table through Access changed to something that is called file.ddf. I have been able to run a Crystal Report by going through various steps:
Database file path:
cin********file.ddf
Then I have to Set Location in Crystal:
cin***filelocation (example)
However, I can only seem to run a report against one table at a time.
I like working with Access a whole lot better than Crystal but nobody here knows how to set it up in Access.
Is there a way to do this?
I know I probably didn't give all the information needed, and maybe it's not even possible, but any help would be appreciated.
The company I am consulting with uses Access 2000 and has no intentions of upgrading. I currently do not own Access on my laptop.
I was planning to purchase Access 2003 for my laptop but am concerned that files I create in 2003 might not be "editable" in 2000 even if I choose the 2000 format when creating new databases.
I'm just wondering if anyone has tried creating a file in 2003 (using the 2000 format - as I'm told you can choose what format you want to use) and then edited it in 2000. I want my client to be able to edit the files in 2000 once I've moved on. (I can get 2003 for about the same price as 2000 - so my preference would be to get 2003.) The other obvious reason for going for 2003 is that I could run into the reverse challenge if I own 2000 and my next client uses 2003. At that point, I'd be forced to upgrade to 2003.
My databases are not complex - but do include some customized macros.
I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .
Code: Loop through files in folder folderspec = "O:QA FilesQC ReportingPending Review" Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFolder(folderspec) Set fc = f.files
:confused: is ther anyway to lock ms access files , so that people would not be able to modify then and only view them, would not get to vbs screen etc, and give a limited password that will expire in given ammount of time.
Hi, I’m trying to Import an external CSV file in to Access and then Update/Add the record into a table. I need to be able to do it using SQL and I’m not allowed to touch RecordSet! Does anyone know How I could do this or where I would be able to find help on this.
We are running two versions of Access (97 and 2003) on some of our machines. We recently set up a new workgroup file, but it seems that on the machines that have the two versions of Access the workgroup file reverts back to the old setting everytime the user logs in again. What do we need to do to prevent the workgroup file from switching back?
Complete Access Newbie here. I am trying to create a Customer Complaints / Quality Assurance database and I am pretty much sorted except for one final thing that I wouldn't mind doing.
Because there is often a lot of support evidence with a complaint I wish to add this electronically to a record (it could be a Word Doc, Excel, jpg...etc..etc). So that whenever there is a link to the document to the supporting document on the record.
So really looking for an Add (and Browse for button) on the Form for each record.
For some reason Access will not allow me to open any mdb files. When i click on the file to open Microsoft opens the install wizard for office 2000 and asks for disc 2. If i press ok its says DATA2.msi is missing.
However if i open access through the Programs menu and then go and search for the mdb file i can open it with no problems.
My question is how to solve this problem as i have to copy give someone a copy of one of my databases and i don't want to pass on any bugs etc... ???
I have no problems creating an MDE file from a newly created database but the system hangs when I try to do the same with a former Access 2000 database that I converted.
This morning I converted an Access 97 db to Access 2003. Unfortunately the db will not now open any .pcx files. Does anybody know if there is there an issue with .pcx files. According to MSDN Access should (and you would expect it to) open .pcx files. I did notice that when office 2003 is installed it does not install the pcx graphics filter PCXIMP32.FLT and it does not appear in the graphics conversion tools download for 2003.
Hi all. I have been asked to develop two DB apps in Lotus Notes which filled me with despair since I would rather do this in Access 2003 but aparantly Notes can hold files. I know Access can link to files stored on a network but can Access match up to Notes in this feature and actually hold files the ame way as Notes ?
I've been reading everywhere on this site trying to find out how to do this, but just can't seem to grasp it. I see people saying it can be done, but can't find more specific details on how to go about it. I just want to view a pdf file from within the access environment. I need to be able to view contracts from my app, and joy oh joy they are all in PDF form.
Any help is greatly appreciated to get me started on this. I've tried using the Active X Adobe Acrobate Control but to no avail.
I would like to be able to print PDF Files from MS Access 97. I have a table with records containing all the information necessary to create full pathname of the file (i.e. strPathName). But how do I get it to print (not view) the file once the record is selected from a drop-down box. Do I have to create a module to do this? Or is there some simple trick? If anyone has come code for doing this, it would be much appreciated. Thanks!
I am trying to open a DBF file in VBA, I get the an error: Run-Time error '91': Object variable or With block variable not set
here is my code: '-------------------------------------------------------------' Dim oConn As ADODB.Connection OConn.open "Driver={Microsoft Visual FoxPro" & _ "Driver};SourceType=DBF;SourceDB=c:Mine 01;Exclus ive=No" '-------------------------------------------------------------' I tried the following code as well, but it gave the same error : '-------------------------------------------------------------' Dim oConn As ADODB.Connection With oConn .Provider = "Driver={Microsoft Visual FoxPro Driver}" .ConnectionString = "SourceType=DBF;SourceDB=c:ME 01;Exclusive=No" .Open End With '-------------------------------------------------------------'
Any ideas?
I need to open the DBF Files in the code using a connection string or any other method available through code.
I'm trying to link .DBX files to an ACCESS database. My problem is that the Dates are in this format. "20040123" and times are in "730" or "1630" and, all fields are TEXT. The Database is being used to help analyze production times and employee dates worked, so you can see I need to be able to perform calculations on these fields. Is there any way to translate them to Dates and times that ACCESS understands?
I have an access database with MP3 music stored in it.
This works file in access if I double click the access cell the the tune O want to here it works, so it looks like I can store MP3 sounds in an access database.
Not I have it in the database how can I extract it in ASP so the my new web-page will play the tune when the item is double clicked?
To play MP3 hard coded I put an embed this works with a file-name "mytune.mp3" but I want get those on the d/b.
I made this ASP: [code]<p><%=RS("Tunename")%> <br> <embed src= "<%=RS("MUSIC")%>" width="252" height="36"></embed></p>
where Music is the name of the cell containing the MP3 file.
This gave me: [code]<p>mytune <br> <embed src= "?$" width="252" height="36"></embed></p>
I'm importing .csv and .xls files into access using docmd.transferspreadsheet and it's simple enough except for a couple of issues I'm having:
1. The .csv file has leading ' and if I converti it .txt if has leading " in some of the columns .....what's the best way to get rid of these and is it better before or after the importing process.
2. a .xls file has a few rows of totals at the top so I need the importing to start at row A7 instead of A1...is there a way to control where it starts rather than manipulating the file prior to importing because it's all going to done by clicking a button on a form by user.
And there's a 3. one of the .xls has additional blank rows that it seems to import into the access table....what's th solution for that.
All the files will vary in number of records on a daily basis so I can't specify range like the DoCmd.
Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this?
Access files are locked in read only. We upgraded our network and moved the database to a new network - small business server 2003. Does anyone know why all database files are read only now?
I have a path to a JPEG file in a variable. I want to click on a command button and open the JPEG file. Is there code which in effect double clicks on the path to open the file? Thank you.
hey all, I would very much appreciate any help or ideas on how to do this as I am stumped. I need to develop an access database to track documents but also link to them. I’ll explain what it needs to do;
Every day there is a numbered (and titled) Word format document that is sent. Most, but not all of the time an accompanying excel file is also sent. The excel file is used for updates to the word document of the same name. Lets say the word document is titled DW101.1.doc and the Excel file is called DE101.1.xls The first would signify it is a Word document by D (being short for Document) and W for Word. The 2nd would be D for document and E for Excel, and then a number which is 101.1.
They are saved in a folder on the hard drive. Each time these documents are recd then the Access Database is opened and info about those documents is entered. The document name, date, subject, number etc. There will also be 3-4 fields that are also filled out with terms from the content of the document that could be searched by those 3-4 fields. So as each document is recd, it’s opened and ‘scanned’ for relevant terms and or content. That content is what will be filled in the search fields and then the subject will be the ‘main’ searchable item.
All this so far I can do with no problem. It’s this part that’s making me crazy. What I would really like to do is when the document(s) come in and are saved in the folder, from access you can open a dialog box, browse to that folder, and click in the file to associate it with the entry you are making for it in the database. That way when a search is done with terms or words or subjects that match that document it will bring up the results of the search as a hyperlink that will open that document.
The people that will be using this are not very computer literate to say the least. I could create a link to the document but I would have to be in design mode and it won’t show up as a record in a table. Any ideas would be very much appreciated……………..
