Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi I am facing a strange problem.
When I insert a record from VB.net code to MS Access 2010, the record gets inserted. But when I open the Access database I find that the first field is not showing the value. But I know that the value is recorded but just not visible (By entering a character of the value in search textbox, it will be visible but again vanishes when cursor is moved out)
VLPatil
Posted

No, it's not possible. A value you inserted in database will/should be available in the database table. If I am not wrong, your record(which you are trying to insert) is not getting inserted in database.
PatilVL Wrote:
By entering a character of the value in search textbox, it will be visible but again vanishes when cursor is moved out

This is just because of browser cache.

You MUST debug your code, and find the root cause for the error.

--Amit
 
Share this answer
 
Comments
PatilVL 27-Aug-13 2:43am    
No Amit. If that was case I would not have posted it. The thing is the field which is not visible is primary key. So the record would not have been added in first place. Anyway when I search that value it is there. But soon I take mouse the value disappears.
That is why I posted this!!
This was a silly mistake.
In vb code the character vbcrlf was added (in the beginning of the string in some place to the text string which was inserted into field. (If I wanted to stored a string Mystring, I was sending vbcrlf & Mystring). Thus the sting stored was not at all visible!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900