Search results

Hi there, I'm having some issues formatting a mail merge field in Word 2003. Using an Excel spreadsheet as datasource. The data in the field in question looks like this: 633597032004B7 I want just the last 8 characters. Now i tried using { MERGEFIELD ISAM_ID_633597 \# "x#######" } However the...

Hi there, I'm trying to do a new membership database for a local group who take monetary subscriptions. Basically, there's a form for creating a new member, with a few tabs - Contact Info, Payment Info, and one other. Basically, in the payment tab, i've got a dropo down box to select the...

Hi there, I'm working on my A2 IT Access project atm, and my aim is to produce a fully functional db for use by a golf course, incorporating membership information and tee-time reservation system. I've got the membership side pretty much sorted, so now I need to start work on the reservation...

Hey there, I want to store a "calculated" value from a form text-box. By calculated, i simply mean that it is a textbox that contains the following Data: =[MemberFirstName] & [MemberLastName] Basically, the field is the Members Username, the text box is called "Username" and it needs to be...

Hi, im not entirely sure where this belongs - could be tables, reports or VBA - so im guna post it here. Right, heres the situation. I have a form containg two sub-forms. The main form is used to input/check order details - name & order date. The first sub-form - sfrmPond is used to input the...

Hi, I have a diff prob this time. In the attached database, the main form contains a generated list of itenary according to the dimensions input at the top of the form. What i cant work out is how to transfer that list into a invoice report that can be printed. The problem is that the list is...

Hi There, I have a problem and i need some help. I have recently started a project at school to design a membership database for a small golf-course, which contains all the info about all the clubs members; name, address, tele#, mem type, join date, ccard #, etc. The database was originally...

Hi This is my first ever Access database, and i was wondering what u ppl thought of it. I desinged the database for a school project, and i feel it is nearly finished. As u can see, the database is a stock list for a garden centre, with the ability to search the stock list for plants that fit a...

Hi I'm not really sure which section this fits into, so i am going to post it here. I am currently doing a school project, which requires me to design a Excel style spreadsheet, to calculate the costing of a complete pond kit, to the dimensions the customer specifies, then produce an invoice...

Hi I'm new to this Access lark, and i have a limited knoweledge of MS Access. I am currently doing a school project, which involves me designing an Access Database for a garden centre. this garden centre needs to be able to produce reports containing plants that fit certain user defined...