Table Entries From A Drop Down Of All Possible Queries

Feb 15, 2006

Hi All,

I am wanting to build a table which consists of all the queries and tables in the database.

I am expecting column 1 to have all the queries and column 2 to contain all the tables that make up the query. So the table will look like this:

Queries - Linked Tables
Query1 - Table1
Query2 - Table1
Query2 - Table2
Query3 - Table1
Query3 - Table4

As you can see a table can be linked to any number of tables.

Now for my actual question. I don't want to have to type in all the queries and tables. I would like to choose any query and table from a drop down of all possible queries and tables that are currently in the database - like a list, where the list contains all the possible values.

I would then select the relevant entry.

Any pointers would be great.

Thanks,

Evan

View Replies


ADVERTISEMENT

Drop Down List Is Changing All Entries

Jan 31, 2006

I have a drop down list where you pick from 6 recruiters. i put it on my candidates from and when yiou change a recruiter on one candidate then all the candidates get changed to that recruiter. Any ideas what i did wrong?

View 1 Replies View Related

Forms :: Drop Down Box Auto Filling Other Entries

Apr 26, 2013

I've created a drop-down box on a form, that allows a user to choose from three names.

However, when I choose say name A, it then populates all the other entries with name A.

For example:

record 1 has name A
record 2 has name b
record 3 has name a

if i then enter a new record, and enter name C in it, it changes records 1, 2 and 3 to show name C too.

is there a setting i need to change or something?

View 1 Replies View Related

Tables :: Posting Multi-entries From Drop Down

Nov 1, 2012

I have a field in which I wish to post several contacts. The contacts are listed in a table and populate the specific field via a drop down. In this specific field I want to select "mary" "bob" and "fred" (all three to display) however only one is displayed.....

View 3 Replies View Related

Split Database Not Showing Updated Drop Down List Entries

Jun 4, 2014

I have a database that is split - one central PC holds the back end, and then there are multiple end users with a copy each of the front end.We have updated a drop down menu on a field in the back end to add some new entries, but this is not showing up on the front end copies.Is there an easy way of updating the front end to show the changes?

View 3 Replies View Related

Queries :: Remove Duplicates Entries In Table?

Jun 11, 2013

I have a table called Stock Levels which contains 3 fields. (ID, ProductID, StockLevel) ID is the Pkey, ProductID contains duplicates and StockLevel which contains different stock levels

and I am trying to remove the duplicates and retain the the data so I am left with the correct stock number

what I have done is the following, but I am still getting duplicate values in productid and stocklevels

SELECT DISTINCTROW id, productid, stocklevel into mynewtable from stocklevels

I have attached a screenshot of the table

View 3 Replies View Related

Queries :: Sum Of Multiple TIME Entries Of A Table

Oct 25, 2013

im in the middle of developing a database to log DOWNTIME of various machines in the factory. Basically myself and others will use it to log breakdown details and the amount of time (in HH:MM) the machine was off.

I have a form which will list details of a certain machine in a list box which i can populate using a query.

The list box will display 3 columns: Date of Breakdown, Machine Name and Downtime

I then have a text box below this that i would like to display the TOTAL amount of downtime for that machine (The listbox may have different information in it depending on the query criteria, e.g. It might display a certain month for a certain machine).

THE ISSUE i am having is its proving to be difficult to get the correct sum of the accumulative time to display correctly in the text box.

Is there a way i can use a query to calculate the total time of a column and return a value which is formatted as time (like this hhhh:mm or dd:hh:mm) or preferably use some VBA code on the form itself to total up the DOWNTIME column of the list box and display it with the correct format in the text

I have gotten close, but as the total amount of time exceeded 24 hours, it went past 00:00. I'm assuming it treated it as a clock and went into the next day? This is NOT what i am after, i need the total amount of days, hours spent on the machine and not a time of the day.

View 10 Replies View Related

Queries :: Show Entries From 2 Tables Not In Third Table

Jun 22, 2013

I have 3 tables;

tblEmployees - Stores employee data
tblProcess - Stores process data
tblTraining - Stores data on which employees have trained on which process

tblEmployees has a 1 to many relationship to tblTraining through empID
tblProcess has a 1 to many relationship to tblTraining through pcsID

When a new Process is added, a query auto populates tblTraining with 1 record for each employee in tblEmployees. Equally when a new Employee is added, a query auto populates tblTraining with 1 record for each Process in tblProcess.

In theory this should ensure that every employee has a training record for every process (and vice versa). However, as many of us know, never assume the user wont find a way to mess things up!

So i want to have a query that can show me Employee and Process without a training record. I have been manipulating a SELECT (SELECT) query to pull this together, but i just keep coming up blank.

I have attached a copy of the relevant tables and query. I have deliberately deleted a training record for empID 6 on pcsID 1 AND empID102 on pcsID 2 (qryCheckTrainingRecordsBalance will show the processes these 2 DO have a training record for).

View 5 Replies View Related

Queries :: Listing Null Entries In A Second Table

Jul 31, 2013

I have a Membership List Table with a calculated field entitled Member Name.

The second table entitled Groups contains only 46 records each of which has up to 30 Fields also containing member names.

I Have written a query to establish which of the members from the single field of the first table do NOT featured in any of the fields and records of the second table. In the Query Design View I have listed 'Member name' from Table 1 followed by all the relevant member fields from Table 2, carrying the criteria 'Is Null'.

When I run the query, it merely lists all the members from Table 1.

View 8 Replies View Related

Queries :: Possible To Sort A Table Drop Down Box By Date Within A Query?

Oct 3, 2013

Is it possible to sort a natural table drop down by date from within a query? What im doing:

1. making a query that has certain results displayed
2. within the query you can select one of the field boxes and it has a list of all the items in that table.
3. is it possible to sort this natural table listing from within the query. I have attached a screenshot. Same thing happens with the client ID listing from within the query. Want to know if it is possible or not to sort those. I cant see how.

View 1 Replies View Related

Queries :: Drop Down List Selection - Move Records From One Table To Another?

Sep 15, 2013

Is there a way in which someone can select a table from a drop down list and then search that table for a record then move that record to another table.

For example.

User selects 'Mikey's_table' searchs for a record then move this selected record to 'Mandy's_table'

(all the tables have the same structure etc. identical apart from the name of the table and records within)

I have the list of tables that all the records will be on and the users will know which table the record is in, i basically need to know if there is an ability to search for a record over multiple tables then edit that record and move it to another Table.

I have tried to use a Union Query which works when searching but i cannot edit or move the record ...

View 1 Replies View Related

Forms :: Assigning Multiple Entries In One Table To A Single Entry In Another Table

Jul 24, 2013

I've got a table tblPatienten, a table tblRechnung and a form frmRechnung.

The primary key in tblPatienten is KundenNummer, the primary key in tblRechnung is RechnungsNummer. The relationship between tblPatienten and tblRechnung is one to many.

Now, every patient (stored in tblPatienten) is allowed to make multiple orders (stored in tblRechnung).

How can I assign each new order entry in frmRechnung to an existing patient in tblPatienten?

View 10 Replies View Related

How To Make Two Table Entries Correspond To Single Entry Of Different Table

Nov 18, 2013

I have one main table with a list of equipment. I have a second table where there will be a form for damage reports.

What is the easiest way to make multiple entries from the second table correspond with a single entry on the main table?

Some equipment pieces might have dozens of damage reports, while some might not have any.

View 1 Replies View Related

Drop Down Queries

Nov 24, 2004

I Have A Query Where There Is An Input Box For Example What Region Do You Want The Query To Run On And Instead Of Typing It In I Would Like To Know If It Is Possible To Have A Drop Down Menu Of Possible Selections

Kind Regards

View 1 Replies View Related

Duplicate Entries And Queries?

Jul 30, 2007

Is there a way to find and remove duplicate entries in tables by using queries.....if so, how specifically?

View 1 Replies View Related

Queries :: Multiple Entries For Same ID In One Day

Dec 16, 2014

I have a tblhealthrecord that has many multiple entries for the same animalID. Would like to pull up all records from this tbl for one animal. I can sort them later but just need to know what to ask for so I can read upon them. I at first thought this could be based on date but not really since you could have multiple entries in one day.

View 7 Replies View Related

Queries :: Get Average Of All Non-zero Entries?

Nov 26, 2013

I have a query result-set with several columns: A, B, C ,D. All Four of these columns display numbers. From this query, which I will call the "SetUp"query, I want to query it and obtain the average for each of the columns A, B , C ,D. However, some of the values in columns A, B , C ,D are zero. If I use the standard 'Avg' function in Access, it averages the column AND INCLUDES THE ZEROS IN THE AVERAGE. How can I get an average of just all the non-zero entries?

View 4 Replies View Related

Filtering Queries With Multiple Entries

Aug 11, 2005

I have a query that feeds a report. This report shows a "Set" and the "Charge Numbers" associated with it. Each set could have a possibility of more than one set of IT numbers. This means there could be say 2 entries for set "D7" and IT numbers for both of them.

As a result when I run the query, and say the set has 2 Charge numbers, it will bring back 2 results, with 2 charge numbers on each of them, which is correct. So if a set had 4 charge numbers assigned to it, 4 results would show with 4 charge numbers for each result.

Is there any way I can make it only show one of those results as they are identical?

I know this is confusing, bare with me

View 5 Replies View Related

Queries :: Number Of Duplicate Entries?

Jun 25, 2014

I'm trying to use access to identify how many times an indiviual appears in my database. I've got a large file which gives me all referrals, each referral comes with two identifiers, one unique to the person, another unique to the referral. This means that the person unique number may be repeated multiple times (if a person has more than one referral) but the referral number would be different each time.

I've run a query to identify the duplicates, i.e. the records where the person unique identifier is repeated. What I am trying to do is work out now how many people have been referred twice, how many three times etc. The original query looks something like this (but on a much bigger scale).

Person Referral
1 A
1 B
1 C
2 D
2 E
3 F
3 G
3 H

What I'm after is a query that will tell me that two people were referred three times (1 and 3) and that one was referred twice (2) and so on.

I'm on Access 2010 if it makes any difference.

View 6 Replies View Related

Queries :: Query With IIF And Null Entries

Jul 29, 2013

I have a form that feeds information to a query which in turn sets up a report. For clarity i will list out in basic terms what I have

Input Form
- Check Box to activate/De-activate a text field [chk-active]
- Text field for a parameter [txt-Parameter]

the query has a column that has null values from the originating table. These values will be added a t a later date, but need to be queried and reported at some business intervals.

In the query criteria for this column, I have the following Criteria

Like IIF([Forms]![ReportGenerator]![chk-Active]=0, "*", [Forms]![ReportGenerator]![txt-Parameter])[/I][/I]

I have tried for the last 5 hours to figure out how to write the formula to be able to get the blank entries to show up as well but have had no luck.

View 5 Replies View Related

Queries :: How To Use One Text Box With Multiple Entries

Sep 19, 2013

I was looking to run a query using one text box with multiple entries. For example : EP342, EP423, EP234. Is there a way to do this in VB?

View 5 Replies View Related

Queries :: Return All Entries For Specific Day

Jul 6, 2015

I have a large table with millions of entries. I want to run a query to return all entries that are on a Saturday. The date stored in the table though is just typical date format eg 15/11/2015.

View 1 Replies View Related

Queries :: Verify Data After Certain Entries

Jun 16, 2014

Is there any way user can verify the data that its enter correctly, for example I want a button on user form, after every 14 entries when user hit that button it bring the sum of 14 entries.

View 5 Replies View Related

Queries :: Drop Down Lists Or List Box

Dec 2, 2014

In my table I have the following fields that are tick boxes

Vee
Cathedral
Round Bilge
Bilge Keel
RIB
Semi-Displacement
Keel
Lifting Keel

Each record can take a couple of these options. For example record 1 could be ticked for a 'vee' and a 'cathedral' whereas record 2 could be ticked for all of them.

I have been trying to use these to make a search form. I want to be able to chose on ie. 'Round Bilge' and it will search for a record that is ticked 'round bilge'. I have done this for both a combo box and a list box and have used the formula for each field [Forms]![Boatsearch]![hulltype]

When I have clicked run query I have an error message saying: 'This expression is typed incorrectly, or it is too complex to be evaluated. For example a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables'.

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

Queries :: Drop Down Filter And Null

May 15, 2013

I have two combo boxes ref 1 and ref 2

Both have the same source list but I would like the ref 1 list to exclude ref 2 and the ref 2 list to exclude ref 1 but I am struggling when either value is Null gives me no list.

Ref 1 row source

SELECT [Reference Probes].Ref, IIf([Forms]![frmCalibration]![Ref 2]=Null,([Reference Probes].[Ref]) Is Not Null,[Reference Probes].[Ref]) AS Expr1 FROM [Reference Probes] WHERE (((IIf([Forms]![frmCalibration]![Ref 2]=Null,([Reference Probes].[Ref]) Is Not Null,[Reference Probes].[Ref]))<>[Forms]![frmCalibration]![Ref 2]));

Ref 2 row source

SELECT [Reference Probes].Ref FROM [Reference Probes] WHERE ((IIf([Forms]![frmCalibration]![Ref 1]=Null,([Reference Probes].Ref) Is Not Null,[Reference Probes].[Ref])<>[Forms]![frmCalibration]![Ref 1]));

Ref 1 after update has Me.Ref_2.Requery
Ref 2 after update has Me.Ref_1.Requery

As you can see I have tried two different ways but both don't work.

View 2 Replies View Related







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