Search results

I am putting it in the subform footer...the IIF statement is there as well...should I bring it out into the main form footer?

That's still giving me an error and causing the quote and billing totals to error as well although they worked before.

I have a form what pulls quotes and approvals, etc for jobs. Across the screen it has quote, approved by, approval date & approval amount. So....it may have 6 or 7 rows for each service we do and they will ALL have an approval amount however, there will only be 1 or 2 out of the list with an...

I need to figure out how to pop-up a warning form. After the dispo date is filled in and the customer is a certain customer but the paperwork completed date field is blank I need a warning form to pop-up that says WARNING! DO NOT SHIP THIS CAR PAPERWORK NOT COMPLETE!!! Is there anyway to do...

You mean an ID? Yes - I do.

I am trying to create a running sum for a checkbook register and I have searched, read, downloaded samples and I'l still at a loss. Do I create an unbound textbox on the form? What do I put in it? A running sum for Credit-Debit? Can anyone help? Thanks!

Thanks! So do I create an unbound text box that = the debit field and then put that in the after update function?

I am trying to make a form to enter checks into a database. How do I put a control box on the form so that I can key the amount into the appopriate field such as $9.99 and have it display something like nine dollars & 99/100********************* ? Thanks for any help! Dianne

Thanks, I'll go check. Did I set them up wrong? It was they only way I could think to do it b/c some scouts (IE - me) are in more than 1 troop/position.

From the switchboard, click reports then registration summary. If you click 2004-2005 and troop 8092 (not 8029) it will come up and the print checkbox won't work.

I am having some problems with a query. I am trying to develop a database for our Girl Scout Service Unit to handle troop registrations. Registrations are not always turned in at the same time. For example, I just sent in 16 of them but I may get 4 next October. I created a Membership...

Thanks a bunch! They're gonna LOVE me for this one! Major Brownie points (no pun intended) *hugs*

Thanks! I'll get right on it! Can I ask an unrelated question? I'm working on a small side DB for my Girl Scout Service Unit to handle membership registration so of course I have a combo box to select Brownie, Junior, Cadette or Senior. In a query, how do I have it do a total count based on...

Cause I've played with both til I could pull my hair out.

Thank you for the reference however, back in January when I was pointed to it, I DID download the latest sample and have been trying like heck all this time to get it to work, it is EXACTLY what I have been using. The sample takes the members and the date and creates an attendance record. I...

Thanks all...tried both, can't get it. I think maybe I'm just gonna give up and have to enter 30+ cards for each holiday. I'm just about in tears over this. My boss has been on me and I have no access training or a whole lot of knowledge so this is so far above my head it isn't even funny...

Please help... I have been trying and trying and TRYING to get this form to work. I am trying to update employee time & holiday hours using a multi select box and the code ya'll have been so kind to help me with here but I just can't seem to get it...part of the code isn't working. I've been...

Worked like a charm! THANKS A BUNCH!

I have an employee timecard form with a tabbed control. One tab is the daily hours and the other is for entering expenses. When I click NEW (add record), I want it to default back to the 1st tab (Hours). I'm sure I need to add something to the onclick event but I'm not sure what because of...

Thanks so much! Half the battle is learning what to search for isn't it? *off to search the forums*