Search results

In Excel, under the data menu there should be a Convert to MS Access option. If it's not there, you should be able to add-in by going to help and following the instructions there. If not, your techies should install at least one of the wizards for you otherwise you're not going to be able to...

Sounds like you need to use a query with Group By which will group together records containing the same information. In the query grid enter the fields you wish to display providing they are those which will not contain differing information per customer, ie Customer No .... Customer Name...

Along the lines of Lawyer jokes ... Five surgeons are discussing who makes the best patients to operate on. The first surgeon says, "I like to see accountants on my operating table, because when you open them up, everything inside is numbered." The second responds, "Yeah, but you should try...

Thanks so much Fizz. All sorted.

Are you saying that the results are being stored in the table as well? What calculations are you using? Calculated fields shouldn't strictly be stored in tables unless they're likely to change and be meaningless / incorrect later on. It could be that your controls with the calculations in...

Yep - on its way!

Thanks Fizz. I'm trying frantically to reduce it in size but whatever I do, it's still too big. Just deleted something, tested it and the error's now not happening!!! :confused: Do you mind if I email it instead pls?

I had a very similar problem a little while ago on a command button: Old Thread This time, it's on a text box and have tried everything that was suggested in that post, which worked that time, but not for this one. As soon as I enter the first digit, the error comes up. If you press OK, you...

Here's another: A man brought a very limp dog into the veterinary clinic. As he lay the dog on the table, the doctor pulled out his stethoscope, placing the receptor on the dog's chest. After a moment or two, the vet shook his head sadly and said, "I'm sorry, but your dog has passed away."...

Here's what I play ... beautiful sound. Bought it a couple of years ago after playing a much cheaper model for years. It's not a great picture, but the best I could find.

There's Robin Hood with an Englishman, Irishman and Scotsman. They've all been really bad to Robin Hood, so he says to them, "Sorry guys, I'm going to have to shoot you. You've got a choice of one drink before you go and I have 3 arrows each." The Englishman says, "I'll have a pinta lager...

What and where is the actual information you want to display about the customers?

Not sure why they wouldn't be saving then. Are you able to post a zipped copy of db?

Just to make sure - are the text boxes on your subform bound to the correct field, or do they say "unbound", when you look at them in design view?

In your query, create a new "field" called NewDate or something that's relevant - follow your new field name with a colon like below and the following text: NewDate: Format([YourDateTimeField], "dd/mm/yyyy") This will convert your date to a string, but in the format you wish it to be. In the...

Nope!

You've not attached the db!

Oh - I hadn't actually realized that you could make changes to a linked table. I've learnt something. I'm very sorry, but I'm not sure how we can overcome this. Hopefully someone else will be able to answer. I'm sure there must be a way of making it read-only. If I find anything I'll post...

In Tools > Startup of your database you can hide the database window which would prevent users having access to the table. Also, if you click Advanced on this dialogue box there's also a box where you can turn off "Use Access Special Keys" which would also prevent the user from bringing the...

Oops sorry!