Access 2010 - Main Menu Needs Drop Down Box Referencing A Table For SEARCH

May 6, 2014

I have a main menu "MainMenuF" in my database and I would like the database to be able to be searched by any of the column headings. For example I have a table titled "NewLabReportT" this table has many column headings like "Submitted By" "Reviewed By" "Title" "Abstract" etc...

I would like my users to be able to click a radio button with the same column headers on this main menu and have a box that pops up to say "Enter search parameter" and have that parameter be searched in the table "NewLabReportT" and generate a FORM not a REPORT of all of the listings in the database that have that keyword associated to that certain category searched. That way they can "CLICK" the exact field they are looking for and have it open right up to that form.

View Replies


ADVERTISEMENT

Access 2010 - Search Field On Main Menu?

May 7, 2014

Currently I have a basic database with the following

Table 1 = "EmployeeT" with fields "Employee_ID", "First_Name", "Last_Name" etc.
Table 2 = "NewLabReportT" with fields "Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract"

Form 1 = "MainMenuF" this is where I would like to have the search
Form 2 = "NewLabReportF" with fields "Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract"
Form 3 = "EmployeeF" with fields "Employee_ID", "First_Name", "Last_Name" etc.

Problem:I would like to have on the Main Menu a drop down list with all of the fields described in NewLaBReportF ("Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract") and then allow the user to click a button to the side of it to alert a pop up.

In this pop up:

If they originally clicked "Report_Id" then have the message prompt then to "Enter a Report ID"
If they originally clicked "Submitted_By" then have the message prompt them to "Enter an employees Last Name"
etc...

Further More, after they enter the respective value in this box, have a FORM not a REPORT generate that lists all of the records that match the criteria. This way then can specifically click on each record individually and have it open directly up to it.

View 14 Replies View Related

Modules & VBA :: Search Function With Drop Down Menu

Jan 5, 2015

I have a form with First name, Last name, Employee number, Information. The information box is a drop down menu with four options (contact, emergency, company, personal) I would like to be able to enter in search criteria for an employee using one of last name first name or employee number then choose an option from drop down box click a button to search and have it pull up just the info I needed.

I think I have two options but i am not sure which would be more efficient.

1. creating a query and using the criteria from design mode to have it filter the information. The only problem with this one is I do not know how to set it up with the drop down box from the form. Or would I need multiple querys for each option or just one with all of it?

2. writing code for the search button on the form that will bring up the appropriate query (I think I would then have to create a query for each drop down option)...

View 1 Replies View Related

Referencing Another Table Via Drop Down

Jan 11, 2007

Hi all,

have used the wizard to take values for a table dropdown field from another table

the table has

surname forename and class all of which reside in another table... ive tried to set up the bound columns so when you select a surname from the drop down the other two fileds also referencing that 6able are automatically filled in with their corresponding values.

so if the ref table had

smith john 1m

by selecting smith in the new tables drop down, the forename and class fields automatically select the corresponding values from the ref table..

im sure this is possible but cant get it to work and cant find anything on the web (although this is probably down to not knoing the right search string)

any ideas?

dubs

View 5 Replies View Related

Forms :: Referencing A Control On Access 2010 Navigation System

May 29, 2015

I have an Access 2010 Database frontend to SQL Server 2008 Backend. So far there are 3 Tabs in the Navigation System. The first one is the primary Data Entry form which has a tab control with 3 subforms.

Here's the problem. The database is designed to track potential members based on different types of Ads. The primary Data Entry form holds all of the demographic data for the person that called in response to an ad. The first tab has a subform to track how many times that person has contacted us. The second subform tracks which advertisements the person is contacting us about and the third tracks which Events that person attended. There is no correlation between contacts, Ads and Events.

On the Advertisements we have about 7 different types of Ads we do and each ad can be run multiple times on different days. We want to be able to track which Ad the person contacted us about. The Advertisement subform has a comgo box for the Ad type and a combo box for the ad date. the source for the combo box for the ad date includes the combobox for the adtype as the criteria. That criteria is what's giving me the problem. I've used:

forms!mainmenu!navigationsubform.form!potential_me mbers!frmAdvertisements!cboadvid

Along with every other variation I can think of. The form itself is frmAdvertisements but I'm using it in a tab control and I also tried:

forms!mainment!navigationsubform.form!potential_me mbers!adv!cboadvid

View 6 Replies View Related

Forms :: Access 2010 - Hide Menu On Startup?

Feb 4, 2015

Well, I made the move and am using Access 2010 now and I am running into a couple issues.

First off, I want to get rid of this menu on startup:

Not sure what it's called (ribbon, menu bar, etc). I am able to hide it using

DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

...in the OnLoad event, but this only works when running the opening form from the form list. When the form runs at startup the menus do not hide.

Also I would still like to have the file menu available because sometimes the user need to access the print menu to choose an alternate printer.

View 14 Replies View Related

Forms :: Right Click Menu In Popup Form On Access 2010?

Dec 11, 2013

I'm trying to do right click menu on listbox.

currently i'm trying to implement a right click menu which will show a simple messege box.

My problem is that the list box is on a pop up form which opened up maximized. Now when i'm right clicking on the list box i see the right click menu but when i'm clicking on one of the menu options, nothing happenning (it seems that it don't go to the function as it should). i've also putted breakpoints on the function but it never tips.

It's important to mention that if i'm setting the form popup option to no the right click menu works perfectly (when i'm clicking on one of the options i see its matching messege box).

I'm running the following vba code:

This is the mouse up event handler for my list box:

Private Sub Song_List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
' Call the SetUpContextMenu function to ensure it is setup with most current context
' Note: This really only needs to be setup once for this example since nothing is

[Code] .....

setting up the "SetUpContextMenu" sub:

Public Sub SetUpContextMenu()
' Note: This requires a reference to Microsoft Office Object Library
Dim combo As CommandBarControl
' Since it may have been defined in the past, it should be deleted,
' or if it has not been defined in the past, the error should be ignored

[code].....

View 3 Replies View Related

General :: How To Edit Access 2010 Default Shortcut Menu

Dec 10, 2014

I am building a db and i want to disable the Shortcut Menu (pull down menu at form's title bar) to prevent the users from closing the main form.

There is a Disable Shortcut menu setting in the File/Options menu but the whole db gets the setting.

I simply want to deny the users from accessing the Shortcut Menu when on the Main Menu (or a particular form) but allow it on other forms where Printing is required via the Shortcut Menu.

Im looking at 2 options; edit the shortcut menu or force a form to disable that w/o affecting other forms.

View 3 Replies View Related

Reports :: How To Customize Right Click Shortcut Menu In Access 2010

Mar 29, 2015

how to customize my right click "Short-cut" menu in Access 2010. I need a right click menu with ONLY the "Print" and "Print Preview" options for my reports and I would like to disable right click in all other objects.

View 3 Replies View Related

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

How Do I Fill A Drop Down Menu With Values Held In A Column In An Access Databse

Apr 18, 2005

Hi I have an access database called contact.mdb and I have linked to it just fine and used the records held in it to populate a datagrid and can update and delete records.

I don't understand databases that much but I would like to read the values into a drop down menu which are held in the field 'ID' from a table called 'courses'. I have a feeling it is something to do with data sets but am not too hot on these either. Any pointers or code would be gratefully received.

Thanx loads Lervy :d

View 3 Replies View Related

Queries :: Drop Down Access Standard Menu To Place Count Command

May 29, 2014

I have been using a table with queries with no problems. Now the queries wont recognize the last two records of the table when doing a Count. there are no null or empty spaces. I am using the drop down access standard menu to place the "Count" command. Is there a solution to this problem ?

View 3 Replies View Related

Access 2010 - Send Reports In PDF Straight To A Folder In Drop Box

Jan 22, 2014

I would like to be able to send reports in PDF straight to a folder in Drop box with the click of a button.

View 1 Replies View Related

Forms :: Referencing Text From Drop Down Via ID Number

Jul 8, 2014

I know this is simple, but I feel like Simple Jack this morning. I'm trying to take the text from a drop-down menu and use that as part of the form caption. However, the text is not what is bound, the ID number is.

View 4 Replies View Related

Creating A Dynamic Search Box In Access 2010?

Nov 24, 2011

I am using access 2010 and am trying to create a dynamic search like the one google uses, it will feature a drop down that will populate with results but when its not in use the drop down is not shown.

I'm looking to add a menu system to the form its self so that the users will be able to do certain functions. third image is what I'm looking to create with the menu bar at the top of the screen.

[URL]

View 1 Replies View Related

General :: Access 2010 - Search Key Was Not Found In Any Record

Dec 10, 2014

I have a split database with several attachment fields that work fine.

When I try to create a new attachment field in the BE, upon opening the FE, I get the following error: "The search key was not found in any record."

I have tried several ways: first create the attachment entry in the BE, then I can't open the FE. Create it first in the FE, leave it unbound and then create it in the BE - same error.

View 1 Replies View Related

Modules & VBA :: Access 2010 - File Search In Specified Locations

Feb 28, 2014

Previously in Excel / Access 97 / 2003 I made a little tool that would search for files in specified locations - I modified the code so that it would search for files based on what was entered in cells.

I believe a lot of the old code doesn't work in Access 2010 and it seems like a lot of the old file searching code I used to use no longer works.

Is there code available that searches a directory and lists results?

View 1 Replies View Related

Database With A Main Menu Form Containing A Button That Loads Main Data Entry Form

Jun 24, 2015

I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)

View 5 Replies View Related

Forms :: Referencing A Subform From Main Form

Jun 24, 2015

I have a form and subform with the following names:

frmBasic
sfrmCustomers

I have a unbound txt field called txtCustName on the mainform
I want to populate this field from a field on the subform called CustName when the record is selected.

I also have an unbound combo box with the cust ids using the row source from the tables record source from the main form.

I tried the following Code:

Private Sub cboCustNum_AfterUpdate()
Me.Filter = "[Cust_ID]=" & cboCustNum
Me.FilterOn = True

Me.txtCustName = Forms.frmBasic.sfrmCustomers.Form.CustName
End Sub

This didn't work. So I put "= [Forms].[frmBasic].[sfrmCustomers].Form.[CustName]" in the control source of the text box on the main form I want populated.

The name doesn't appear in the field. I get #Name? in the field.

View 4 Replies View Related

Modules & VBA :: DMax On Main Form Referencing Subform

May 2, 2015

I have a form - purchase, and a subform purchase detail they are linked with a field "puid"..I need the dmax to give me the maximum auto number field "pdid" on the subform in a textbox on the mainform.

I used the control source code:

=DMax("[forms]![purchase]![purchasedetailds]![pdID]","[forms]![purchase]![purchasedetailds]","[Forms]![purchse]![purchasedetailds]![puid]=" & [Forms]![purchase]![puid])

and the simpler:
=DMax("purchasedetailds]![pdID]","[purchasedetailds]","[purchasedetailds]![puid]=" &[puid])

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

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







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