Form w/ subform & SQL Server

  • Thread starter Thread starter Scott Lindsey
  • Start date Start date
S

Scott Lindsey

I have a form that has a subform on it. The subform does a lookup of a
product description on the product master based on the item number field in
the main form. When all of the tables were in Access, everything worked
fine. If an item was not on the product master, then the fields on the
subform were blank and the labels for the fields appeared on the subform. I
moved the tables to SQL Server. Now when the subform encounters an item not
on the product master, the entire subform labels, fields and scroll bars are
"gray". I know that this is because the row does not exist on the SQL
Server tables.

Why does this act differently between Access tables and SQL Server tables.
Is there anyway that I can fix this so the subform when pointing to SQL
Server acts the same as when pointing to Access?

Thanks in advance for your help!
Scott Lindsey
Highlights for Children
 
Hi Scott,

Thanks for your post. Based on your description, I understand that you want
to compare the behavior of blank fields under the two circumstances (the
underlying tables are in Access / SQL Server). However, I am not quite
clear about the symptoms of this behavior on both sides (Access and SQL
Server). I would like you to provide more information so that I can fully
understand what your concerns are.

1. Is the product master a table? How many controls are there on the main
form and subform? What are they? Please describe them in detail

2. It would be appreciated if you could provide two screenshots to help
describe the action in both situations (the underlying tables are in Access
and SQL Server). To obtain the screenshots, please refer to [Item 1]. You
can send the screen shots to me at (e-mail address removed)

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.
 
Hi Scott,

Please perform the following steps to obtain the screen shot.

[Item 1]

Try to obtain the screen shot of the behavior.

Please perform the following steps to capture the screen shot of behavior
on both circumstances.

1. Press the "Pr Scrn" button on the keyboard.
2. Run the Paint tools (Start'All programs'Accessories'Paint).
3. Press Ctrl+V to copy the screen shot from the memory.
4. Save as a JPEG file.

Thanks for using MSDN newsgroup.


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.
 
Hi Scott,

Thanks for your feedback and screen shots. According to your screen shots,
I understand that the Item Data is a subform on the main form called
"Operations Purchase Log". Your concern is that the screen of the "Item
Data" subform is different in adp database when there is no records in the
subform. If I have misunderstood, please feel free to let me know.

This behavior of Access is strange. Based on the screen shots, I performed
the following steps to try reproducing this problem (Access 2000 format
using Access 2003 + SQL Server 2000 SP3)

a. Create a new Access database (.mdb).
b. Create two underlying tables (undermain & undersub). Their relationship
is one-many.
c. Create a form named "underform" including a subform named "undersub".
d. Test.
e. Upsizing to SQL Server 2000 SP3.
f. Test.

I performed the test you described and test the same behavior again after
upsizing this .mdb database. Unfortunately, the results of the two tests
are the same. It seems that I am unable to reproduce the problem you
mentioned successfully.

I will send the test .mdb database to you. You can upsize this .mdb
database to .adp database to see if the problematic action you described
can be reproduced. Also, I will send a screen shot of the test result of
the .adp database to help describe the action on my side. I will send an
email with the attachments (AccessIssue.zip) to you.

In addition, please let me know what the software environment is on your
side. (Access version, Access format, Version, Edition and Service Pack of
SQL Server)

To obtain the version of SQL Server (Service Pack), please refer to the
following article.
321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
http://support.microsoft.com/?id=321185

Lastly, such issues tend to be complex and take up extensive research time.
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 to
troubleshoot this further. If you need any help in this regard, please let
me know.

Thanks for using MSDN newsgroup.

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.
 
Back
Top