473,327 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Sub Form Control Events

Rob
Hello Access Gurus!
I am developing an application in A2K.I have a subform in which
3 fields exist.The link between the main being an ID field.The other
two fields are both text fields one for the system and the the other
system number.

I want to control the subform events in the sense,some of the system
contain only numeric entries and hence i should prevent users from
entering non numeric characters.When the users enter manually,if they
try entering non numeric characters for certain systems then a message
shld flash and the focus shld remain on the errant entry.
The second is when i take a daily dump of data from a flat file ,the
Systems table contains both numeric and non numeric entries.My
requirement is ,when i scroll the navigation buttons in the main form
,whenever there is a non numeric item in the system number it shld
color it as vbred or some color(to highlight it).Is this possible?

I need help as i am trying to solve this for past two days.

Thanks

Rob
Nov 12 '05 #1
2 2257
Shouldn't you be trapping something like the KeyPress event or
something like that and setting the value to zero to make the numeric
keys effectively inoperable inside the given fields?
Nov 12 '05 #2
Rob
Pieter,
Thanks for your reply.I am talking about the records downloaded
already.How would my code identify these records which are in the sub
form?
How can a user see these text entries when he scrolls the navigation
buttons on the main form.

I am enclosing what i wrote in my original post:
I am developing an application in A2K.I have a subform in which
3 fields exist.The link between the main being an ID field.The other
two fields are both text fields one for the system and the the other
system number.

I want to control the subform events in the sense,some of the system
contain only numeric entries and hence i should prevent users from
entering non numeric characters.When the users enter manually,if they
try entering non numeric characters for certain systems then a message
shld flash and the focus shld remain on the errant entry.
The second is when i take a daily dump of data from a flat file ,the
Systems table contains both numeric and non numeric entries.My
requirement is ,when i scroll the navigation buttons in the main form
,whenever there is a non numeric item in the system number it shld
color it as vbred or some color(to highlight it).Is this possible?

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>... Shouldn't you be trapping something like the KeyPress event or
something like that and setting the value to zero to make the numeric
keys effectively inoperable inside the given fields?

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Richard Cornford | last post by:
I am interested in hearing opinions on the semantic meaning of FORM (elements) in HTML. I have to start of apologising because this question arose in a context that is not applicable to the...
5
by: Brian Rypstra | last post by:
Does any one know if there exists a form control that can function much like a rectangle control but is circular (or 6 sided say)? Can I make a custom control called circle that groups 6 instances...
0
by: jphelan | last post by:
I have a subform that works fine until you import it into a new database when it crashes if you try to open it in either disign or form view. The form, "Attendees_Subform" in my application was...
8
by: Zlatko Matiæ | last post by:
There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...
5
by: RAJ | last post by:
hi plz tell me how to know "how window is going to close"... i have to right code for X button of forms... plz telll me thanks bye
2
by: Aaron Queenan | last post by:
Is there any way to know whether the OnItemCheck is being called in response to a user action (mouse or keyboard) as opposed to the form loading? I have a class which derives from...
4
by: cb.brite | last post by:
Hello, I have tried this using the MouseEnter/MouseLeave events. However these events do not really refer to the rectangular shape of the form, but the client area (form area minus children...
9
by: Rob | last post by:
When a custom control is used within a form, that control does not get events directly. I've run into this a couple times with both mouse and keyboard events. Ex: A custom control inherits from...
4
by: =?Utf-8?B?RWl0YW4=?= | last post by:
Hello, I developed a Composite Control with Visual C# (Rocker Button). The button detects MouseUp events inside the control. However I would like these MouseUp events to be transferred to the...
6
Megalog
by: Megalog | last post by:
Hey guys, my turn to ask a question =D Ok here's my situation.. I have a super simple form, which is bound to a table with a single record. All the controls (mostly text boxes, some true/false...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.