Search results

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

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

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

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

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

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

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

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

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

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

I'm sure this is really easy - the database I am writing is for sales enquires with an anticipated completion date (month), but I also need to show which year. I would then want to concatenate these two fields and be able to produce a report that would list by date in ascending order. Can...