How To Embed And Play Wav Files Into A Form?
Feb 17, 2006
Greetings:
This is a new area for me and I am struggling with how to approach the solution. Have searched the archives but still can't figure it out....
I have a database that stores call center coaching events. I would like to insert a wav file (recorded conversation) into each record and be able to play the wav file when the record is current in the form.
Any guidance or suggestions would be greatly appreciated.
Thanks!
John
View Replies
ADVERTISEMENT
Mar 8, 2006
Hi everyone
I know it's possible to use Access to create a Word document and think it's possible to have a button (or combobox) open a Word document saved on the hard drive. If I'm correct with the second belief, the Word file(s) would need to be moved with the Access database if it's moved to another directory or PC.
Is it possible to save the Word (or other) files within the database itself so simply moving the database to another directory or PC would take the "embedded" files with it? I realise that the database file size will increase, but suspect that this increase would be similar to the size of the individual Word files.
Thanks for your time.
View 2 Replies
View Related
Mar 2, 2005
i have a series of short Avi films( they can be converted to another format is better suggestion) that are basically a tutorial films on how to use my database...
what i want is a form to have a list of these files so the user can choose which one to play the file within Access as a tutorial section...
Can this be done, if so anyone fancy helping me with this one please.
Cheers
Andy
View 1 Replies
View Related
May 26, 2005
I have a form that I would like to embed some text that is queried from the internet. I'd like to have a part of this form display this "quote of the day" info in a textbox, and im not sure how to do it.
The link to access the quote is through javascript:
<script language="JavaScript" src="http://www.quoteworld.org/quotes.js"></script>
Any ideas of how this might be accomplished?
Thank you,
BT
View 1 Replies
View Related
Jul 26, 2006
Hi,
Friend I am bigner in ms acess I have datbase .
I want when I load main page sound/music .
when i open another page I want another soundplay that music
.
Plz ur help
Thanks from Iraqi
View 4 Replies
View Related
Jun 26, 2013
I made a db with tons of forms and they all have pictures on. I want to know if there is a quick way to embed them all so I don't have to go in the settings of every picture and do it manually!
View 1 Replies
View Related
Oct 21, 2014
I have a form with a lot of data structured in tabs. Since the tab loads all the data at once while the navigation form browses to the desired form. I have tried but the issue is the Master-Child link. The form in the navigation form is not considered as a subform, hence, no way to set a Master-Child link. The navigation form itself is the subform but even when setting up a link there it has no influence on the form displayed by the navigation form.
[URL] ....
View 3 Replies
View Related
Jun 7, 2015
How can I play a sound with event On Open Form.
View 13 Replies
View Related
Jul 28, 2012
I am new to ACCESS, I have some experience with SQL, VBA and RDBD having been trained by ORACLE
The attached tables come from a RB I am making, I can run the SQL and it works, I have failed to create form or report tha enables users to simple use a button to invoke that code.
Several people have sent answers but I have not made them work, the tutorials that I have looked do not explain with simple examples that I can follow.
View 2 Replies
View Related
Jan 26, 2015
I need to be able to embed an interactive word document in an access form. The need is to put in text that has underlines and strikethroughs to indicate name changes to policies.
The user creates a new proposed update by designating the policy number but I need a word file attached to this update that can show more punctuation than access can show.
Of course I want to make this as automated as possible so the user doesn't have to work in two different places to get this done.
View 3 Replies
View Related
Sep 22, 2005
Hi there
This is my problem
1) I have just spilt my data base into the front end and back end. I did this not using the wiszard. What i would like to do is to limt total acess to my databank. I want guest to be able to view my data and those who are allowed to can edit the data. How do i do this exactly
2) I want to be able to watch closely and see who is doing what, i would like to record, in a table, those who edit the data and those who enter data. i would like to keep track of whats going on in my data bank. So to seen when the data was newly added and what data to my data bank and to see who and when the changes have been made.
____
new
if there is a simple way to add the password system i am all ears
Thanks in advance.
g.
View 2 Replies
View Related
May 4, 2005
I'm using sample code which i will paste below, it includes in the form a comman button, animation control and activeX control. it plays clipart files but when i try to play a movie inavi format such as a movie trailer it says it unable to open..what could i do to make allow all types of avi files.
Private Sub cmd2_Click()
With Cd2
.Filter = "avi (*.avi)|*.avi"
.ShowOpen
End With
With An2
.AutoPlay = True
.Open Cd2.fileName
End With
End Sub
this is sample code from msn website and works for clipart avi files but it seems not to open normal avi movies.
what would have to be done in order to allow any avi to play and or is there any other way i can play avi (any sort) on the form and which also allows me to choose any avi file (i.e from a table etc)
cheers in advance
View 4 Replies
View Related
Oct 23, 2014
I was curious if there is a way to embed images into a database, so that if I emailed it to someone, the images would still be able to open. I tried using a table and adding attachments, but that doesn't seem to work very well.
View 6 Replies
View Related
Sep 15, 2013
I have to tables:
Table 1 contains "cases picked"
Table 2 contains "cases required"
i have a query with info populated from those 2 tables:field "results" shows the results of this calculation: "cases required"-"cases picked"="results".In this query I have a conditional format stating: If true, displays text "ok" and the field will be green, if false, displays text "alert" and the field will be red.
Then I have this query in a subform (a form within another form),I would like to have a code or a formula for this query, where it would play a sound if (and only in this case) the value of "cases picked" is bigger than the value in "cases required"
This is how it works, you open the main form, start using a barcode scanner to scan cases, everytime you scan each case, the subform is refreshed and adds cases, and shows results, and shows how many cases you are missing or how many cases you are over, but this is only in the screen, i would like to have a sound in this subform, so in case you pick more cases than required, a loud sound is played as an alert, i still can't figure out where to put the solution, if as a formula in the query, or a code in the subform.
View 2 Replies
View Related
Jun 3, 2013
Is it possible to play any kind of sound file from Access?
View 1 Replies
View Related
Nov 11, 2013
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
[code]...
View 7 Replies
View Related
Nov 9, 2007
Hello,
I need to be able to take information from a table in access, use this information to populate a PDF file, and then save the PDF file.
i.e. I have leads in a database and I want to pre-fill in application forms (PDF) for the clients.
I did some searching pertaining PDF, but didn't find exactly what I was looking for.
Where should I start?
View 3 Replies
View Related
Mar 10, 2006
I'm new to Access but have made a database of my music collection. Is it possible to get the selected mp3 file to play on the click of a button directly from a form? My music collection is store in several sub directories on my hard drive.
View 4 Replies
View Related
Aug 19, 2004
I want to link files that are associated with a row in a table. I have added a field to the table that contains the file name and have added a field on my form to display the filename. I have set the "Is Hyperlink?" option to yes on the properties panel. But when I click on the link, nothing happens. I get no error message, nothing. I want to be able to link, word, powerpoint, visio, etc. Any suggestions?
View 2 Replies
View Related
May 2, 2012
Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.
What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?
View 3 Replies
View Related
Sep 13, 2005
I need a form for selecting input files. I already have my VBA code, queries and so forth for what I am going to be doing to my files, but now I need to have a form that will allow me to select different files for processing.
Does anyone have a sample, a snippet of code, or suggestions as to how I can achieve what I'm looking for?
Thanks in advance!
View 3 Replies
View Related
Dec 6, 2005
... anyone know how to insert these?
I'd like to put a couple of small animated gifs in one of my forms. Importing them as a picture doesn't give the animation (it's a static picture).
Any thoughts on a simple solution would be appreciated
Cheers
Ian
View 1 Replies
View Related
Apr 15, 2013
I have a very simple table of basically a unique number and a couple data fields. On my form with those same fields, I need to be able to create a button that opens a pdf file that is named the same as that unique number. Here is the kicker...I have been able to create a hyperlink with a link to that file and it works fine.... I am trying to set it up so that the file name is automatically put into the hyperlink statement according to what the unique number is for each record.
what I did so far...
in my hyperlink: *file://c:/docubase/3840.pdf (only put * in so not a link here)
this works fine but I need the syntac to make that line take into account the account field (ID) for each record. So something similar to this (already tried this and it doesnt work)
*file://c:/docubase/[id].pdf
View 11 Replies
View Related
May 4, 2006
I've been looking around and have found some posts that pointed me in the right direction, I just can't get it to work. What I have is 37 excel files of competitor cross references. There are 2 columns in each excel file, our number and their number. I have inserted them as a linked table in the db. What I want to do is create a form that has a field for every part number and make all of those fields a search field. That way they can type in any number and get all numbers back. I have created a query but once I get past 4 linked excel sheets then I get errors about a type mismatch in expression. Also I can't get the form fields referencing the query to show up when I open it. If I leave the query at 2 or 3 fields and use [Forms]![CrossRef]![txtItemNumber] in the criteria of our number in the query, it works. I get a window that pops up when I just open the query asking for a number, I type it in and the query returns the number and competitor numbers. Am I doing this the hard way?? Thanks for any ideas...
View 1 Replies
View Related
Mar 12, 2005
I have based a form on a parameter query, so that when the user is prompted to enter a 'Hobby' to search on, the relevant records will be displayed on the form.
Now, I have created a command button designed to open a template letter in MS Word for a particular hobby. The problem is, I need the command to open certain file depending upon the value input in the parameter box intially. How would I go about doing this?
View 1 Replies
View Related
May 21, 2014
In a record, I want to have a text box which displays the file path to a .pdf or .doc, docx file. If you double click in the text box the file within the text box opens. If there is no file path I want a small command button to be visible next to the text box, which will launch an explorer that will locate and save the path of a chosen .pdf or .doc, docx file.
I have a field within a tblPriceList called quotefile, which I want to store the file path.
For info. This is not going to be a major multi user database, but the quote files will be stored on a vserver, not the PC the DB is being used on.
View 7 Replies
View Related
