Accessing PDF Files After Drop Down Menu Selection

Aug 27, 2012

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

View Replies

Drop Down Menu Inside Drop Down Menu

May 15, 2006

Ok, This is something I have long wanted to do, but cannot figure out.

I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.

What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.

I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.

Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.

Thanks in Advance!

:)

View 2 Replies View Related

Accessing Filter Menu With Command Button

Dec 26, 2013

How could I activate filter menu with a command button. The filter menu I am referring to is the one on the home tab.

View 1 Replies View Related

MP3 Files In Access DB: Accessing In ASP

Apr 12, 2006

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]<%=RS("Tunename")%> 
<embed src= "<%=RS("MUSIC")%>"
width="252" height="36"></embed>

where Music is the name of the cell containing the MP3 file.

This gave me:
[code]mytune   
<embed src= "?$" width="252" height="36"></embed>

Any ideas what I need to do to get this to play?

View 2 Replies View Related

Accessing Linked Files

Jun 19, 2012

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?

View 1 Replies View Related

Computer Hangs Accessing Network Database Files

Oct 6, 2004

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?

View 2 Replies View Related

Drop Down Menu Help

Feb 22, 2005

Hi there.

I work for an Internet Marketing company and my boss wants me to design a huge huge form in Access - requiring alot of Drop Down Menus. Alot of them are simply Yes/No questions, some, however, are not.

This is what I have done so far:

I have a field called Sector which I have selected as a Yes/No Field.

In the Form Design View I have selected:

Row Source Type = Field List
Row Source = Sector (this is a separate table in which I have put all the options)

In Format, instead of Yes/No, I have changed it to "-" - this is simply because when I view it Normal View the first thing in the Drop Down Menu is a Yes or a No.

This all seems to work fine until I try to select one of the options and I get this error:

"The Value you entered isn't valid for this field - For example, you may have entered text in a numeric field or a number that is larger than the FieldSize settings permit"

I have gone back and forth into the Design View on the Form and the Table trying different things, but nothing I do seems to work.

I don't even know if I have gone about doing this Drop Down menu in the correct way to begin with.

I'm not an Access Expert so please if anyone has any ideas please let me know. It'll be much appreciated :)

Thankyou.

View 5 Replies View Related

Drop Down Menu

May 17, 2006

I have a database designed on court bookings in a racquet centre. On the court booking form i have a drop down menu of the courts and i want it so that when you click the "book" button at the bottom it removes the selected court from the list so you cant book it twice, any ideas?

View 7 Replies View Related

Drop Down Menu Help

May 30, 2006

i really need help inputing values into my drop down menu. unfortunately i don't know how to do it. i have created the drop down menu, but with no values.

please help
chocho

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

Drop Down Menu In Datasheet

Jun 16, 2006

Hi guys

I am new to access and am finding it difficult to do some simple things.

I need to know how I can set the properties of some of the fields in a datasheet so when clicked on a drop down menu appears.

I have an add record form where on one field the user can select a number of options from a drop down menu and this is then added to the table, however on one of the following forms I have a datasheet in a subform that is set to allow edits. I want a drop down menu to appear when the user selects the field that also had a drop down menu on the add record form.

any ideas on how this can be done would be greatly appreciated lads?

cheers

View 5 Replies View Related

Drop-down Menu Query?

Sep 20, 2005

Hey guys,
Is it possible to create a drop-down menu Query, as opposed to the basic Parameter Query where the condition is typed in a dialog box? Just thinking it would be easier for the user in that it would eliminate mistakes due to spelling errors. Would it be possible?

View 4 Replies View Related

Drop Down Menu's In Query's

Oct 24, 2005

I'm a new access user and surrounded by 3 1000 page access books and I can't seem to find the answer to this seemingly simple question. I really have tried.

I have a query that prompts the user for specific criteria. How do I make this query prompt a drop down menu rather than just free text, where the user is forced to know and enter exactly what their options are for the criteria.

any help is much appreciated. Thanks in advance!

View 2 Replies View Related

Query With Drop Menu

Sep 6, 2006

Hello !

I am trying to build a query where you would select condition from drop menu. Is it possible at all ? Maybe in SQL ? :confused:
So far I have used this form [Choose proejct:] in condition. Can be this changed with above mentioned WISH ! :o

THNX !

Klopo

View 1 Replies View Related

Drop Down Menu Limit

Nov 8, 2004

Please have a look at the screenshot file below before u start reading this.

what i want to do is limit the "Cost Type" drop down list.

The limit on drop down is initiated by Placement Type

So if you selected Placement Type = "Consultant", the "Cost Type" should be limited to the following
1) Consultant Wages X 14%
2) Consultant Wages X 4.5%
3) Consultant Wages

and therefore if you select "Other "on the Placement Type drop down, Cost Type dropdown should only show Sign on Bonus and other

i hope this makes sense.
thanks much in advance.

View 5 Replies View Related

Drop Down Menu Query Problem

Sep 5, 2005

Hi,
I have a drop down menu that is linked to a query

it goes

*table1* *Table 2(linked via area)*
Company no+Company name+Area+Zone+Roundtrip distance

Now the field that it stores is the company number (we deliver to the same company in differant area, so I cant use the company as the primary field sadly) and as such if you want to quickly enter the data to get the drop down menu to show the records to select, then you have to enter the company number.
I was wondering is there a way to start typing the company name, and have the drop down menu show all the entries of that company, but to have it still store the company number when I select a record from the menu?

View 2 Replies View Related

Month & Year Drop Down Menu?

Mar 13, 2006

I have a field that is:

Current length of continuous allocation of Care Co-ordinator. ( years and months )

Ideally I would like to have two drop down menus - one with years and one with months.

Would I have to have two fields in my table - one for years and one for months or can I have one?

Whats the best way?

Thanks.

View 3 Replies View Related

Removing Particular Data From Drop Down Menu

Mar 23, 2006

Hi
New to the boards.
The database i have created needs data removing from it when certain criteria arent met. Basically, when the form is filled in and the person is under 25 i need one range of data to be removed from another table leaving the ranges available to that person. how would i initiate this?
any pointers or links to where i can find this out (anything, i am desperate!!! :) ) would be appreciated

Thanks

View 1 Replies View Related

Open A Form From Drop Down Menu

Nov 15, 2006

I have an MS Access problem I need some help with. I am trying open a form for input from selection in a drop down menu in an access database. Any ideas on how I should do this??:confused:

View 3 Replies View Related

Enabling Drop Down Menu On Combo Box

Jan 26, 2005

Hi all,

This is a simple question i think, but how do i enable my drop down menu to work for a combo box. I have a search query bound to a form and the combo box bound to a field of that query. At present my query just display the first record for any search result from my query on the combo box.

Thanks in advance,

M-.

View 10 Replies View Related

Queries :: Drop Down Menu In A Parameter Box?

May 15, 2013

Co-worker asked me if there was a way to add a drop down selection menu to a parameter box. Seems like ACCESS can do a lot of neat things.

View 14 Replies View Related

Forms :: Drop Down Menu In Order

Aug 6, 2015

1. I have a drop down menu with numbers 1 thru 15

How do I have the drop down menu go 1,2,3,4, etc.

Right now it goes 1,10,11,12,13,14,15,2

Also I have two fields where the user enters money

2. How do I set up the form so when the user types in 430 it is 430,000.00 and not 430.00

View 1 Replies View Related

Creating New Ribbon With Drop Down Menu?

Jun 2, 2014

How I can create my own Ribbon which include drop down menus?

View 3 Replies View Related

Drop Down Menu In Alphabetical Order?

Mar 14, 2015

Just starting off with access. Is there anyway of getting fields in a drop down menu to be displayed in alphabetical order?

View 1 Replies View Related

Creating Drop Down Menu In A Form

Aug 6, 2015

In the Lesson 22 tutorial presented here: [URL] .....

They create form where the called Countries toward the end where:

The have a textbox for Government Type. It is a drop down menu of choices that the database creator can choose such a capitalist, socialist, and communist etc.

However, in the form (with the records source as Countries) there is only a space for input no drop down menu. I know this may seem awful elementary to the seasoned database designer, but how does one get it to be a drop down menu?

I have made the input in Countries table to be a look-up which I typed (see above choices) and the is the control source for the Countries Form government type. But there is still no drop down menu with choices on the Countries form. What must I do additionally?

If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that source is all that is needed.

View 4 Replies View Related

Reports/query By User From Drop Down Menu

Mar 16, 2005

I have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for.

How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory!

Thanks in advance!

Regards

Peter

View 2 Replies View Related