Search results

Right? Dont follow.... Cheers Gavin

Hi there, Cheers for that info... Does seem to work... just need to work out how to put it together now... If i try \# "x#####??", it gives me "032004??" - right length, got ?'s though... If i try \# "x???????", it gives me "4???????". Trying \? "x???????", it gives me "633597032004B7"...

Ok. Anyone else? Cheers Gavin

Yeh, i thought it'd be something like that. Is there just a character input option? Cheers Gav

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

Cmon ppl - one of u must be able to help.

Right, lets get going then :) I've changed the table layout slightly, so that the bookings are made by date & time, rather than having to generate a slot number. I've also started designing the input forms, and queries behind them. I've got one query which will pull all the bookings for a...

Ok, i've got plenty of time to get on with this now, so anybody got any ideas? Cheers Fatmcgav

Right, lets get on Ok, so i've just started to work again on this. I've started to model everything in Visio, so that i know wats going on etc. Attached is a copy of the current Database Layout Diagram, showing everything that i feel is relevant to the Slot Reservation System - i've got the...

Right, where abouts does this go, as i tried putting it in the afterupdate property of the drop-down box, and it doesnt seem to work. Any help appreicated. Cheers Gavin

Ok, just managed to get back to work on this. I've managed to hide and unhide the whole TabControl, but i cant find out to show individual pages. Eg: There is a drop-down box on the form called page, which has the AfterUpdate property set to change the tabcontrol. I can show the entire...

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

Ya wat??? :o :( *Runs off to google * Any more info?

Ok, so i want it to be able to: Booking facilities: View bookings by date - pop-up calendar facility already in db - see here Make bookings by double-clicking on a time slot - pop-up form to complete booking info(booking member number, party size) Be able to amend a booking by double clicking...

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

Thanks for the reply Pat I think I get roughly where you're coming from, but some of it i havent go a clue, dam my Access noobiness. i am actually designing the database for a GCSE ICT coursework project. All that i need to be able to do is enter a Width, Length and Depth, then click a button...

Any ideas ppl????

Anybody got any ideas? Come on guys, ure usually brillant at dispencing the solutions. Thanks

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