Search results for query: *

I only used this for the report. The form uses subforms to save the numbered data in related tables, related by a customer ID. So, the person putting in the info sees the subform as part of the main form with it's own record numbering (so for each customer record showing on a form, there could...

I had to do the extra math because I had not added the new subforms correctly! I'll publish my error for anyone that's using this thread for their own solution. I noticed that my new form was not linked correctly to my main form by "Link Child Fields" and "Link Master Fields," which were both...

Jeez, that was easy! Only thing that took me a minute was that I couldn't just copy/paste your code directly into the On Format field properties box - I got a missing macro error. I had to launch "Code Builder" and once in the Visual Basic window I added the code there and then it ran...

Just when I thought I was done! Now my client says that he only wants the first 3 related records where I have them in this subreport. Any overflow should go to a new page (A footer on the main report would work fine, I think, I might need to add a page break or something at the end of the...

Excellent!! Worked great after a tiny change. Control Source: ="Mortgage (" & txtRunSum & ")" I added the "=" when it didn't work, but then it worked like a charm! Thanks for the wonderful and speedy assistance, dhookom!

Yeah, I'm really looking to number related records. So regardless of it's position in the related table, if a record is the 1st record for Client #49, it should be marked (1). The next record for that client would be (2). Just to explain myself, what I was clumsily referring to as a "record...

Hi, I've found tons of great help here at tek-tips by looking at FAQs and searching the other postings, but can't find one that will help me with this issue. Apologies if I'm re-posting this one! I have a main table with customer records and a couple of other tables with data associated on...

I was having the same problem, and figured out the solution while looking for an answer here at Tek-tips. My error was when I created the table, I set the date field Data Type as "Text." Changed the Data Type to Date/Time and the format code works fine. In the properties of the Date...