Search results

Through great help from this forum I now have a working order form/report that looks great. I would like to get some ideas on advancing the report. I'm looking into doing a check box or list box and also have looked at info on wherecondition but just not sure which would be the best and simplest...

I want to thank everyone for your input on this one. When I can't figure out or find the answer this is where I come. AI couldn't even do it. This forum rules!

Thanks Gasman. Not sure if you saw post from xavier.batlle but his one line of code did the trick in every way. Put it in and see the results you get on the invoice, yes, report!

One simple line of code! I've received complete overhaul of vba from some. 🥸 It is to my exact image of what I was looking for. Notes about the billing go on the invoice under hours, minutes, starttime and endtime and if I do add a product notes for that go under the product. You are the Master...

Yes, I did start with his template. I actually ran this by him and he said this was kind of the way of Access. He gave me a way to force that the next record had to be filled before notes could be accessed but as I replied to Mark there will be times that the only charge will be the Hourly...

Thanks Mark, nice reply. The only thing about the notes is sometimes the only thing I want to bill for is the Hourly Billing but I need to add notes about the hourly billing. This is why I go straight to notes when the order form opens. Not sure if you went further but if you click on Invoice...

Here is a copy of the database. Sequence to get to issue. MainMenu, click on Customer Form, then in Customer form click on Timesheet. Create starttime and endtime then click on Create Invoice. Once you are on Order Form you'll see the Hourly Billing record for whatever time you created. Go to...

OK, I've noticed that if I go ahead and add product to the second record and then type something into notes it does not auto populate the third record line. It's like the first record, hourly billing, is ignored because it is created by another form that opens the order form so I guess the...

It is a subform within a form. I click the notes section to begin typing by use of the mouse. I've never tried tabbing over. Anything typed in the notes section is added to the invoice along with whatever product records are visible. This is why I have to delete the $0.00 record because it shows...

No, this is not what I want to do. Before I type anything into the notes the only record is the hourly billing record which is all I want. Typing in the notes section is what creates the blank $0.00 record line. I used to work with Access in the late 90's but not since. Just now getting back...

Want to see if anyone has any ideas on this. I have an order form with a products record table (see photo). The Hourly Billing record is produced by another form that opens the order form (photo). My issue is when I go to type something in the notes section as I did in photo, the second record...

After I typed my statement above and read it back, "anything to do with numbers" I thought except date/time fields so I did a Me.Recalc on them and now it is working. Thanks to everyone for all the ideas, making my head spin and finally helping to make it work.

Everything I read about recalc says I need to sub my total min field., duration field, top line data section as after update event with Me.Recalc. Dosen't work. I did a me.recalc on every field that has anything to do with numbers and totals and still doesn't work?

When I try either one of those compile gives me "Message or data member not found" and flags ReCalc in blue. I have been reading about ReCalc. I also tried without the Me and retried Requery using Me because I don't think I had tried using Me with the Requery. Still, could not get anything to work.

Gasman, can you maybe load your vba for the CalcTotal sub.

Thanks arnelgp. Requery is what I have been looking at and trying but was not sure exactly how to implement. I tried your code with 3 or 4 variations of textbox names but could not get anything to work. The actual textbox names are SumTotalMinutes, and SumDuration. Even tried it in Forms After...

Hi all, Wanted to see if I could get some help with this. As you can see in photo I have date/time totals which provide footer totals. I am using basic math in the form query to get these footer totals. Expressions listed. This is all working correctly giving me all correct totals. The problem...

Got it figured out. Your comment got me started on the right path. I tried not using individual fields but with the way I have the query configured using a definite source for company/name, I couldn't get it to work. So I tried using concatenation for just that field but couldn't get it to work...

Only Co name shows if no person and vise versa. The above is using all three.

This is what I am thinking about now. Only problem is if I don't use Co name there is a blank space between persons name and address. Is there a way to get around that.