Help on Subform

E

Eric

Can anyone help me with this

I've 2 tables , Table A is the master table i need to work on this table and
Table B is just to supply me with the pre-assigned Class code

Table A - [Class code] & [Student number]
Table B - [Class code]


I need to get the [class code] from Table B , which is manually assigned
once a month. The Class code is unique and can only be selected once.

I've make a dropdown box in Table A [class code], sources from Table B.

How can i make the select the class code from Table B and once i selected,
it can not be selected again ?? or i the record will be disable (unable to
be selected again)


Thanks
Eric
 
M

MaChii

I guess you need to zip it first, not able to get the attachment due to
security.

MaChii

Eric said:
Machii

See the result .. it does not work

Can you take a look and advise..





Eric said:
Machii..

Thanks.. can i send you the form ... in attachment

Eric


"MaChii" <[email protected]> ¦b¶l¥ó news:[email protected]
¤¤¼¶¼g...
Lock the [Class_code] in Table A for "On Change" event, i.e.

Private Sub Class_code_Change()
[Class_code].Locked = True
End Sub

Then after you have changed the class code, the field will be locked
and not
able to change again. But the problem is, if you have selected a wrong
class code, then you will not able to change it. You will need to re-open
the form again. For me, I will add a trick (emergency exit), e.g. when
double click the field then will unlock it for change again.

MaChii

Can anyone help me with this

I've 2 tables , Table A is the master table i need to work on this table
and
Table B is just to supply me with the pre-assigned Class code

Table A - [Class code] & [Student number]
Table B - [Class code]


I need to get the [class code] from Table B , which is manually assigned
once a month. The Class code is unique and can only be selected once.

I've make a dropdown box in Table A [class code], sources from Table B.

How can i make the select the class code from Table B and once i selected,
it can not be selected again ?? or i the record will be disable
Click to expand...
(unable
to
be selected again)


Thanks
Eric
Click to expand...
Click to expand...
Click to expand...
 
M

MaChii

Received, but what your question for not working?

MaChii

Eric said:
Ma chii..

As per your advised

Eric


"MaChii" <[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
I guess you need to zip it first, not able to get the attachment due to
security.

MaChii

Eric said:
Machii

See the result .. it does not work

Can you take a look and advise..





"Eric" <[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
Machii..

Thanks.. can i send you the form ... in attachment

Eric


"MaChii" <[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
Lock the [Class_code] in Table A for "On Change" event, i.e.

Private Sub Class_code_Change()
[Class_code].Locked = True
End Sub

Then after you have changed the class code, the field will be locked
and
not
able to change again. But the problem is, if you have selected a wrong
class code, then you will not able to change it. You will need to
re-open
the form again. For me, I will add a trick (emergency exit), e.g. when
double click the field then will unlock it for change again.

MaChii

Can anyone help me with this

I've 2 tables , Table A is the master table i need to work on this
table
and
Table B is just to supply me with the pre-assigned Class code

Table A - [Class code] & [Student number]
Table B - [Class code]


I need to get the [class code] from Table B , which is manually
assigned
once a month. The Class code is unique and can only be selected once.

I've make a dropdown box in Table A [class code], sources from Table
B.

How can i make the select the class code from Table B and once i
selected,
it can not be selected again ?? or i the record will be disable
(unable
to
be selected again)


Thanks
Eric
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

MaChii said:
I guess you need to zip it first, not able to get the attachment due to
security.

MaChii

Eric said:
Machii

See the result .. it does not work

Can you take a look and advise..





Eric said:
Machii..

Thanks.. can i send you the form ... in attachment

Eric


"MaChii" <[email protected]> ¦b¶l¥ó ¤¤¼¶¼g...
Lock the [Class_code] in Table A for "On Change" event, i.e.

Private Sub Class_code_Change()
[Class_code].Locked = True
End Sub

Then after you have changed the class code, the field will be locked
and
not
able to change again. But the problem is, if you have selected a wrong
class code, then you will not able to change it. You will need to re-open
the form again. For me, I will add a trick (emergency exit), e.g. when
double click the field then will unlock it for change again.

MaChii

Can anyone help me with this

I've 2 tables , Table A is the master table i need to work on this table
and
Table B is just to supply me with the pre-assigned Class code

Table A - [Class code] & [Student number]
Table B - [Class code]


I need to get the [class code] from Table B , which is manually
assigned
once a month. The Class code is unique and can only be selected once.

I've make a dropdown box in Table A [class code], sources from
Click to expand...
Table
B.
How can i make the select the class code from Table B and once i
selected,
it can not be selected again ?? or i the record will be disable (unable
to
be selected again)


Thanks
Eric
Click to expand...
Click to expand...
Click to expand...
 
D

del

please can someone help im desperate.I need help with a mos dos error it
appears my system is running 16 bit and i cant run any applications is there
anything i can do.I currently have a new dell system with win xp sp2
installed.
MaChii said:
Lock the [Class_code] in Table A for "On Change" event, i.e.

Private Sub Class_code_Change()
[Class_code].Locked = True
End Sub

Then after you have changed the class code, the field will be locked and
not able to change again. But the problem is, if you have selected a
wrong class code, then you will not able to change it. You will need to
re-open the form again. For me, I will add a trick (emergency exit), e.g.
when double click the field then will unlock it for change again.

MaChii

Eric said:
Can anyone help me with this

I've 2 tables , Table A is the master table i need to work on this table
and
Table B is just to supply me with the pre-assigned Class code

Table A - [Class code] & [Student number]
Table B - [Class code]


I need to get the [class code] from Table B , which is manually assigned
once a month. The Class code is unique and can only be selected once.

I've make a dropdown box in Table A [class code], sources from Table B.

How can i make the select the class code from Table B and once i
selected,
it can not be selected again ?? or i the record will be disable (unable
to
be selected again)


Thanks
Eric
Click to expand...
Click to expand...
 
L

Larry Linson

del said:
please can someone help im desperate.I need help with a mos dos error it
appears my system is running 16 bit and i cant run any applications is there
anything i can do.I currently have a new dell system with win xp sp2
installed.
Click to expand...

Almost certainly, you will stand a better chance of getting an answer if you
put a NEW post (starting its own thread) in a newsgroup for Windows XP.

Absolutely certain are:
(1) This newsgroup is devoted to Microsoft
Access database software, not Windows
issues
and
(2) It was only happenstance that i happened
to notice this post, hidden away near the
end of a thread about "Subforms" in Access.

For good suggestions on use of newsgroups (not _limited_ to Access
newsgroups), see http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP
 
Top