Recent content by Bentleybelle

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...