Search results

Hello everyone, just a follow up questions. how to create multiple validation rule either on Tables or Forms, like for example: if the user will click Mechanical, it will create 4 validation rules since Mechanical has 4 subcategories (Deck, Flareboom, LSF and LQ). Happy New Year...

i got this already. but, i did not apply the programming/coding or any property sheet event ... what i did was just a simple validation rule and validation text in the Tables in the Design View mode... so far, it gives me the right values and it satisfies the users... Thanks. :)

okay i got it. thanks again.

what if the users are the one who is responsible for the updating of data? all i do is to create the database or system. should i still follow your suggestion?

okay will try this in a while. though im not sure about the command button since people will input in a table-like in a form without a button. i attached a photo for this. thanks John, will just take a break, hehe.

my experience level? hmmmm, i should say beginner but i worked with MS Access for sometime. programming is my weakness, thats why i do research on some samples then try on my own then apply it on my database. yup i tried designing a form (with or without splashscreen, password screen...

unbound i guess. its kinda simple to think on my part (at least) but when i tried i cant get it right. its just inputting values by the users that should not exceed to the assigned values if it exceed it will prompt a warning or a messagetextbox.

there is no msgbox yet. i havent started working on it. the photo attached was done in Excel not Access and thats the concept of what i want to do.

hello everyone, i have a database that needs a manual input from the user for X, Y, Z range. i need help on deriving a code ( "maybe" in query for criteria? ) that tell if the user exceeded on the allowable number range of either X, Y, or Z. for example: X = should have a value of 5 up to...

sorry for not getting it at first. yes i did create a separate query and separate table. when i created the Combox, i get the values from those tables and queries. but the problem is that i dont get the right values, i know there is a problem with my commands or placing of my commands. in the...

my question here is kinda different. its not adding/updating because the records are there already, its fixed - no more no less, like: when 2009 is clicked 115% should appear in the text box when 2010 is clicked 110% should appear in the text box when 2011 is clicked 105% should appear in the...

actually i have this kind of function in my DBS which i got it from one of your samples also - adding or updating records or items...

thanks a lot John.

it will take me some time to do this because im not sure if i got what you mean here. sorry im not an expert with Access. anyway, thanks John.

now, im kinda confused :o ... another problem is that i dont need another pop-up form, these combo boxes and text boxes should be in one form.

i tried your sample before about combobox (same as your reply now) and it works but the only problem is that it goes universal, i mean whenever i chose something from the combobox the entire textbox will get the same values from the combobox. attached is a photo. every Year should have a...

okay thanks.. but how about the row source of the combobox in the form's Property Sheet? and the control source of the text box that will show the values selected from the combobox?

my question is to how to get values from my combobox to other table/query. ex. i have a combobox in SAMPLE FORM. i dont want to get the values from the rowsource of SAMPLE FORM, i want to get values for my combobox to other table/query.

Hello everyone, can anyone help me? I have a combo box that will get values from a different table or query. i am having a problem with the query and the row source on what to write so i could get values from the table/query. i tried with the resources i gathered but still i dont get the right...

im sorry but its not working... actually, i use John Big Booty's sample : http://www.access-programmers.co.uk/forums/showthread.php?t=188663 almost everything is similar to him... im working on every boxes of my DBS (design view) with =CLng([SearchResults].[column](33)) some entries...