Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Linked SQL tabl...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 30429 of 31576
Post > Topic >>

Linked SQL tables/popup form problem

by EManning <manning_news@[EMAIL PROTECTED] > Jun 2, 2008 at 10:09 AM

I have an A2003 database linked to SQL Server 2005.  My problem is
with a popup form with a filtered table as a recordsource.  I set the
filter with an SQL statement like this:

SELECT * FROM tblMedicalTraits WHERE SystemID = " & CLng(Me.OpenArgs)
Me.RecordSource = strSQL

This opens the popup form just fine when there are records that meet
the filter.  If there are no records, then the popup displays 2
"blank" records.  What I expect to see is one blank record.  It's
almost like there is already a record out there but it's blank.  (This
could be better explained if I could attach a screen-shot of what I'm
seeing.)  If I try to close the popup without entering anything, I get
an error message that a null cannot be inserted into a field in
tblMedicalTraits.  It's referring to the SystemID column in
tblMedicalTraits.

This does not happen if there are records already in the table that
meet the filter criteria.  I can enter/edit/delete records just fine.
It happens only when there are no records.

tblMedicalTraits has an IDENTITY field in it so that it will link
correctly to the mdb.  It also has a TIMESTAMP field in it to avoid
any write conflicts that these types of databases sometimes get.  I
tried removing both thinking that one of them was causing this
problem.  But if I remove the IDENTITY field, I just get a popup form
with no fields on it at all, just the outline of the form

Has anybody had this problem?  If so, what did you do to correct it?
Thanks for any help or advice.
 




 8 Posts in Topic:
Linked SQL tables/popup form problem
EManning <manning_news  2008-06-02 10:09:53 
Re: Linked SQL tables/popup form problem
Rich P <rpng123@[EMAIL  2008-06-02 13:40:31 
Re: Linked SQL tables/popup form problem
EManning <manning_news  2008-06-02 11:49:33 
Re: Linked SQL tables/popup form problem
Rich P <rpng123@[EMAIL  2008-06-02 14:42:30 
Re: Linked SQL tables/popup form problem
EManning <manning_news  2008-06-02 13:37:45 
Re: Linked SQL tables/popup form problem
Rich P <rpng123@[EMAIL  2008-06-02 18:25:29 
Re: Linked SQL tables/popup form problem
EManning <manning_news  2008-06-03 06:43:58 
Re: Linked SQL tables/popup form problem
lyle fairfield <lyle.f  2008-06-02 15:44:16 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:20:26 CST 2008.