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 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

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

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

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

Sound Files In Forms

Jun 22, 2005

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

View 1 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

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

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

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

Modules & VBA :: Adding Controls To Form And Saving Modified Form

Dec 3, 2013

I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form.

I have tried using the following, both produce errors

Code:

DoCmd.Save acForm, "tmpQueryDes"
DoCmd.Close acForm, "tmpQueryDes", acSaveYes

View 3 Replies View Related

Open Form Not Adding Record And Use An Add Button On Form

Aug 2, 2006

I have a database with three tables

table 1 (form1)
reference (PK) auto number

table 2 (form2)
Reference (fK)
workbook reference (PK) auto number

Table 3 (sub form within in form2)
Reference (FK)
workbook reference (fK)
data Reference (pk) auto number

Each table is a form that is linked via the keys. On form 1 i have a button that is to open the form2, which it does but every time i open the form a new record is added. Why and how do i prevent this.

Then what i want to do is add a button for a new form on table 2 form but use the same reference as the record as presently displayed. How do i add new record using the same Reference but new workbook Reference?

Thanks is advance

View 1 Replies View Related

Adding Data To Form

Feb 2, 2005

I am using a database prepared by someone. But it seems that when i try to add data to a form I am not able to do that. Neither can I edit it. For both these purposes I need to use the table . i.e for adding records and for editing too.
Is it possible anyway that I can change the record in form it changes in the table as well. or I will have to work with tables all the time

Regards
Rahul

View 2 Replies View Related

Adding Data To A Form

Feb 9, 2005

Hi,
how can I update the form with all the data of the table after modifying the form if it doesnot contain any data.

View 3 Replies View Related

Adding Field To A Form

Jul 13, 2005

I am using a Microsoft Access Form and would like to add some new fields and have no idea where to start. Any step-by-step help would be greatly appreciated.

I am an amateur and would need step by step so minute details would be greatly appreciated.

Thanks!

View 2 Replies View Related

Adding Records Through A Form

Aug 31, 2005

I have a number of tables all with there corresponding forms. I am needing to have a command button on the form for the user to easily add a new record. Obviously this is easy by just using the wizard but my problem is that I need the record to be added over all the tables.

This is an attendance database with tables for each month. So when a new member of staff joins and there record is added for that particular month I would like it to be added to all subsequent tables as well. Is there a way of doing this. It would also be beneficial if a similar thing could be done for deleting staff (i.e. a staff member is deleted from one table and subsequently is removed from the other tables)

Any help with this would be greatly appreciated

View 4 Replies View Related

Adding Records Via A Form

Aug 31, 2005

I have set up an attendance database with tables for each month. Each of these tables has its corresponding form. I want to be able to add a command button onto the forms to add a new record. Obviously this is easily done using the wizard but my problem is I want it to be added over a number of tables.

For instance when a new member of staff arrives and is added to the database I want there record to be added over all the subsequent tables not just the one attached to the current form. It would also be beneficial if I could do the same for deleting staff (ie someone leaves they are deleted off the current table and all other tables)

Is there a way of doing this.

Any help would be greatly appreciated

View 7 Replies View Related

Adding A Sub Form/Table

Jan 17, 2006

Hello all,
i am making a form to process ordering within my membership system,
i would like to add what i believe is called a subform or table of somesort, which is all connected to the same table i am using, but i would like it to appear in hte table format so that i can add more than one product that my client is buying.

the attachment i have shows what i have so far, the product information on the left is what i would like to be in the table area.

View 2 Replies View Related

Form Not Adding Records

Mar 28, 2006

Hey everyone... got a little problem, i have the followinf form/subform setup show in the screenshot below, for ages the calendar conrol there has worked fine, its control source is the date field on the left habd side.

Now however, it doesnt work, or rather it works when your editing old records, it changes the dates fine, but when you go to enter a new record in, you cannot use the calendar, it just makes the windows error sound at me. And i cant type the date in either, and i cant type into any of the other fields either, but i can edit the old ones fine....

Of course i can just go into the original table that the form runs off and type new data in there, but thats not the point, i need to be able to use this form. It worked before, but i opened it today and its screwed sideways, lol

any help from anyon would be great, dragon

PIC:
http://img381.imageshack.us/img381/8988/accesserror3oc.jpg

View 6 Replies View Related

Adding Data Through Form

Apr 26, 2006

I have a form, created from a query. The query contains and links about six tables using an AutoNumber ID. The query also has fields from each of these tables.

OK, so when users enter their data into this form, I would like the autoincremented number to increase in each of these tables. The catch is that when the user enters data, he/she does not have to enter data into every field. Therefore, not every table will contain information. But there will be times later on that some of that information will become available and will need to be placed on the appropriate spot (based on the ID number.)

So, some of my tables do not auto-increment and some do. How should I go about resolving this so that when someone enters new data, each table's ID is autoincremented no matter if that table contains information immediately or not? Please Help.:confused:

Thank you.

View 2 Replies View Related

Form Adding In A Field

Dec 1, 2006

Hi

Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:

View 1 Replies View Related

Form Adding In A Field

Dec 1, 2006

Hi

Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:

View 3 Replies View Related







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