General :: Playing MP3 Files From Command Button On A Form

Apr 3, 2013

Beginner using 2010. I wish to play MP3 files from a command button on a form. I would like to avoid third party / ActiveX controls if possible.

I am aware that use of "CurrentProject.Path" will be useful to locate the MP3 file within a directory within the Project Folder.

But have be baffled by the sparse previous postings about this subject (going back to 2004). Searching this forum yields zero results on the term "MP3".

This accdb/e will be used to present historical information to a small number of people and will be used with runtime without user input.

And all I need is Play / Pause / Stop. No other functions required.

View Replies


ADVERTISEMENT

Playing Mp3 Files From A Form

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

Command Button In Form To Open Certain Files

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

General :: Command Button To Insert Picture In Form

Nov 17, 2012

In form I want to put a command where we can browse a picture and insert it...how to do ...

View 5 Replies View Related

General :: Command Button To Email Report From Form?

Jan 30, 2014

I have a form that records data entered by a user who I then want to email the record via a report run from a query.

I created a command button on the form with DoCmd.SendObject acSendReport,"name_of_report", "format", "to","subject", False

The email program (Lotus Notes) opens a new email msg with the report attached as pdf. However, the data recorded does not appear.

View 5 Replies View Related

General :: Using Command Button To Save New Record

Dec 7, 2012

I have have a form with 4 subforms in it, one of the subforms is based on a filtered query . For a reason I can not work out I cannot get it to requery when I add a new record.

To add a new record I select from a combo box and use a command button to save the record

I have tried using this in the buttons on click event

Code:
Forms.trialcatalogueF!TrialCompetitorsSF!competitorsSF.Form.Requery

with no result, however it does kinda work in the combo's after update event, just not until I select another value.

View 2 Replies View Related

General :: Opening Excel With A Command Button?

Jul 12, 2013

I am trying to open MX Excel using a command button. I have tried using a hyperlink a various codes that i have found online with no luck. The Excel file is being used by the Access as it bring data from the spreadsheet a displays it within a subform. (I think this is where the problem occurs) The subform displaying some data from Excel is working fine but when i click my hyperlinked button i am met with errors and the file will not open.

View 6 Replies View Related

General :: Command Button Enable Or Disable

Jul 27, 2012

I have a form. and it has three buttons. Such as Submit, Reject, Under Observation.

I want :
1) If i click SUBMIT button it will be disable and other two buttons REJECT and UNDER OBSERVATION will be enable
2) If i click REJECT button it will be disable and other two buttons SUBMIT and UNDER OBSERVATION will be enable
3) If i click UNDER OBSERVATION button it will be disable and other two buttons SUBMIT and REJECT will be enable

View 1 Replies View Related

General :: How To Add Keyboard Shortcut To Button Command

May 8, 2013

I am using access 2010 and I created couple of buttons on my forms that do some stuff in vba, but beside triger them with mouse I would also like my users to be able to have shortcuts on keyboard so for example I have btnClose an I widh when user press ALT + that btnClose do the same thing as it is doing when you press mouse on it.

View 4 Replies View Related

General :: Command Button Stays Active

Feb 17, 2014

I have a macro that Runs from a button that I attached to a form called " plans" the macro opens up a Dialog form from which I select a drawing number from, on selection of that drawing number a query is run and finds the information I want

The problem I am having is when I close the query the macro button goes active so if I want to run another query using the button it goes to the last record I selected. I have tried the refresh command but that does not work..I really need the button not to be active when the query is closed.

View 3 Replies View Related

General :: Open MX Excel Using A Command Button

Jan 15, 2014

I am trying to open MX Excel using a command button. I have tried using a hyperlink and various codes that i have found online with no luck. The Excel file is being used by Access as it bring data from the spreadsheet and displays it within a subform. (I think this is where the problem occurs) The subform displaying some data from Excel is working fine but when i click my hyperlinked button (To open the excel file) i am met with errors and the file will not open.

View 1 Replies View Related

General :: Sending Text Via Command Button To Email

Mar 19, 2014

After inputting data into a text box on a form i want to click on a command button which will open an email program and then put the text there so i can send it.

View 1 Replies View Related

General :: Command Button To Insert Records From One Table To Another

Aug 11, 2013

I have two tables, one is GENETIC and the other one is BoneSampleDNAprofile. Both tables have the field CY-Code. I want to create small form with 2 text box fields and one command button on the form to be able to insert CY-Code from the table GENETIC to designated DNA_LAB_Code in the table BoneSampleDNAprofile.

In that small form I would type DNA_LAB_Code and CY-Code where after pressing command button will insert CY-Code for the designated DNA_LAB_Code. This is continuous process after our Laboratory receive results from DNA laboratory. I have attached two .png files which are example of two tables.

View 2 Replies View Related

General :: Command Button Not Working In ACCDE File

Oct 19, 2014

I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working.

View 7 Replies View Related

General :: Opening Specific Invoice From Command Button

Jul 20, 2014

How to modify an existing database template to meet my needs.

I am trying to create a command button that sits on the order details page and that will open up a report i have created called 'picklist' which is basically the same as an invoice but with some different product information listed on it.

I want the command button to open up the picklist that corresponds to the order that i am on e.g picklist #2 for invoice#2

I have 2 issues/questions:

1) I have seen this code on the internet -

DoCmd.OpenForm "SecondFormName", , , "FieldName = #" & Me.ControlName & "#"

Would this work for me if i was to modidy it to:

DoCmd.OpenForm "PickList", , , "InvoiceID = #" & Me.[txtID] & "#"

2) Where do i input this code? If i click on the 'onclick' in the properties form I am presented with this page (attachment):

View 8 Replies View Related

General :: Scheduling Meeting Appointment Through Access Command Button

Mar 20, 2014

I am trying to create a command button in Access to generate a Meeting Invite. I found code for creating an Appointment and it works great but cannot get it to invite attendees.

Private Sub AddAppt_Click()
On Error GoTo AddAppt_Err
' Save record first to be sure required fields are filled.

[Code].....

View 1 Replies View Related

General :: Database To Record Payments - Multi Task Command Button

Apr 7, 2014

I am creating a small database to record payments.

There are three tables :

Supplier - tblSupplier
Payments - tblPayments
Invoice - tblInvoice

There are two Forms :

frmPayments (Bound to tblPayments) - Main Form for payment entry.
frmInvoice Sub (Bound to tblInvoice) - Sub form to display not paid invoices.

What i need is a Command button , lets named it "Commit", to perform a few tasks :

1. When click, prompt message asking whether to Save current payment record when all relevant input is completed during data entry.

2. If Answer is "Yes", then it will compare the "Invoice No" on the Main Form with the "Invoice No" of the Sub

Form , and if found to match, then put a tick in the "Yes/No" field of Invoice Table (tblInvoice) against the matching "Invoice No" of Main Form. This is to record payments made to this particular Invoice in Invoice Table.

3. Proceed to save current record, Refresh Main Form to be ready for a new data entry.

4.If Answer is "No", discard all current entries in the Main Form, Refresh to be ready for a new data entry.

Sample DB is attached...

View 1 Replies View Related

Form With Command Button

Jul 21, 2006

Hi,

I created a form that lets the user choose specific criteria, through a combo box, to run a report that houses several subreports. Each combo box is referencing 4 queries needed to run the report.

=[Acctmgr_renewed_detail]![RenewalMonth] And [Acctmgr_begbal_2005]![RenewalMonth] And [Acctmgr_cancelled_sum]![RenewalMonth] And [Acctmgr_renewed_sum]![RenewalMonth]

The form also includes a command button to preview the report. However, when I click the command button, the prompts for parameter values for the report popup again, when it should just print the report. Below is the code attached to my command button:

Private Sub Command2_Click()
Me.Visible = False
DoCmd.OpenReport "Acctmgr_monthly_activity", acViewPreview
DoCmd.Close acForm, "valarie"
End Sub

Is there something I need to add to my code? If so, what? Any help would be much appreciated.

Thanks

View 1 Replies View Related

Command Button And Form

Sep 16, 2006

this will sound easy....i want to create a command button that opens a specific record in a form....how do i accomplish that.

View 7 Replies View Related

Command Button On Form

Dec 18, 2006

Hi everyone,
I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks

View 2 Replies View Related

Form And Command Button

Feb 18, 2007

Hi
I have a form(mainform) that shows the surname of a customer plus order details etc.

On that form(mainform) i have button that is called customer details

I have a form2(customer Details) which shows address phone number etc of customer

I want to be able to click the button on mainform, and see the details for the current customer.

I have tried using a macro for this but it always shows the first customer details of the customer table.

How do i get the Form2 (customer details ) to show the current customers details.

I hope i have explained ths simply enough.

View 1 Replies View Related

Command Button In Datasheet Form ?

Feb 10, 2005

In one of my forms (which is a datasheet) I want to create a hyperlink or a command button (in each row), which enables the user to jump to another form (determined by the cell contents).

I have achieved that by replacing my datasheet with a continuous form and adding a command button. But I would much rather keep my datasheet format.

I tried to put a command button into the datasheet, but it won't display it.

Is it possible to achieve my objective here ? I am not having much joy with HELP.

NoVoiceLeft

View 4 Replies View Related

Filter Command Button On A Form

Dec 12, 2005

I have a basic question.

I am trying to put a button on a form I have created so that I can use Filter by Form feature on it. I used the toolbox commnad button wizard and chose the Form Operations -> Apply Form Filter option for the button.

Unfortunately, this button does not work for this choice. In the Form view, if I click on this button nothing happens. Other choices in the wizard such as Edit Form Filter etc works.

Does anyone know what could be the problem? Is this an Access bug (i am using Access 2003).

If it is a bug, can anyone suggest what little modifications one might have to do to the VBA code underlying OnClick event for the button to make this command button work?

thanks a lot for the help

View 1 Replies View Related

Command Button In Form To Run A Querry

Dec 24, 2005

In a form of my "cities-of-the-world" database I have amongst others the fields: "Latitude" & "Longitude"
Now I'm looking for the command button code that runs a querry to find all neighbouring places i.e. [Latitude] would be 'Between (Latitude + 0.75) and (Latitude - 0.75)' ... longitude likewise.
In other words: When the form displays the record for Berlin, on clicking the command button there should appear a list containing the cities: Bernau, Oranienburg, Potsdam ...

View 1 Replies View Related

Possible To Filter By Form Using A Command Button?

Mar 6, 2006

Hi, I'm an Access newbie. I've designed a fairly simple database to replace an old spreadsheet that was becoming unwieldy -- it was never really used so much for calculation as for data storage, so Access seems more appropriate anyway.

One of the functions I used in Excel was the autofilter, which I found very useful for zeroing in on specific portions of the data. I was wondering how I would do the same thing in Access, and then I discovered the "Filter by Form", which works just fine -- even better actually, since it has the whole and/or functionality.

I was wondering though if it would be possible to invoke "Filter by Form" using a command button. That would make it even easier, especially for some of my users who would almost certainly not know about "Filter by Form" otherwise.

View 14 Replies View Related

Command Button To Open A PDF Form.

Apr 7, 2008

Dear All:

Does anyone know how to use a command button to open a Pdf form in access?

This Pdf form is on the "c" drive called "portfolio".

Thanking in advance,

Dion

View 14 Replies View Related







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