Helow
I have a Combo-box where the user can select an item of the
storehouse, after that, the user can indicate the quantity of items
that go out.
I want to validate that the quantity of items do not exceed of the
quantity of items in the storehouse.
I have that:
Validation rule: <=[Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6)
If [Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6) = 67
(for example) and i write 7 then it skip the validation rule. Why??
5  1648 
What do you mean by "it skips the validation rule"? Seven would be within
the allowable entries. Also, just a quick check, but the column property of
a combo box is zero based. So, Column(6) would be the 7th column, is that
what you want?
--
Wayne Morgan
MS Access MVP
"Nuria" <nu******@ono.c om> wrote in message
news:17******** *************** **@posting.goog le.com... Helow
I have a Combo-box where the user can select an item of the
storehouse, after that, the user can indicate the quantity of items
that go out.
I want to validate that the quantity of items do not exceed of the
quantity of items in the storehouse.
I have that:
Validation rule:
<=[Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6)
If [Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6) = 67
(for example) and i write 7 then it skip the validation rule. Why??
7 is greater than 67 when they're Text instead of Numeric. Check your
data types.
On 9 Dec 2003 00:41:45 -0800, nu******@ono.co m (Nuria) wrote: Helow
I have a Combo-box where the user can select an item of the
storehouse, after that, the user can indicate the quantity of items
that go out.
I want to validate that the quantity of items do not exceed of the
quantity of items in the storehouse.
I have that:
Validation rule: <=[Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6)
If [Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6) = 67
(for example) and i write 7 then it skip the validation rule. Why??
7 is greater than 67 when they're Text instead of Numeric. Check your
data types.
(Re-posted because original response did not show up on my server.)
On 9 Dec 2003 00:41:45 -0800, nu******@ono.co m (Nuria) wrote: Helow
I have a Combo-box where the user can select an item of the
storehouse, after that, the user can indicate the quantity of items
that go out.
I want to validate that the quantity of items do not exceed of the
quantity of items in the storehouse.
I have that:
Validation rule: <=[Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6)
If [Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6) = 67
(for example) and i write 7 then it skip the validation rule. Why??
Matthew Sullivan <Ma**@NoSpam.co m> wrote in message news:<d0******* *************** **********@4ax. com>... 7 is greater than 67 when they're Text instead of Numeric. Check your
data types.
(Re-posted because original response did not show up on my server.)
Yes, is that my problem. The type of the datafield in the table is
numeric but when the user selects a register in the combo-box the
value returned by the column is text.
I have created another text box, named aux:
-Control origin=Val([Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6))
-Visible=no
and i done the validation rule in the text box where the user write
the amount:
<=[aux]
It works but it seem a bit bungle.
Do you know another way to do it?
Thank you so much
You either need to add the field to your query that corresponds to the bound
field of the combo box and set the criteria in that field (preferable) or
use the column property of the combo box to return the data from the column
that does correspond to the field that you have in the query.
--
Wayne Morgan
Microsoft Access MVP
"Nuria" <nu******@ono.c om> wrote in message
news:17******** *************** **@posting.goog le.com... Matthew Sullivan <Ma**@NoSpam.co m> wrote in message
news:<d0******* *************** **********@4ax. com>... 7 is greater than 67 when they're Text instead of Numeric. Check your
data types.
(Re-posted because original response did not show up on my server.)
Yes, is that my problem. The type of the datafield in the table is
numeric but when the user selects a register in the combo-box the
value returned by the column is text.
I have created another text box, named aux:
-Control
origin=Val([Formularios]![SalidaMarcos]![EleccionMarcos].[Columna](6)) -Visible=no
and i done the validation rule in the text box where the user write
the amount:
<=[aux]
It works but it seem a bit bungle.
Do you know another way to do it?
Thank you so much This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: deko |
last post by:
I use variables in some links on my page. I need to send these variables so
I can change the color of the links in the navbar when the user is on that
page. If you click around on the site you will see the links in the navbar
change:
http://www.clearpointsystems.com/
When I try to validate the page at http://validator.w3.org/ I get the
following error:
|
by: LRW |
last post by:
http://gto.ie-studios.net/index.php
When you view the above site in IE, if the 1st of the three product
images is tall enough to push the cell down a couple of pixels, IE
somehow doesn't show that happening.
But if you look at it in Firefox you can see the small gap of white
where the semi-circle image is broken.
I've tried changing the background colors to gray in cells and tables
|
by: fred |
last post by:
I'm trying to validate data entered into a form field by using a
Query. I've discovered that the validation rule is pretty useless if
you need anything other than very basic validation.
I've tried using the following After Update Code:
Dim strSQL
strSQL = "SELECT tblProducts.ProductSRP FROM tblProducts"
strSQL = & "Where (((tblProducts.ProductID)=!!.!));
|
by: Fernando Lopes |
last post by:
Hi,
I have a combo (DDL1) and a textbox (TXB1).
So, if the selecteditem of DDL1 is None (selectedindex =0) the validator
don't need to check if there's anything in TXB1.
If DDL1 selecteditem has anything different of None, the validator need to
check if TXB1 was fill.
Someone understand me?
How can I do that? Probably i will use custom control.
|
by: msnews.microsoft.com |
last post by:
Hi All,
I m facing problem in Server Side Validation.
For Example The Scenario is
I have two fields on the page
1 Country Dropdown List
2 Province Textbox
3 State Dropdown List
| | |
by: jslowery |
last post by:
I am not completely knowledgable about the status of lexical scoping in
Python, but it was my understanding that this was added in a long time
ago around python2.1-python2.2
I am using python2.4 and the following code throws a "status variable"
not found in the inner-most function, even when I try to "global" it.
def collect(fields, reducer):
def rule(record):
status = True
|
by: Martin Clark |
last post by:
Hello, I am daring to stick my head above the parapet and ask as
question. I am working on redesigning a website to use CSS rather than
tables for layout. I have come across a problem when trying to float an
image to the right.
For ease of looking at the problem, I have stripped away other parts of
the page layout, and have just included the "content" section in the
examples below.
The basic design of having a left column and a main...
|
by: Jon Maz |
last post by:
Hi,
I'm having problems with a RewriteRule that's applied to url's with the %
character in them, hope someone can help. The % character is a result of
url-encoding non-ASCII words, as in the example below:
1. the word "sécurité" comes out of my db
2. I construct the following link, using the php urlencode function:
<a href="/search/s%C3%A9curit%C3%A9">sécurité</a>
|
by: webrod |
last post by:
Hi,
I have some php pages with a lot of HTML code.
I am looking for a HTML validator tool (like TIDY).
TIDY is not good enough with PHP tags (it removes a lot of php code).
Do you have any idea?
Thanks you very much
|
by: mariodavi |
last post by:
Hi everybody,
how to validate input text in the follow:
if option combo = 1,2 e 3, input 1 and input 2 must be filled, if one of this values not selected in combo (to be others), filled input 3.
validate code with error below:
funcion validate () {
...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
