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!

Register Log in
  • Congratulations bkrike 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: leej1
  • Content: Threads
  • Order by date
  1. leej1

    Add New Record to Tables that have a one to one relationship

    Hi I have 2 table that are in a one to one relationship. The reason that the info is not in one table is because the number of fields exceed the 255 field capacity. Using a form how can I add New Records without getting errors because of the relationship. Thanks for any Help. Leej
  2. leej1

    Exit Do --- Not Exiting

    Hi Having trouble with the following code. On the last record of the file I get an error, because the Exit Do statement doesn't seem to be working. Excuse the code it might not be the most effective way to write it, but the results are good. Thanks Dim db As Database Dim rec As Recordset Dim...
  3. leej1

    Testing for zero

    Hi This should be very easy, but I can't seem to solve the problem. I have a form with controls from a table defined as Currency (2) dec., which I perform a function to get an answer for a control from a table also defined as Currency (2) dec. I test the answer for zero. The control on the...
  4. leej1

    Print Space instead of decimal on pre printed form

    Hi I have a pre printed form with decimals printed on the form. I want to print a space where decimal is in a fixed 2 decimal control. ex 12345.56 12345 56 Sounds simple, but have trouble solving. Thanks leej1
  5. leej1

    Update Query

    Hi Having trouble updating the sum of the number of groups into a one record table. Ex multiple social security numbers in a table with duplicates. I want to know how many groups, and update the total groups to a one record table. ex soc no 111-11-1111 111-11-1111 222-22-2222 2...
  6. leej1

    Append Query Validation Rule Errors

    How can I determine what field in my table is causing the validation error in an Append query? Thanks

Part and Inventory Search

Back
Top