Sound Files In Forms

Jun 22, 2005

how can i automatically play sound files in forms i still use access 2.0

View Replies


ADVERTISEMENT

Forms :: Adding Sound (WAV) To Event?

Nov 16, 2014

I want to add a sound (not beep but a small wav) to an event in a form.

View 2 Replies View Related

Forms :: How To Play A Sound From A Subform

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

Forms :: Play Sound With Event On Open Form

Jun 7, 2015

How can I play a sound with event On Open Form.

View 13 Replies View Related

Forms :: Make Beep Sound When Try To Type Into Locked Textbox Control

Jan 31, 2015

Nothing else to explain really. How can I get my database to make a beep sound when something is trying to be typed into a locked textbox control?

This is so that my users can know that it's locked (much like when the delete button is pressed on a new record).

View 6 Replies View Related

Add Sound

Sep 26, 2005

Im sorry that i am a noob.

I want to ask how do i add a sound after I have timer to display countdown time. When the timer reaches 00.00, the sound will appear. How do i do that?

View 1 Replies View Related

Sound...

May 22, 2006

Is there a way to attach a wav file or mp3 file to a command button?

View 2 Replies View Related

This May Sound Stupid

Jan 7, 2006

Ladies and Gents

I am wondering if when i run my report is there anyway that the detail of the report can become objects that say i could drag and drop into a Word Doc for example. I am trying to create a tool that will allow me to see all jobs from our maintenance mangement system at work, i have managed to achieve this but i was wanting to be able to view the jobs on a report and then basically just drag them into something else and wahey i have built my plan for the week.

Maybe i am hoping for to much but i though i would ask anyway.

paul

View 1 Replies View Related

Ill Sound Stupid

Aug 7, 2006

i probably want to create a upddate querry or maybe some code but...

i have a light bulb and i keep 300 on hand i just ordered 300 more when i check the box that the order is complete i need the "bulb on hand" feild to update to 600....please help

View 1 Replies View Related

Adding Sound To A Form

Mar 27, 2007

Hello,

I'm working on a splash screen to spruce up the opening of one of several databases I've created. I hate for them to appear boring so I like to add a bit of color at the beginning, a la Northwind's.

I haven't found anthing on this yet so I thougt I'd ask...

How can I have a sound I've downloaded from clipart or somewhere, PLAY when the form opens or loads or whatever...

Thanks in advance!

Goh

View 1 Replies View Related

Sound When Opening A Form?

May 11, 2005

Is it possible to have a set sound play when a form is opened? And if so does anyone no how it is done?
Thanks in advance for any help

View 3 Replies View Related

Listbox Only Makes Exclamation Sound

Nov 30, 2006

Hi All,

I have been trying to improve a form used to add/edit names in a mailing list. What I want to do is check the database for possible duplicate names and alert the user to the fact that their new person may already be in the db.

I used the following VBA code in the After Update event as follows:

Private Sub txtLastName_AfterUpdate()

On Error Resume Next
Dim strLastName As String
Dim NbrNames As Variant
Dim strNameSQL As String

txtLastName = Trim(txtLastName)
If Not Mid(txtLastName, 1, 1) = "=" Then
txtLastName = StrConv(txtLastName, vbProperCase)
Else
txtLastName = Mid(txtLastName, 2, 999)
End If

' Test for duplicate last name in data base
NbrNames = DCount("[tblMemberListings].[mlLastName]", "tblMemberListings", "[tblMemberListings].[mlLastName]= '" & txtLastName & " '")
If NbrNames > 0 Then
strNameSQL = "SELECT ALL tblMemberListings.mlID, tblMemberListings.mlLastName, tblMemberListings.mlFirstName, tblMemberListings.mlSpouseSO, tblMemberListings.mlAddress " & _
"FROM tblMemberListings " & _
"WHERE ((tblMemberListings.mlLastName) LIKE '" & txtLastName & "*') " & _
"ORDER BY tblMemberListings.mlLastName, tblMemberListings.mlFirstName, tblMemberListings.mlSpouseSO;"
lstDuplicateNames.RowSource = strNameSQL
Beep
lstDuplicateNames.Visible = True

End If


End Sub

This generates a useful list of potential persons already in the db. The user then has the choice of continuing to add the new name and address or they should be able to select one of the names in the listbox and refresh the form with that person's data for possible modification.

I currently have these two Event Procedures in place:

Private Sub lstDuplicateNames_AfterUpdate()
On Error Resume Next
'MsgBox "Sub lstDuplicateNames_Click value = " & lstDuplicateNames.Column(0)

If Not IsNull(lstDuplicateNames.Column(0)) Then
' User chooses and existing record
Me.RecordsetClone.FindFirst "[mlID] = " & lstDuplicateNames.Column(0)
If Not Me.RecordsetClone.NoMatch Then
Me.Bookmark = Me.RecordsetClone.Bookmark
End If
Me.lstDuplicateNames.Visible = False
Me.Refresh
End If

End Sub

and

Private Sub lstDuplicateNames_Click()
Me.txtHidden.SetFocus
Me.lstDuplicateNames.Visible = False

End Sub

The problem is that when one clicks on one of the listed names just two things happen:

1 - a fine dotted box outline appears around the *first* record in the listbox
2 - the MS Exclamation wav sound is generated each time the mouse button is clicked. :confused:

Short of enrolling in a local junior college that offers Access 101 what can I do to get this addition working? I'm also not sure that my code to refresh the form is going to work, but right now I don't ever get there. ;)

Oh, this problem is occurring in MS Access 2000.

Any help would be greatly appreciated by this NOOB.

Divit11

View 3 Replies View Related

General :: How To Make Sound Like Making Call To Another Computer Using Vba

May 19, 2014

I'd like to make noise to another computer, or start same sound file or simply to call another computer on lan or through vpn connected computer using vba...

That will be nice if I can press button on access form and user on another computer hear some noise or to loo like it is call

View 1 Replies View Related

General :: Access 2013 - Possible To Play Sound File

Jun 3, 2013

Is it possible to play any kind of sound file from Access?

View 1 Replies View Related

Modules & VBA :: Loop Through Files And Then Compare With Files In Database Table

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

Forms :: Opening Files From A Form

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

Forms :: Upgraded App Can't Show PNG Files?

Oct 23, 2014

I've upgraded an old Access 97 app to Access 2010. Now I want to replace an icon on a button with a new icon, but when I choose the new icon, which is a .png file, I get a message that:

Code:
Program doesn't support the format of the file ..path...image.png or file is too large.

It's definitely not too large. I don't want to use BMP format as I would like to keep the transparent background.

View 1 Replies View Related

Forms :: Open And Save Doc / PDF Files Within A Form?

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

Forms :: Move Files From Local Directory To FTP Location?

Sep 6, 2014

I would like to have a Button "Files to FTP", So, the Macro should move the files from the Local Files from the Directory to the FTP Location.

View 6 Replies View Related

Forms :: Insert Data Into Table By Calculated Files?

Mar 12, 2014

I have calculated files in a form which is summimg the working hrs of each employ�es for a particular data.

I am able to show the same in the form but want to add this value in the table.

Is is possible to add this data from the form to the able?

View 1 Replies View Related

Forms :: Unbound Combobox - Sorting List Of Files

May 19, 2014

I have a BackUp and Restrore from BackUp procedure in my my database.

I can backup to a spreadsheet and the spreadsheets are renamed to include the date of the backup.

When I restore from the backup an unbound combo is populated

Code : Set SourceFolder = FSO.GetFolder("c:GPandDetectionDogTrainingLogBackUp")

This all works, the only issue being, is that I want the most recent backup to be at the top of the list, at the the moment its at the bottom.

is there a way of implementing a sort order, bearing in mind that its an unbound combobox.

View 5 Replies View Related

Using MDB Files Which Are Backed Up Hourly Into Zip Files

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

General :: How To Create Forms In Access DB Which Uses Links From Source Files As Its Tables

Sep 7, 2012

I have a client who needs a Database created in Access for him. he would like to regularly auto-populate this Access DB from an Excel file - like twice a week.In addition, he wants me to create Forms, Queries, reports and Macros for him in the Access, which will have 2 Tables from Excel files and about 3 Tables created in Access.I figured that I could do that if I gave him a link to the Tables he needed from the Excel file(s). But how do I work remotely for him- the path to those files is on his computer. I can load them to mine, but then he can't open the files.How can I create Forms etc. in an Access DB which uses links from source files as its Tables?

View 2 Replies View Related

Forms :: Function To Enable / Disable Button Depending On Files Imported Or Not

May 20, 2015

I have 3 macro importing 3 files, and then another button to process those data.

So, I need a function to enable/disable the button depending on the files have been imported or not.

View 1 Replies View Related

Forms :: Adding Links To Files Into A Field - Accessing Correct Folder

May 16, 2014

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"

[Code] ......

View 2 Replies View Related

MDE Files

Jun 20, 2005

Hi guys.

Just a quick one, I couldn`t find anything on this or in any books I have.

I`m assuming I need to create an MDE file befire I can distribute my database for other people to use ?

Anyway, that I have done, but the question is, I`ve done this and have a select number of ppl using my database, entering LIVE data etc.

Once This has been done can I open this back up in access and make changes to the database, eg forms, reports etc etc ?
If not, is there anyway, I can pull the data out of this and import it into my origanal file, which can then be remade into an MDE ?

I hope I have made myself clear.

Thanks in advance for any help!!

Max

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved