Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jp1
  • Order by date
  1. jp1

    Field which can store 1000 words.

    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...
  2. jp1

    Restricting Multi-Users in tables

    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...
  3. jp1

    No Multi-users but MSJet says that someone else is using the file??!!

    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...
  4. jp1

    No Multi-users but MSJet says that someone else is using the file??!!

    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...
  5. jp1

    Finding records

    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...
  6. jp1

    Stop number rounding in numeric fields?

    vandys - gosh, what can i say - you're right everything is now accurate.&nbsp;&nbsp;Thanks a bunch for the small pointer.&nbsp;&nbsp;My boss thinks I am worth my weight in oatmeal.&nbsp;&nbsp;<br><br>thanks again<br>jp1
  7. jp1

    Stop number rounding in numeric fields?

    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).&nbsp;&nbsp;&nbsp;What am I doing wrong?&nbsp;&nbsp;The guys that are getting paid by these changes (an...

Part and Inventory Search

Back
Top