Access 2000 SubForm in Access 2002

[Tom L]

I have a Access 2000 project using a SQL database that I had been using with
Access 2000 with no problems. We have just started deploying Access 2002
and it seems that in 2002 the text box controls on a subform will not accept
data. The form appears to be modified but when I type, nothing appears in
the field. I converted the .adp file to 2002 format but I get the same
results.

Any thoughts?

Tom L.

 

[Yuan Shao]

Hi Tom,

Thanks for your post. According to your description, I understand that
there is a form in Access ADP file, which has a subform with a text box
control. You failed to enter anything into the text box using Access 2002.
If I have misunderstood please feel free o let me know.

1. Please make sure that this text box is not bounded to autonumber data
type field.

2. Please make sure the following properties on the data tab of the subform
propery is Yes
a. AllowFilters Property
b. AllowEdits Property
c. AllowDeletions Property
d. AllowAdditions Property

Does it fix your problem? Because this behavior is strange, which I have
never seen before, I would like you to provide more information so that I
can narrow down this issue.

1. Does this problem is control specific? In other words, does the same
problem occur with the other controls in the same subform or the other
controls in the database?

2. Is it database specific? Did the same problem occur in the other Access
database (ADP)?

3. Please try to create a new ADP file connecting to the same database in
SQL Server and import the problematic form. Does the same problem occur
again?

4. When you want to type the value into the text box control, please make
sure you have focused on this text box control and can you see the there is
a cursor in the control? Or is the text box control grayed out?

5. Did any error message occur? If so, please provide the detailed error
message. It is appreciated you can provide a screen shot (JPG) to help
describe this problem.

6. Which data this problematic text box control bounded. Please describe
the text box in detail.

I am looking forward to hearing from you soon. Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Tom L]

Thanks for the help but the problem seems to be elsewhere. After some
testing I found two things.

1) I had a public variable in a module declared as a string which 2000 let
me get away with (despite the fact that the online help warns against it).
Changing the variable to a variant type fixed that.

2) I was setting the value of another control on the subform using the
OnChange event. I stepped through the code and saw when I typed a letter
into text box it showed up but as soon as I set the value of the other
control in VB, the letter I just typed was erased (weird). I switched my
code to the OnDirty event and had no other problems.

 

[Yuan Shao]

Hi Tom,

Thanks for your feedback. It seems that you have fixed this problem via
changing the data type of a variable from string to variant. Based on my
experience, it is hard to find the root cause of this problem only
according to the information. Do you mean that you still want to find it?
If so, please provide the reproduce steps and related information (such as
the segment of codes) so that I can reproduce and perform further research
on my side.

Also, such weird issues tend to be complex and take up extensive research
time to find the root cause. I'd like to set your expectations that it may
take a while for us to help you narrow down the problem and we may
eventually redirect you to PSS to continue working with a dedicated Support
Professional. If this is critical, I'd recommend contacting PSS and opening
a Support incident troubleshoot this further. If you need any help in this
regard, please let me know.

Thanks for posting in community.
Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.