Text Box properties- validation rule- I want to restrict values to uppercase letters from A-B inclusive in TextBox1 I want to restrict values in another Text...
OK. Your relationships are: DLVS -> CNTRLS PKUPS -> CNTRLS To be able to insert new rows into CNTRLS, the query must contain both foreign keys, and they must...
Mark- To restrict the values in a field to just A or B, use: In("A", "B") ... To restrict a value in a field based on what's in another field, you must define...
I'm not sure that I understand your question. When you say " I want to restrict values to uppercase letters from A-B inclusive" aren't you saying you want to...
Hi All, I am currently in the throws of setting up a "Work Order" database for my company. What I need to accomplish is have a query run every so often that ...
Mike- How do you plan to determine a Work Order is new? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out"...
Hi John, The query will look for "Status=0" in my "WorkOrders" table. ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of John...
Text Box properties- validation rule- I want to restrict values to uppercase letters from A-B inclusive in TextBox1 I want to restrict values in another Text...
I apologize to the group. I didn't realize my first post got posted. Thank you, Mark Espinosa __________________________________________________ Do You Yahoo!?...
Thank you all for your help. I may have simplified my question too much. I really want to restrict text box input to a single letter A through N. The text box...
Thinking laterally, wouldn't you be better off with a combo box in place of textbox1. You could limit the rowsource of the combo box to the permitted entries....
Thanks John - Will give it a shot! ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of John Viescas Sent: Thursday, February...
Does anyone here know Access experts located in the Memphis area. My skills continue to improve but are beyond the point of most training programs locally. I...
Hello everyone, I was wondering if anyone has one of these already. it does inventory and then also allows people to submit orders. So that the main billing ...
The sample database that comes with Access called "Northwind" is a customer / product / orders database it is a nice start to an inventory database. As for the...
Well the this database will be used for healthcare order management. Would northwind would work for us? is it easily changeable? Sincrerely, Steve Payne ...
Hi All, What event should I use if I have a combo box that is based on a query and I need to requery it as soon as I click the down arrow? I've tried using...
Northwind is totally changeable. However, I would use it for an example and create your own along side of it. That way you can use your own terms and it...
I am asking for help...to those who are expert in MS Acces. I'm preparing for db using msaccess. I am not familiar yet with its functions. I need to...
Gee, based on what little information you provided, this sounds like homework to me. If it is, then you need to work through the development of the database...
I would like to record a form that would be the same as another one i already have, but that would filter data (for instance field "Date of death" is null.) Is...
Clauss Gilbert
gilbert.clauss@...
Feb 3, 2006 3:19 pm
19415
Try in the Got Focus Me.ComboBoxName.Requery Mike Bisson <mbisson@...> wrote: Hi All, What event should I use if I have a combo box that is based on...
In the query tab click NEW, then when the pop box appears, click Simple Query Wizard. There will be a tab in the section that ask if you want to "GROUP" by...
That's exactly what is happening - I have 2 comboboxes on my form, NewWOList and PendingWOList. What happens is, new work orders show up in the NewWOList...
When do you run the update query? Right after the update query runs is when you should refresh/requery the two comboboxes. John -- John V. Ruff – The Eternal...
They select a new WO from the NewWOlist combo box and click a button that says "show me details" which brings up the "Acknowledgment" form. This form contains...
There are two ways to do the requery once after each update. 1. In the "Acknowledge WO" button's click event, after the update query runs add two lines of...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
