I have a field in my Customers Table that is a Number type (to record the percentage level of interest). In the Validation property I have <=1 And >=0 to shows percentage. However, I would also like the entries into this field to be limited to increments of 10, such as : 0%, 10%, 20% etc; to 100%. How to correct Validation Rule to only allow increments of 10, and also the Validation Rule (<=1 And >=0) required to show percentages?
I have to assign multiple table validations to my table but they are not even working separately.
1) I have two combo box controls: [Tocolytics] & [multiple_Tocolytics], 3 check boxes and 1 text box.
Rule: IIf(([Tocolytic?]="Yes" Or [Multiple Tocolytic?]="Yes"),([Indomethacin]=True Or [Nifedipine]=True Or [Nitroglycerin]=True Or Len([Other])>0),"check one of the boxes")
2)Two combo boxes The answers are mutually exclusive. If one is yes then the other must be "No" or "unable to determine"
Rule: IIf(Oxytocin Infusion - no PPH]="Yes",([Oxytocin Infusion - if PPH]="No" Or [Oxytocin Infusion - if PPH]="Unable to determine"),[Oxytocin Infusion - if PPH]="Yes")
hey i need help in form validations i have to deliver this project by tomorrow and i can't find anything about validations in sites, or what i find is not useful to me.
i need to validate the field size of each field so it pops up a message when it exceeds that limit. what do i have to type in the validation rule ?
also i need to validate the kind of value each field can accept. i want the number fields to accept only numbers and the text fields only text.what do i have to type in the validation rule ?
i know, i know, this is probabley the simplest thing, but my brain seems to have gone on vacation. please help. i have an unbounded textbox on a form. and need to make it required. i don't want the user to be able to leave the textbox (insertation point) before they enter a value. i can get it to prompt user to enter data, but the cursor moves to next control. how do i get the insertation point to stay in textbox.
I'm pretty good with setting up a very simple database such as inventory, profiles, etc.. However I'm creating a database to keep track of a football (soccer) team's players and match statistics.What I have so farsample attached)
Tables: * Players - PlayerID, Fname, Lname, position, goals, assists, etc (all details regarding a player) * Position - Positons (Table containing positions eg: defender. Data is selected in player's form as a combo-box) * Competition - Competition types (Cup, League, Friendly. Data is selected in Match's form as a combo-box * Venue - similar to Competition table * Opponent - Similar to above two tables * Match - MatchID, Competition, Venue, etc (form corresponding to table attached)
Forms: * Player form * Match form
Now as shown in the sample, I choose players using the combo-box. Then whatever stats they had during the match are entered on the fields provided. How to link the player (selected using combo box) to the stat fields (goals, assist, YC, etc).
I am trying to create a list of values in a field separated by commas. I have done this in a query as follows:
[Field1]&", "&[Field2]&", "&[Field3] and so on.
However, when Field2 is null, the result is two commas between Field1 and Field2, but I only need one. What function can I use to eliminate the extra commas when fields used in the concatenation are null?
Product. Item Description A It's Red B It's Blue C It's Green D You'll love it
Category. Item Category_name A Cat1 A Cat2 A Cat3 B Cat1 B Cat4 C Cat1 C Cat6
I want to create a query/table that takes all the possible values for Category.Item and mix them into one field seperated by say a comma, so it would look like this:
ItemCategoryConsolodation. Item Desc Categories A It's Red Cat1,Cat2,Cat3 B It's Blue Cat1,Cat4 ...
How does one do that?!
What's it called when you try to do this so I can Google it?
I've looked through like 8 Access books at the book store and none of them address anything like this. Can someone recommend a book that would cover "weird" stuff like this?
I am creating a CAD Drawing database / Distribution list. I can only seem to distribute one drawing i.e single field to one person.Is there a way to have multiple distribtion on one field without creating multiple distribution fields?
What I have is a database which contains Drawing Numbers - I need to create a report that shows where the drawing has been distributed to, with it's current revision status and the date is was sent.I am having trouble trying to use multiple revisions and mutiple people in the distribution list with one drawing.
Good day everyone, I am designing a database and came to a screeching halt :(
I have attached the db below for convenience. form in question is frm_InputProductionBatching
What I have is: combo box Function, NumberOfItems, and Minutes in the detail section.
There are three links above that I am trying to make shortcuts in a sense. Those are the most used and would like to make it easier for the user to input instead of selecting from the drop down.
I have a list of Vehicles in which each have their own maintanance schedules. Most of the maintanance for the Vehicles overlap. Instead of entering the same information over and over I'm assigning each type of vehicle a code number (example '05 Cargo is a 1, '04 Cargo is a 2). Now what I want to do is assign each maintanance the vehicle code, for instance I have 13 different types of vehicles that all need oil changes, so I want to assign the Oil change maintanance 13 codes. Is there a way to assign that maintanance 13 codes without having to enter it 13 times??
I am trying to enter multiple parts into the same field and using commas to separate them. Is there a way to create multiple records with the same information, but change the part numbers in them according to comma's?
Would look like this.
Primary Key Location Part number 789 bin89756 89756,87564,78965,12565,45896
I want it to do this in the end.
Primary Key Location Part number 789 bin89756 89756 790 bin89756 87564 791 bin89756 78965 792 bin89756 12565 793 bin89756 45896
I'm new to Access and databases so my question might seem dumb, but I need some help figuring something out. Well, I have this database where I'm storing information from different charities. So I created a table with their name, address, phone, contact person, and many othe things. Now I need to create a field with the services that they offer. Each charity could be able to offer more than one type of service. So for the services field, I cannot create a drop down list because that only allows me to choose one service. So what would be the best way to allow the user select more than one kind of service offered from a list and then be able to search that with a query? I have a list with over 50 different possible offered services and each charity usually offers 2 or 3 different services.Thanks
Hey y'all, my question this morning is concerning doing a multiple field query in Access. I have a lot of experience with both SQL and Access, but have never had to do something like this.
I have a form with a text field for every row in a table (so there are 15 text boxes), and I want the user to be able to type in any data they know for any number of fields, from 0-15 rows. So I want each text box to be matched on (Like '*'&[data]&'*'). My problem is that if I say "where x=x AND y=y" and so on and so forth, it brings up all fields, because there are wildcards on each end of an empty string. I also have problems with just doing OR for each field, because it only matches on one field, even if they entered data into 4 fields. I'm so confused!!!! Did this make any sense? Any Ideas? :confused:
Hi, I have created a field called age, where I have a formula that takes the date of birth out of the IDENTITY NUMBER and calculated the peoples age, I have then created a field where I would like to allocate groups depending on their age, i.e, 18-25 = Group1, 26-35 = Group 2,etc... I am having trouble with this, firstly, I cannot get the formulas to work individually and secondly, I get an error that says I have duplicate fields to update.
My second post. Heres a link to an image of the database below
http://casp.gamecommunity.co.uk/database.gif
In the search section I want to be able to search multiple fields. The date from and to data will come from the same field, Coverage is a drop box and Organisation and keywords could be anything.
I know I will have to grab the text from the text boxes (curently named Textdateto, TextDateFrom, TextOrg, TextKey, and TextCoverage), (the fields are called Dt, Organisation, Keyword and Coverage) use a select query via the on click property of the search button. But I am bit lost on how to put this into practice.
I would like to know if there's any way of fitting multiple entires of data into one field in a table. For example, a field for addresses that might be able to hold two or more different addresses. Must I create another column/field to hold how many different addresses that that person might have? Thanks!
Is it possible to have a text field in a table to store multiple values by using a comma or some other type of seperator? I do not want to set the field to a lookup field because the number of values that would be included would be to many to continuously look through to select. I would prefer to just manually type in what I need and use a seperator to create a multiple value field.
Two tables, in one there are Items and services, in the other purchases.
1st table: ID - autonumber primary key Product Name - Text Quantity - Number Barcode - Text
2ndt table: ID - autonumber primary key Product Name - Text Quantity - Number Barcode - Text Client - Text Puchase Date - Date
How can I enter data to my 2nd table using unique fields (barcode, Product name actually ID in 1st table?) Problem Is Access alows only 1 unique key field in table and that is undertandable. Is there any way out in my situation.
barcode will be entered using barcode scanner it can be only text field but information like product name must fill in automatically, Product name must be drop down box if one wan't to select it manually then barcode should fill in automatically.
Please Attach your DB if you have time to look into this issue.
My question is this: I am creating a database for a student survey. Some of the questions may have multiple answers. For instance, question 2 reads: "What location/time are you taking courses (select all that apply)"
and the possible answers are: 1)Daytime/Oakland 2)Evening/Oakland 3)Saturday College 4)BC
- Where a student could be taking classes at multiple locations or times. I am completely lost as to how to set this up. I have tried to set the properties for the field on the form to accept multiple responses, but of course, these do not save to the table and so it's completely useless.
hello. i saw this post http://www.access-programmers.co.uk/forums/showthread.php?t=116737 , and i was so happy because i thought it was going to be my same problem, but alas! similar, but different.
i want to know how to do a 'not' query on every value in table's field.
the query should list all of table1's field values that are NOT in table2's field values.
Hi all,I posted something similar to this beforehttp://www.access-programmers.co.uk/forums/showthread.php?t=124289But i didnt get it figured out.Is it possible to use the same field for multiple criteria in a query?the one i would like to base it on is taskID.i just want the total time to be called admin time if taskid=2 and investigative time if taskid<>2.Ive tried it with single and multiple queries in one and am recieving errors with both. help is always appreciated!Woohoo for 100 posts!
I'm having a bit of a problem with a query that I am trying to run that searches a memo field, and I hope someone can help me!
Basically, I have a fairly simple database, 2 tables - 1 of the tables has a memo field which has 'keywords' listed in it (a mixture of words/phrases separated by commas, although I've tried with just spaces in between).
When I search using a Query box for 2 keywords using the following query, it can only find the correct records when I enter the keywords in the reverse order in which they appear in the memo field... query: Like "*" & [Enter the 1st keyword to search for] And Like "*" & [Enter the 2nd keyword to search for] & "*"
If the memo field has data eg, "funding, teaching" (as opposed to "funding, nursing" for example) and I search for 'funding' and then 'teaching' - no results appear. If however, I search for 'teaching' and then 'funding'... ta da! Result found.
Obviously, whoever searches the database isn't necessarily going to know what order the words were entered into the memo field!
So, is this a peculiarity to Access, or is there something I'm doing wrong?
I am attempting to create a report that breaks down a field of 'ClaimID' numbers into groups of x. In the sample report below x = 12 and the report will apportion the first 12 'ClaimID's to the first page and textboxes with extra large fonts will signify the start and end of 'ClaimID' numbers for that page. These sheets are used for sorting and pulling guides at our local Xmas project and x will vary depending on the size of the facility we're using. http://i35.photobucket.com/albums/d186/HoodRiverDude/SortReport.gif I believe I can attain my goal if I were able to create a query which broke down the field 'ClaimID' into multiple fields based on x. The sample below represents this breakdown creating multiple records with x, 4 and 5, amount of fields. http://i35.photobucket.com/albums/d186/HoodRiverDude/SortReport2.gif Does anyone know how I can create this query, or perhaps suggest another way to create this report using the existing 'ClaimID' data.