Search results for query: *

PHV & Fneily Thanks for the reply. Below are the file definitions. Leej1 I hope this is the way you want me to post the file definisions C:\Users\leejp\Crihist\Test\Access-Payroll-Enter.mdb Wednesday, April 30, 2008 Table: Master Correction Table...

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

Thanks again for all your help. It seems to me that the file is advancing past the last record, because the instruction If rec.Fields("qsoc no") = soc Then is the line that gives me the error (No Current Record). I used your code and the error came up at the same line of code Thanks for...

Thanks all for your replys. I am trying to create a grouping field for a report that must have 30 lines on each page. There can be more than 30 record because of duplicate soc no. The data looks good, and the results of the codes creates the groups the way it should. Thanks

Thank jadams0173 for the quick reply. Neither seems to work. I get a no currect record error on the instruction after the rec.movenext

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

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

I get a syntax error when entering your susgestion. Thank you

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

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

Sorry I forgot to insert the type of error. The error is validation rule violations. Hope This helps to define the problem. There is a primary key made up of two fields and an auto number, if this helps. Thanks For you reply.

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