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).
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.
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]<p><%=RS("Tunename")%> <br> <embed src= "<%=RS("MUSIC")%>" width="252" height="36"></embed></p>
where Music is the name of the cell containing the MP3 file.
This gave me: [code]<p>mytune <br> <embed src= "?$" width="252" height="36"></embed></p>
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?
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?
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 :)
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?
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.
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"
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?
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?
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.
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
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
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?
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
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:
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.
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.
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!
