Recent content by Witchity

Oh and questions that women dread men asking them: Do you fancy an early night? Have you seen my glasses? Have you seen my keys? Have you seen my wallet? Where's the cat/butter/marmalade/children? Can I borrow your car? Can you navigate for a bit, I'm not sure of the way here. Which way...

Sorry to come to this late, but this happened to my English husband when on a visit to the States a couple of years ago. American Female: "Does my fanny look big in this?" Just in case you Americans aren't fully conversant with English english 'Fanny' over here means something a little...

Thank you Hayley, by sheer dogged determination and after about three hundred attempts I've got there! Took a while to get used the to code writer, but eventually I managed to do a good enough copy of your friends code to get it working in my database. So Thank You very much!! Well you know...

Well, what we will be doing is using the autonumber feature in Access to create a stock number for parts. They are booked into the database, and when used from stock, the name of the customer who received these parts into their machines is recorded, so that if a warranty issue arises in 3/4...

Thanks for that Rich I tried the combo box, but when this database is fully populated the box will be too big. Still trying to get the other way to work, without success. But we shall NOT BE DEFEATED!!!!:)

Thanks for the tip Casey, it works in so far as it brings up the message box and I can type in a surname (this database is only just starting, which is good - gives me a chance to get it running more smoothly!) and we only have one surname currently in there, BUT if I enter the surname it...

How would I create a query which the user fills in the surname of the customer he is searching the database for, the query finds the record? Also does anybody know why the help files in Access are written in klingon?:D

Murky Buckets as the french say Rich! Thanks for that

Select Max from where? I tried typing Max into the Criteria field and just got an error message saying data incompatible. I've got a dog called Max, but I guess that's not much help! Sorry to be a pain but I'm an Access virgin, and rapidly beginning to realise why!

???????????? Looked up the Max function and just got some about SQL queries - scary! What are they?!!!! Word of one syllable please (I'm blonde!)

How can I set up a query to show the most recent entries in a database? These could typically be a week back from whatever the current date is when the query is run. Hope that makes sense! Thanks:confused:

Well, whadda you know! Opened the database this morning, and it's all working just Dandy!! Maybe it just needed a rest (or more likely the operator did - it was quite late last night whilst all this was going on!) Brilliant!! Many thanks for all your help - I'm off now to play a bit more and...

Back again! Have tried both Casey and Wayne Ryan's solutions now, and keep getting the #name! error message. The field I'm using is called UnitPrice (at least it's a textbox called UnitPrice) and the fields name in the table design view is the same. It's format is currency (for obvious...

Hi, gang, thanks for the tips. I've started with Casey's suggestion, which was going quite well, until I tried to enter data into some empty fields for the UnitPrice field and couldn't! Data which had previously been entered had been calculated correctly, but I couldn't add data? I had...

I want to have fields in an Access tables behave like they would in an Excel spreadsheet. i.e. if someone enters the number 42 into a field called 'units' I would like the next field (called stock) to multiply it by 2 and display 84 automatically. This is needed for approximately 3/4 fields...