I will add a word of caution about memo fields. I had a situation in which my database became corrupted due to an error in a memo field and the only way I could correct it was through a call to Microsoft Access support. They told me that when a memo field gets damaged, the main indication is...
This is a general question that may have been answered previously, but, I have 8 users in my Access Database. I can split my tables so that only 2 users have access to a table and thereby limit the errors encountered when the records are locked. I do have 2 users that need access to all the...
for those of you who could not help, I have found my problem on my own. I will divulge the secret just in case someone else has the problem. It all stemmed from a corrupted memo field. I had to open the table, hand write all of the other info to re-enter later...
I have a backend db that I have copied to my laptop for development and upgrades. When trying to make a copy of the main table, or even to export to another file, the process stops and tells me that another user is trying to access the same record. I even went so far as to...
I use a combo box at the bottom of my form that will list 3 columns, ssn;fname;lname and have the control bound to column 1 (ssn). This then retrieves the record that I want to update. I have found that the most effective method of dealing with ssn information (possibly...
vandys - gosh, what can i say - you're right everything is now accurate. Thanks a bunch for the small pointer. My boss thinks I am worth my weight in oatmeal. <br><br>thanks again<br>jp1
I am entering 2 decimal place numbers (5.50) in a numeric field with the format set to fixed (3456.78) yet the values that appear in the table are immediately rounded up (5.50 becomes 6.00). What am I doing wrong? The guys that are getting paid by these changes (an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.