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 have linked excel files to my access database and wrote queries for data retrival. Now the problem is, when i open the linked table in Ms Access or run a query, I am not able to open the excel file at the same time. It says, "this file is in use. try again ".. Is there a solution that i can open the excel sheet while it is open in Access?
There is a field already that has a dropdown menu that a user selects from and there is a PDF on a fileserver that is associated with every selection possible.What I want is the PDF file to open automatically (or maybe a button to appear) once the user makes a selection from that dropdown menu.
So far what I have is a hyperlink field and a couple test links and a created button on the form with a sketchy macro I came up with (an if statement saying if the selection made = the selection field, look at the hyperlink and open it).
And yes I now that's the title of a Knowledge base article, I stole it because it put into words what I can only say in expletives right now.
Basically, well it's all a bit odd. I got users on the network who, until yesterday, could access some networked databases. Other files from the same source are ok, just Access files. Today the moment they click (and I mean a single-click) on the icon to open the database...explorer hangs. You can't open the database from within MS Access either, that hangs too. But you CAN open them up and use them if you can get them copied locally. Oh yeah, some people (in the same room, on the same VLAN) can access the database, but can't perform any tasks within it. Databases are a mix of 97 and 2000. And to make matters worse, it's happening on another server.
I know you're gonna shout virus, but that looks to be a non-starter since I know of no such virus which would affect ONLY Access files and do it on a single click, and secondly The systems check out fine with both Sophos (and our good luck charm AVG) run against them.
Holy Moley! Has anyone ever come accross such a palarva?
I have a code to add links to files into a field, I recently migrated from Windows 7 to 8 and the name of the folders in 8 are different; therefore the database I have does not find the linked file anylonger.
To avoid this happening in future, I would like to have the option for the user to set the folder path through maybe a table and then the link will refer to the settings in the table.
Currently I am using the following code:
Private Sub AddLinkDoc_Click() Dim strFilter As String Dim strInputFileName As String Dim varDirectory As String varDirectory = "C:UsersMarco TagliaferriDocumentsBA CityflyerCrew SchedulerDocumentationDocs"
I have an MS-SQL backend which i use for my data source. I then use Access for reporting services. (It works so much better than SQL Reporting Services 2005).
this seems simple, but i can't get it to work. Everytime the users start up access, It pops up a login and password for the ODBC link. Even when i have the password and login setup in the ODBC DSN, it still requests it everytime you start connecting to the datasource.
Is there anyway to somehow hard code this into the Access front end somehow so i don't have to give the password to the users?
I am not the best in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access which is hosted on an internal server. Anyone help with quick steps on how to do this, It would be greatly apprciated.
There are those builtin bmp images in access e.g. delete, edit, select, filter, etc etc. I am trying to access the location of these small bitmap images and use them for a web application i am creating. Do you know where they are located? I am searched with no luck.
Someone also sent me an access db, i'd like to reuse the buttons (same bitmap images: edit, delete) from this access db. Where do i go to extract the images?
As expected when we published to Sharepoint additional fields were added to the Access tables [App Created By] and [App Modified by]. We want to use these fields for Audit information however they are always empty. How should they be populated?
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.
Is it possible to access "Database B" (an Access Database) from a switchboard in "Database B" (A separate Access Database)? And, if so, how?
This is the third question I have asked on this forum and with each of the previous question the answers have been very helpful. Just want to say thanks in advance to everyone that is a part of this. Good job all.
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 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.
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!
