Search results

Great - next step That's great, but what the form format does not allow me to do is view past invoices. I am happy to pull this via a query, but what I need to be able to do is indicate when invoices have been paid, and subsequently chase unpaid invoices. If I calculate invoice total in the...

Thought I had sorted this, but now experiencing another problem. I am creating invoices from my db, invoices may have more than one line. So I have set up a form with client name, invoice number, invoice date on the main part of the form, then the invoice lines as a sub form. The two parts...

Well, did it just as you suggest, and it was a lot easier than what i had been trying to do, so many thanks!

I want to be able to produce invoices from my client database, and be able to have more than one item on an invoice. Probably best I attach the db. frmLayClientDetails is the main form with a sub form where I want to display a summary of that client's invoicing. A button on the form footer...

Thanks Rural Guy. I actually do appreciate your comments!! And have taken them on board. And to think I have spent so much time on this! I have learned quite a lot from this litle exercise, and I'm sure I'll be back! Many thanks.

Thanks for your help so far. I have attached db. I have had to delete live data and one or two tables to get the size down. Please look aat frmMemberDetails. On page 1 (Member Details) the user completes basic data, then clicks to page 2 (Addresses) I want the company name to drop down from...

I put a "Save" command button on the first page, because I figured the record had not been saved, but this makes no difference. Sorry, not sure what you mean by examine the code, it is against the GotFocus property.

Well, I'm a bit closer - first time I click on page 2, it is not in the combo box list, if I click back to page 1 tab, then page 2 again, it's there! So looks to me it's doing the requery, but not at the right time(?) Any ideas?

I've been trying to apply a requery, but still can't get desired result. My db structure: I have an input form with 4 tabbed pages. First page of form is for entering basic details of a client. Second page goes into more detail. At top of second page, I have converted text box into a combo...

No, this still did not work, I have tried all manner of combinations. I must have something else wrong somewhere.

Still nor working. Sorry for appearing a thickie! Does this go against the combo box itself on the second page, or against the text box on the first page where the client name is first entered? Do I need to name the combo box/text box in the statement? Help appreciated.

A user yesterday informed me I need a me.requery. I have a form with tabbed pages. First page I complete details of clients - second page goes into more detail. On second page I have a combo box listing all clients in alpha order. I want to get the new client I have just completd on first page...

I've tried putting this in various areas, but I am not getting the desired result. Can someone tell me where I should put this code?

Well I have been just selecting the tab, not aware of what I really needed to do. Can you give me a bit more detail please?

I have a form with four tabbed pages. First form is where data is filled with some basic new client details. Second page contains more detailed info, this starts with a combo box of company names that have been completed on first page. However, I find I have to close the form and re-open...

I created a db, tested it with dummy info and all was fine. I then imported live data from another db. When I came to add new records, discovered that, in the table design, a default value of 0 (zero) has been entered for fields where a look up table is used (where I had used Autonumber for...

I've looked through the forum, but not been able to find answer. I have code in a form that will open up new Outlook email to a contact, but I now want to be able to put the autosignature on the email. Any help appreciated.

A bit further on in the query OK, made a start. I have calculated the review dates in the qry. But for the purpose of the report, I effectly need to make the qry a parameter qry, so it only pulls off clients due for review in the coming month. I think I should also show where it is a first...

A bit further on in the qry OK, made a start. I have calculated the review dates in the qry. But for the purpose of the report, I effectly need to make the qry a parameter qry, so it only pulls off clients due for review in the coming month. I think I should also show where it is a first...

In a customer enquiry form I have a field with "date order fulfilled". Below this I have three unbound fields that use the DateAdd function to automatically fill a review date 3, 6 and 9 months after the order fufilled date. I have now been asked to create a query and monthly report that show...