HI, I first want to say thanks to this forum and its users, such a great resource!
I am currently having an issue with entering null data into a linked SQL table via a form. Not all null data has an issue just certain fields that have conditions as assigned in SQL.
The fields are populated by autofilling from a query of an Access table whos values based on values from SQL domain tables. When the first record is entered, the other fields are filled from an query using the method described by Maximus in a recent post. The fields populate fine for field in which there is dataand where there are null values in the query fields are not filled. When I try to complete a record in which the query populates a field with no data, from the query based on the Access table, I get the following error:
Here's the real annoying part but a clue. If I put a space in each box with null data I don't get this error and I can proceed to the next record. Also, for records autofilled by the query that do not have any null values they are entered fine without error.Could not execute query; could not find linked table.
[Microsoft][SQL Native Client 10.0][SQL Server]FieldInQuestion (#0)[Microsoft][SQL Native Client 10.0][SQL Server]NextFieldInQuestion (#0)[Microsoft][SQL Native Client 10.0][SQL Server]NextFieldInQuestion (#0)[SQL Native Client 10.0][SQL Server]NextFieldInQuestion (#0)[SQL Native Client 10.0][SQL Server]NextFieldInQuestion (#0)[SQL Server]Invalid object name 'ReT13' (#208)
It seems that the problem is coming from the way that access is entering null values from the form into the SQL table. I have tried the following:
1.Changed the Allow Zero Length to NO in the Access table that values are entered to SQL from.
2.Adding a table in SQL that is has the assembled domain values and queried from that table linked back to Access in the same way I queried the original Access table.
3.Setting default values to space and an "&" in the input mask property for each field that is giving me trouble.
4.Other things I can't remember
Same error each time!
I think it has to do with how access enters null values from the form and not how it queries the info from the table. I'm almost completely stumped here. Let me know if anyone has an tips, insights, or resources or if anyone has any questions.
Thanks!