Hi everyone,
basically what i need to able to do is set a validation rule that allows me to enter a value that is between 5 and 10 kgs but (and here comes the confusin bit is also rounded to the nearest 5kg. I tired using the[ like "?.?0" or "?.?5" ] command but have so far been unsucessful. Also i really like oranges.
Ok this may seem very confusing as alot of things need to happen for what I am trying to do
I am doing an inventory database that contains all order, client, purchasing, and inventory information.
I have a table that has all of the different products we sell (also includes which of the following tables are needed) I also have separate usage tables storing how many of each part (given a partnumber) for each of the products.
Now this is where the complecation comes in .When I create an order I want to 1. add a record to my order table (containing ordernumber, client number, product purchased) 2. using the product table, find out which usuage tables need to be looked at, go into those usage tables, get the number of each part that is needed for the product and store the value into an allocation table
I have had this on my mind for the past 2 weeks that I have know I will have to do this at some point. I am getting to the point where I cannot do anything else without this being done. I need help something bad.
If you feel you know how to do this and think you need more information, email me at cgow1@cogeco.ca
Hello, Im creating a database for a charity just to get some experience and im stuck on something - my table structure.
I know you might find it a bit difficult because you dont know the background info but i need the database to be able to let customers and members make bookings. Ive thought of putting both customers and members in one table but i dont want it to get complicated and messy, although i will do that if there is no other way.
One of our key customers (GE) has demanded that we begin to submit our estimates in their transmission 160 character format.
Basically it it a txt file that looks like this all on one line. 1ABCDWXYZ0502EST TEST123456T050208654321C 00010851803098518031 000000E 0000000000000D CAR SHOPPED AS CLEAN-PROCEED WITH
Only a couple of those characters are in my database and will change. Other than that items will continously be the same. The items that are optional and we don't have not only have to be blank but have to have spaces there instead...not 0's.
How do I set up a query to kick all of this out? I tried something like:
I am trying to redesign an older DB for a school, to meet the new needs that emerged. I am totally confused due to the complexity of the problem. I've already searched in this forum and in Google but most articles are for simpler DBs. Well to get to the point.
School has Students, Students attend to Classes (many to many) Students are assigned Lessons (many to many) and coming to the confusing part a Lesson in specific Class may be teached from two different Professors (e.g. the 1st may teach the theory and the other the excersizes). So another many to many Class-Professor and another Class-Professor-Lesson and so on?
After throwing away many sheets of paper I come up with a schema which seems a little bit strange but seems to going to work for my case. I figure out that I could have a unique junction table storing all these info, and that's no other than the Schedule table. So I'm thinking of having the following relationship schema:
Students StundeID Name etc.
Lessons LessonID Title
Classes ClassID Title
Professors ProfessorID Name etc.
Schedule ScheduleID (maybe a combination of all others) ProfessorID,join with Ptofessors ClassID, join with Classes LessonID, join with Lessons Day Time
Schedule_Students tableID ScheduleID,join with Schedule StudentID, join with Students
What is your oppinion about? Can you see any problems which may emerge from such a design? Thanks in advance
This is a bit confusing, so I'll try to explain it well.
Two tables. One has a list of metals. The other has a list of submetals, and what basic type of metal it is. It's grabbing the second column from the first table. Makes sense, right?
Now, I have another table, with links to both of those fields. What I want it to do is when it picks the metal type, to filter the subgroup to only the types it has associated with it to the basic metal type. Not sure if that makes sense. I'll supply an example.
Table 1 Aluminum Brass Copper
Table 2 Subgroup Basic group License Plate Aluminum Iron Aluminum Aluminum Yellow Brass Brass Copper Wire Copper
Now, if in Table 3, they choose Aluminum from the drop down box for basic metal, I want the dropdown box for the subgroup to have only License plate, and Iron Aluminum. For Brass, only Yellow Brass, and the same for copper.
I've got an unbound form which has a field that I need to relate to from a query, I've got no problems relating to specific records, but I've not quite cracked the ability to select all other records if the field is left at 0.
I've tried using in the query under the 'table' field (for selecting a specific group of people seated at a particular table)
Which I thought would evaluate a true/false with the two results coming from the two options, so if the Table selected on the unbound form was set to 0 then it would set the criteria to >0 (everything table 1 and up), or if anything else was selected other than 0, it would use the number from the unbound form from the TableSel field.
I'm getting blank results from both positive and negative results. I assume that I'm not using the Iif statement correctly, or that there is another way of approaching the problem that my headache is blocking :)
I have a problem. I want my field to become "[field], An " etc. when I type "An [field]" For example, if I type "The Hundred Years War" for the field, it automatically updates to "Hundred Years War, The". I would be happy with a simple validation rule that prohibits the use of "The, A or An" in the beginning of the field but i don't think that is posibble. If this requires VB, I don't know how to use the language and never worked with it. I am completely a novice in VB, but would still love to learn how to make it. :) If you could start me out then, I would appreciate it greatly. :D
Hi im new round here but am working on a database and sum of the validation rules are confusing me now.
Ok i got a couple of things to ask:
1) What rule do i use to make sure only text is entered into the field, i cant use input masks as the size of the text put into the field will vary, as its names of people.
2) Is there a way to check that all the fields on a form have been entered? So if there not all entered an error appears?
3) Finally, is there a way to reset Autonumbers? or do i have to delete all the records and start frm scratch as my autonumbers have gone abiit crazy as sum records have been deleted so my table looks rather strange.
I want to have a validation which will only allow confirmed to be clicked when paid is selected. I put this validation "Confirmed"<"Paid" in the properties part of the table but it doesnt work.
For my Year 12 Computing course, I need to develop a database which will take bookings for a village hall. The database consists of a Bookings Table, a Customer Data Table and a Hiring Cost Table. It is in the Bookings Table that I am having the most trouble.
I believe I have already solved my double booking dilemma by making the Date of Event and Type of Event fields in the Bookings Table into a composite key, thereby prohibiting the entering of data where Date of Event and Type of Event are the same, making them unique.
Here is my main problem at the moment, I need a validation rule on the Date of Event or perhaps the Date of Booking field which means a booking must be made at least a week, and no more than two months in advance of the date of event. The thing is this validation rule is only needed for occasional bookings. Present, again on the bookings table is a Booking Type field which has a lookup consisting of the following “Regular” and “Occasional”, regular meaning bookings that are made at the start of the year, for the whole year.
Ideally, I would like to have it so that when the booking type field is set to regular, the validation rule for the date isn’t needed, and when the booking type field is set to occasional, the validation rule for the date is needed/present.
Could anyone help me with this? As any help would be much appreciated.
Many thanks Daniel
If anyone would like any screenshots of the Bookings Table, email me at daniel_goodman@hotmail.com
How can I set validation for a text field where I restrict the number of characters? For example, if I only want the user to be able to input 12 characters or less, and more than one. >=1 And <=12 would that be correct?
Hi all, Very new to using ACCESS. I am trying to set a validation criteria to ensure that a postcode is imported correctly. An example of a UK post code is SP10 3PB - it may be entered as SP103PB. I need to set a validation criteria to allow either two. What is the format of the criteria to achieve this? Any clues please. Thanks Mike
Are there any useful sites that set out examples of validation criteria?
I am currently making a system for a sports centre and I need some help, I have created several forms one of which is for the coach's details. On the coaches table we have a combo box which has all the different qualifications in it, we have 5 of these boxes but we want to it so that when one has been entered it cannot be repeated in the other boxes, also we want it so that when level 4 Tennis has been entered - levels 3,2 and 1 cannot be entered.
I need to set validation rule on a field. I have done the the below:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.SlideType) Then MsgBox "You have not entered SlideType!", vbExclamation + vbRetryCancel, "Incomplete Form!" Cancel = True Me.SlideType.SetFocus End If
It works fine, but I cant get it ignore it if I press cancel. Sometimes this data is not available so it has to stay empty. When I press retry it should take me to that field to make changes and with the cancel click it should allow me continue with the last command/action before the msgbox was brought up. Can anyone please help, thanks.
Hi, does anyone know how to set fields(como-box) on a form to pop up a validation message when form:confused is attempted for saving without any data selected on the field. I have 5 fields and I wanted my users to get a message for each when left empty...help please:confused: