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
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
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'.
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 RelatedI 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.
I have an issue with designing a query.i have three tables (there is more but these should do for this)
Game Review
reviewer
Game
i need a query that will only select games that the reviewer has not reviewed.its to populate a box on a add review form so that when a reviewer has been selected, the next drop-down will only show games that have not been reviewed yet by that reviewer.
I have an access database which import the .csv file but after importing it is creating the tables
"google_ImportErrors"
If i won't delete this, for next time i would open the database it will create the tables and follow the same sequence like stated below and it increase the size of the database so deletion must be required which i do manually.
"google_ImportErrors1" (table names)
"google_ImportErrors2"
"google_ImportErrors3"
"google_ImportErrors4"
I want to delete/drop all tables with a query that have the names like "google_ImportError...", how to do that in automation?
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.
Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?
View 1 Replies View RelatedIs 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 ...
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 RelatedI have a form (DropDown form) that has 3 drop down fields, you select your values from the drop downs and you would push a command button that runs an event procedure which runs a query (DropDown qry test). The user should have the option of picking any combination of fields to filter by. Or no combination, which would return all values in all fields. So I am basically using the form as parameter's for the query.
The problem I'm having is that my query is returning values for one field AND values for another field. Even if the other values selected are not in the same record. It's not combining the fields together to filter. For example: you pick a Project name and Supplier name, the query will return records that have the project name you selected but it will also return records with the supplier name you selected that have a different project name.
I've attached screen shots of the form and the design view of the query (the screen shot cut off the last column name. It is meant to say "Expr3: [Forms]![DropDown form]![Combo7]").
Using Windows 7,
Access 2010
Is there a way to select multiple values from the drop downs?
When creating a query I have set up a parameter query as instructed (in this case searching for a name) but when I run the query it returns the error 'this expression is typed incorrectly etc.'
I have worked out that this must be due to the fact that the names are not typed in by a front-end user but need to be chosen from a dropdown list (which i have stored in a separate table) - So, the query seems to fail based on that.
I have created a query with the parameter for the Domain field. however on the form the user enters this information via a drop down menu. i was just wondering could the parameter box be set to a drop down box as well to save the user entering in the full Domain field name?
View 6 Replies View RelatedI have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc
View 2 Replies View RelatedOk, 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!
:)
A group of us are working on this database for a girl scout troop and we were asked to create drop-down boxes for the parent information and doing one for the bus information. We are a bit clueless right now so I was wondering if anyone could help us out. I have added database Its called project.mdb
This is the link for the database
https://s51.yousendit.com/d.aspx?id=0D6D0LHFP3X551Y4BT5GC5DK3T
This is my e-mail
absolut_producer@hotmail.com
I have a form with some drop down boxes
The form is based on a table
One field is lastname and one is firstname
The row source is based on table/query
The lastname field works fine but the firstname brings in the lastnames
What am I doing wrong
Hi Guys,
I have a combo box on one of my forms that on clicking the arrow the user has the option to either input yes/no. However i have just noticed that the user doesn't have to input yes or no and can actually put whatever they want in it (which sort of defeats the object of the combo box!!)
Any ideas guys/gals??
regards,
Lee
My database is set up with a sub form showing:
Mfg, Model, Serial#, and Type. When I drop down and choose the Mfg, I then go to the next drop down (Model)and the only choices I have are those associated with the Mfg I just selected from the previous drop down. On my Enter Repair Data form, I want to be able to drop down a box for Part Number and then have a drop down field for the Part Description to match the part number that i just selected. Then I would like to have the next drop down to show a unit price for the Part Number and Description fields that I just entered. Is it possible to accomplish this with an existing Data Base? My data base is 1.61M so it's too large to upload here, but if someone can help me my ICQ # is 65-489-369, e-mail is huntiir@bellsouth.net. I can upload a copy of my database if needed.
I also need to have a field added to another report in my data base sowing the total labor for units shipped on a particular date to a particular customer. The report already totals parts used in the repair of the units for that date. I just can't seem to get the total labor to show up.
I was also trying to set up an inventory Report on parts used for my repairs where it will calculate the number of parts in stock in the form of:
RR#, Part#, Description, Unit Cost, and Total Units in Stock. You can see that I am somewhat complicated and ignorant to the use of Access.
Can you help me out please?
Hello,
How to do drag & drop in a form ?
I would like user click a field on a listbox and place it with the mouse in a field of the form as you can see in windows explorer to move a file from a place to an other.
I tried with mouse events but i don't obtain exactly what i want.
I this possible to do that ?
Thanks in advance.
Currently the database has a parameter query in which the query is entered via a pop up box, it would be preferred if the query could be selected from a list of criteria in a combo box and run via a command button.
Any ideas would be much appreciated.
Regards
Hello Everyone. I'm not all that new to access however my problem does exceed my experience and I'm hopeing someone out there maybe able to help me.
A while back I began to build a database to keep track of post production activites such as what items were being produced on a perticular production line. Its my job to book all these items in according to date, line, item, order and qty.
This was all good and simple until it was decided that I had to assign a category to each item. Their are multiple models to one perticular category and to make things even more difficult the same item could be produced on more than one production line.
I work within a Pool company where their are 7 production lines, each with their own purpose and facilites of making certain products until you come to other products that could be produced on any of 3 or more lines.
So, I made a table 'Category' which lists the different types/acronyms for products and the lines in which it could be produced on.
I than created a new column within my Post Production table called 'category' and chose to use a drop box so I may select which category to assign the item. The drop box shows both columns 'Catefory','Line'.
The problem I have is that theres 40+ rows within the Category drop box and because the same name of the category may appear more than once simply beginning to type in the category name isn't good enough.
Is there a way to filter out which categories is listed within the drop box according to which line it maybe coming off once I've already selected which line within the same row?
I've tried selecting a relationship and createing a query both failed.
WarrenG.
I have an Access 2002 database with a relationship between 2 tables I want to delete using VB code. I setup the relationship from within Access. Is there a way to find out the name of the relationship, if there is such a thing. The tables are: TableA.Id linking to TableB.BankAcctId with both cascade functions. What would the VB code look like? Something like ALTER TableB DROP CONSTRAINT ...
Thanks
I am creating a table in Access 2003, and I need to add a drop down list to one of my columns. See the attached picture - I need to add a drop down list to the "Division" column that will allow the user to select from one of 5 choices. How do I do this?
I'm an Access beginner, BTW. :)
I am building a query for a university and the table i am working from has a column with every course run by the department.
How do i create a query that allows me to add a drop-down menu to the course instead of having to write out the course name everytime i want to query the number of pupils on a particular course.