Search results

Great - done it - thanks very much!

In a database that holds membership records, I have three years worth of info relating to membership dues paid. I want to extract who has not paid a membership fee for the last three years, so we can strike them off our records, i.e. I have members' personal details, but there are no records in...

My db is currently set up like this: tblMemberDetails - contains personal info tblAddresses - holds company address details/phone/email and home address details/phone/email We now want to restructure our membership to include corporate membership, i.e. one company may have several employes who...

OK, hope this helps. I have the following tables: MembershipDetails - containing personal details, join date, status, etc. Addresses - home and company addresses Payments - a record of payments made, how much, when, who by (self or company) MembershipStatus - a look up table Regions - a look...

I have put together a membership db for the company where I work. It has about 2000 individual members; members have different membership status, eg student, fellow, etc. They pay different amounts according to their status. Membership has been renewable annually In January – this meant that...

I did not have the solicitorID on the form because I guessed you could refer to it (and that was really the bit I was not sure about!!) but I have put it on the main form (rather than the sub form) as a combo box and put it in as a field in tblInvoices - though this is duplication isn't it...

I am using this bit of code, but I am sure I am missing other coding. This is what I have currently: Private Sub Print_Click() On Error GoTo Err_Print_Click Dim stInvPriv Dim stInvLocum stInvPriv = "rptInvoicePrivateClients" stInvLocum = "rptInvoiceLocumWork" If...

No, this doesn't work. Don't I have to declare a variable? This is the bit that I am not sure of.

I started a thread on this yesterday, but realised I was some way off achieving what I want, so am starting a new thread. Have attached copy of my db. What I want to achieve is this: From frmLayClientDetails click on the cmd button See invoice details, then click on the cmd button Preview this...

This could go in forms or reports, I think but: I have a database which I am developing over time as I see ways of improving it and as I learn bits of vba. My current problem relates to invoicing (that I have probably created for myself!): I currently have two invoice report layouts because...

I have created my first website using FrontPage2003. I used layout tables for placement of text and pictures and put a coloured border on the outside of each cell, but this border does not print. Why is this, or how do I get it to print?

Knew it had got to be something simple - many thanks

I have created an invoice, pulling the data together from three tables with a query. The business is now registered for Value Added Tax. I have added a text box in the page footer of the invoice with the following expression: =IIf([InvoiceDate]>31/7/2006,"Vat @ 17.5%"," ") So that the...

I'm working on a db for a colleague. It is a databse of clients, some with whom he works directly (PrivateClients) and some through other agencies (LocumClients). I have a list of locum clients with their addresses in a lookup table and in the main client form purely select the agency via a...

I've looked through the forum but haven't found quite what I want. I am a novice but realise this is going to be a relatively simple one .... I use an invoice form for my own business with client details and a sub form with invoice lines. The client is selected via a combo box. I realise the...

Brilliant - thanks. . I have done it both ways and got the same results, however, the db will be large in due course (well, hopefully) so will rely on the unmatched query (never thought of that!) Many thanks

I am using a database that holds (amongst other things) payments received from a membership. This info is held in tblPayments. When payments are received I enter a new record against the membership number and in a field named PdForYr I enter the year for which they are paying, i.e. current...

Doh!! Cheers for the reminder - just needed a prompt!

Like you say, the page footer placement doesn't move, this would be great but it comes too far down on my headed paper. ??

I have produced an invoice as a report. Invoices may have several lines; I have a text box in a group footer calculating the invoice total. The invoice is to be printed on headed paper, so the total amount must always print in the same location. However, when there are a number of invoice...