Forms :: Multiple Comboboxes Using Same Source Data But Requiring Unique Input

Mar 27, 2013

I tried and failed to get this to work using a multiselect listbox..I have a list of departments in tblFunctionalArea...My main table is tblStatic..I want to be able to for each record select multiple departments affected by a record and store them in the tblStatic.After looking around i couldn't find many people successfully maanging to store listbox values in a table...

I decided to create 5 fields in tblStatic and in my form create multiple combo boxes cboFunctionalArea1, cboFunctionalArea2 etc etc which are bound to these fields.I want to be able to ensure the list for any combo box requeries and takes out any selection in the other boxes.

I have this working in a strict cascade fashion i.e. in cbo1 all dept's visible, in cbo2 it takes off whatever was selected in cbo1 etc. But if someone then jumps back and deletes the content of cbo3 then the whole thing breaks or if they amend in the wrong order it breaks

View Replies


ADVERTISEMENT

Forms :: Cascading Comboboxes Changes Row Source

Nov 6, 2013

I want to know is it possible to have a combobox change the row source of another combobox with vba code or some other way.

View 3 Replies View Related

Forms :: Input Data Into Multiple Tables Using Single Form - MS Access 2013

Jan 15, 2015

I have 5 tables that I would like to input data in. It can only be done with a single form. The fields I want to input in have the same names in all 5 tables, for example:

Table 1:
Name
Age
DOB

Table 2:
Name
Age
DOB

Table 3:
Name
Age
DOB

Table 4:
Name
Age
DOB

Table 5:
Name
Age
DOB

Is it possible to input data into all of these fields in each table using one textbox for each field?

Preferably without having to use code but if it cannot be done without it then that would be fine.

View 7 Replies View Related

Forms :: Filter Multiple Criteria - Unique Identifier

Jun 20, 2014

I have a large table with information about different cars, called "Car Metadata". In this, each car has a unique identifier ("Car Code"), the make ("Manufacturer Name") and the model ("Short Model").

What I want to do is create a form with dropdown menus.I have a first combo box with all the makes in the Metadata table.

What I am having trouble with is that I want a second combo box underneath which would only show the models which correspond to the make selected in the first box.E.g. someone could select Ford in the top box and the second box would only show Fiesta, Focus etc.

Once it has done that I want it to be able to write the Car Codes for the records which match up to the make & model selected to a new table. Just to complicate things further, there can be multiple records with the same make and model but different Codes, I want all these multiple codes to be written to the final table.

View 4 Replies View Related

Forms Record Source For Multiple Queries

Sep 21, 2004

Currently I have over 600 columns I need to use in a query and since the limit is 255 columns per query, I need to create multiple queries. Currently the form shows the record source of the single query I have created. Now that I need to create the other queries, how do I have the forms record source to recognize the other queries as sources as well?

Thanks,

JGM
onesweetdude@hotmail.com

View 1 Replies View Related

Data Input Form From Multiple Tables

Nov 4, 2004

Hi, I have a big problem. Here is the business rule, I am trying to track meeging request(MR) made. A meeting request is made by a manager,MR can include many analysts, and MR involves 1 project. I need to generate several reports from the MR information so I am trying to make sure the info is inputed correctly. I am trying to creat an input form for the MR table (tblMR) The input form is going to contain all the fields from the tblMR except the manager_ID and and the Project_ID, I am also going to have it track which analysts attended the meeting(1 or more). The problem I am having is in creating the form but having the analyst, manager, project values come from their own tables but after selecting them through combo box or list box, for values of Manager_ID and Project_ID to be entered in the tblMR. And for the analyst involved to be stored in a a composit table called tblMR-Analyst. this table will help me track how many meeting each analyst has been to. Any suggestions will help.

View 2 Replies View Related

Forms :: Using Multiple Calendar Controls With Same Control Source?

Feb 26, 2014

On the form I need to give the user the option to select a 'from date' and 'to date' and for this I have put in 2 calender controls which have the same control source(same table column). The problem I am facing is when I select a date from one calendar, the other calendar control automatically populates with the same date and vice versa.

I need to have a functionality where 2 different date can be selected and then when the Search button is clicked, then data within the date ranges should be displayed.

what changes I need to make to acomplish this ? find a screenshot of the form attached.

View 5 Replies View Related

Filter By Multiple Comboboxes

Dec 4, 2006

Hi,
I have a form with a subform on it. Also contained on the form are 5 comboboxes that are listing the entries in each table.

What i would like to be able to do it select an entry in any of the comboboxes and that will in turn filter the subform on the selections made whilst also filtering the remainder comboboxes based on a selection made.

I can get it to work by filtering one at a time with this code bound to each combobox:

Private Sub cmbAisle_AfterUpdate()
Me.qryAllData_subform.Form.Filter = "[Aisle]='" & Me.[cmbAisle] & "'"
Me.qryAllData_subform.Form.FilterOn = True
End Sub

But each time i select an entry in another combobox it re-filters on that selection.

Any Help would be much appreciated.

Dazz

View 1 Replies View Related

Forms :: Input Multiple Records At Once

May 22, 2014

A little bit of context first: I am producing a database to store information on overhead line structure renewals.

I have a table called tblStrucTasks with four fields; Task ID, Structure Type, Create (specifies whether the structure is to be created or removed) and Task. I need to enter multiple records which will have the same Structure Type and Create fields but different Task fields. There are many tasks for each structure so I'd like a form where you only have to select the Structure Type and Create fields once. Some sort of list where the tasks could be typed in would then be perfect.

I'm not sure whether this should be done with VBA or queries. I'm new to databases so I don't know a lot about queries but I have a little bit of experience with VBA from Excel.

View 2 Replies View Related

Forms :: How To Ensure Unique Data Across 2 Fields

Dec 17, 2014

What is considered the right approach to ensure a record entered in a form is unique. For example if i have a field:

Brands. Flavour
Walker. Ready salted
Smiths. Cheese and onion
Doritos. Ready salted
Walker. Ready salted

So what is the best way to ensure the third entry is fine as whilst ready salted already exists it doesnt exist for doritos but the fourth entry would pull up a msgbox refusing the entry as it is a repeat of entry one.

View 2 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Forms :: Multiple Record Input At Same Time In Form

Sep 15, 2013

We store data for clients which can be found online. Our current method of getting the data so we can analyze it is to copy a table found online and pasting it into excel.

What we want to do is to copy that data into an access table. This equates to inputting multiple records at the same time. There are 5 columns and around 20 rows (records) pasted at the same time. I want to do this in Access, through a form which would them store that data in the appropriate table.

I assume there is an ActiveX control out there which can put a spreadsheet in an access form. Then i could maybe write a VBA procedure to input the data into a table.

View 3 Replies View Related

Reports :: Filter Multiple Fields In A Report Using Comboboxes In A Form?

Jul 24, 2015

I have a report based on a query that I put inside a form. What I want to do is create 4 comboboxes from which users can choose options that will filter the report without leaving the form or opening the report in a separate window. Also, I want to make the filters dependent on each other, meaning if a select option A on combobox 1, the options i will select on combobox 2 will only be based on the earlier filter on combobox 1 ...

So far I'm able to do at least 2 of the comboboxes to filter the report, but they aren't based on which one was used to filter the report first. So if i filter the records by choosing option A on combobox 1, combobox 2 will still filter every record.

here's my 2 codes so far:

Private Sub cboLocation_AfterUpdate()
On Error GoTo Proc_Error
If IsNull(Me.cboLocation) Then
Me.qrySalesByLocation.Report.Filter = ""
Me.qrySalesByLocation.Report.FilterOn = False
Me.qrySalesByLocation.Report.Requery

[code]....

the other 2 comboboxes, I can't apply the same code cause the enter parameter dialog keeps popping out.

View 3 Replies View Related

Forms :: Subform With Date Picker To Input Multiple Dates

May 14, 2013

On my main form, I have a subform to input multiple dates, using date picker.

I also have a text box on the main form to input single dates, again using Date Picker.

On entering both the single date text box and the subform, I don't want the (default) date to be visible. I only want the date to be visible once I have selected a date from the Date Picker.

I have figured out how to do this with the single date text box. I have simply defaulted the forecolor to be white so that you can't see the font against the white backcolor. Then on the Change Event, I set the forecolor to be black. Works like a charm.

However... This same approach will not work with the subform. I've tried playing around with a bunch of different events, but so far nothing allows me to re-create what I am able to do with the single date text box on the main form.

View 2 Replies View Related

Forms :: Creating User Record - Input Multiple Tables From Form

Mar 28, 2015

I am building a form to create a user record and at the same time i have some yes/no options which are located in other tables but when i want add a user i cannot select any yes/no options they seem locked?

View 1 Replies View Related

Forms :: Permit Only 50 Group Leaders To Input / Edit Data On Password Protected Forms

Jul 29, 2015

I am building a very comprehensive Membership Management Database with extremely useful facilities initiated by some 20 or 25 Queries..

The database includes 5 Tables which store data relevant to members, another which stores details of Interest Groups and a 3rd which stores which members are affiliated to which Group or Groups.

Currently the database is accessible only by a very limited number of persons and data can be entered/edited by only one person. The database, using Access 2010, is maintained on a desktop computer and synchronized to a copy on a Cloud.

My requirement is to permit some 50 Group Leaders to input/edit data on a Password protected Group Members Form such that that is the only element of the database that they can access. The Forms would have only 2 fields from which the user would select entries from drop down lists.

My query is ; is such a procedure feasible in principle and would I be correct in assuming that the user would require to have available a copy of Access.

View 7 Replies View Related

Forms - Adding Query As Data Source In Existing Form?

Dec 2, 2012

I am trying to add a query in an existing form. When I click on adding a field, I get an option to show "all tables" for not queries.

View 3 Replies View Related

Queries :: Direct Input To A Field Which Is Defined Source From Query

Sep 4, 2013

I got a field which is defnined based on a query result to ease the user input. However, some input are not in the query list, if I input data directly to the field, ACCESS complained I must choose item from the query result. Is there any way that the user can either select from query result or direct input to that single field?

View 1 Replies View Related

Forms :: Sort Of Limit On Number Of Columns Contained In Data Source For Such A Box?

Jul 14, 2014

I have a form I created in the past that auto-fills some of its fields based on the user's selection of a record from a combo box linked to another table. The form has been working perfectly however I recently tried to add a couple of more fields to the form that need to be autofilled. I added the new fields to the source table and added columns to the combobox that should allow my VB code to fill those boxes. However only one of the new fields is filling correctly. After trying a few different things I notice that the problem seems to be with whatever data field becomes the 21st column in the combobox. Is there some sort of limit on the number of columns contained in the data source for such a box?

Option Compare Database
Private Sub EmpIDAutofill_Change()
Me.EmployerCatAutofill.Value = Me.EmpIDAutofill.Column(1)
Me.StreetNumAutofill.Value = Me.EmpIDAutofill.Column(2)
Me.JobCityAutofill.Value = Me.EmpIDAutofill.Column(3)

[code]...

View 3 Replies View Related

Forms :: Textbox Control Source - Pull Data To Display On Summary Tab

Oct 16, 2014

I have a form, with a tab control on it. Each tab has a subform to display data. One tab is meant to be a summary tab of the rest, so I want to pull data from certain controls on each of the other tabs to display on the Summary tab.

If I set the ControlSource to Forms!subfrmLABOUR!txtTotalHours.Value the control just displays #Name?

I assume that means it can't reference the ControlSource. Is it just a syntax thing? I've tried various methods, but no luck.

View 6 Replies View Related

Using Comboboxes To Spellcheck And Protect Bad Data?

Jun 11, 2006

I'm trying to make my database easy as possible for everyone to use while protecting against potential typos and the likes. I then had an idea and wanted to make sure if that was in line with accepted practices everywhere else. After all, just because you can do it, doesn't mean you should.

Would it be reasonable to have fields that would likely to have repeating data across various records to be a comboboxes. The fields I'm thinking of are City and ZIP code, which I would start with some more common ones, and allow users to add new ones while having the benefit of auto-expand as spell checker and reduce possiblity for bad data.

I'm not sure what ramifications that may have on forms beyond the fact that more lookup tables=slower database, especially over the network.

So would you want to make city or zip code or other similar fields combobox instead of a bound textbox?

View 4 Replies View Related

Modules & VBA :: Data Validation With Comboboxes

Jan 23, 2015

I have 2 combo boxes on a form. The 2nd box is not visible unless the 1st box is set to a specific value (Illness). Once the specific value is set, the 2nd box appears with appropriate data for selection.

Goal #1:
I would like to have the form checked before it is closed to ensure that if the condition in box 1 is "Illness" then the 2nd box must have a value and can not be null.

Goal #2:
I am also having problems with the 2nd combo being visible when form opens or becomes current. The field is set to visible=false normally but needs to be visible when form opens if the conditions mentioned above are meet (true).

Private Sub Form_Unload()
If IsNull(Me.Incident_Classification) Then
MsgBox "Please select a type of Illness"
Me.Incident_Classification.SetFocus

]Code] .....

View 3 Replies View Related

Forms :: User To Input Data Into One Box Or Another Not Both?

Mar 10, 2013

I have a form, and on the form there is a Provider Rate which is a combo box, if the user select a zero rate, then it has the description please enter manual rate in box below. There is another box which the user can enter a manual rate.

how I can limit entry into these boxes, as currently a user can select a rate in the provider rate box and still enter something into the manual rate box. I want it so that if a rate other than zero has been selected in the provider rate box, then they can't enter anything into the manual rate cell.

View 9 Replies View Related

Forms :: Using Form To Input Data?

Oct 29, 2014

I am having to develop a form that we can use in case in our web based inventory systems crash. I am not good with forms at all.

I'd like the data entered to go into a table I've created with 4 fields.

So Field1 and Field2 will stay constant until we hit a button that does a whole new person we are issuing equipment to.

Field 3 and 4 though will need to generate a new record each time we scan data into both those fields.

For example the data table would look like this

Field 1 Field 2 Field 3 Field 4

Person1 IDNumber SerialA SerialB
Person1 IDNumber SerialC SerialD
Person1 IDNumber SerialE SerialF
PERSON2 TheirID SerialG SerialH
Person2 TheirID SeriaiI SerialJ

If it makes a difference this form will be done in Access 2010. Once I get the data into the table, I can do whatever I need to do with it.

View 1 Replies View Related

Forms :: Form That Shows 100 Records At A Time - Filter / Sort Data Source Entirely

Oct 20, 2014

The recordsource is a query with over 6,000 records. The form currently lists the records in datasheet format with header and footer for things like buttons and filtering. The client wants to be able to go from page to page of the souce query, showing 100 records on the form at a time.

But at the same time, they should be able to filter or sort the data source in it's entirety. The person who created the form came up with what seems like an awful solution to the problem. It seems to use a random number generator to determine how many records to portray at a time. I see this in the code as well as in operation, because the number of records on page to page varies. It doesn't even start out at 100! Worse yet, using a sort on the page only sorts the records that are visible.

View 9 Replies View Related

Forms :: Data Validation After Record Input

Dec 17, 2014

When I learnt to use vba in excel (to basic level) I was always advised in a userform to validate data at end of record input i.e. when pressing enter and next. Is this true also with access or should i be putting validation rules at the afterupdate stage of a particular control?

View 1 Replies View Related







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