Recent content by paulml

Thank you to everyone for their help on this issue. I've tried to PM some people but my post count won't allow it yet. As I have many other tasks in the office, it may be a while before I can get my "MS Access" hat back on and so this problem is now on the back burner for a while. I just wanted...

I've run C & R on this and it's still proving impossible to delete this order. I still get the same "The search key was not found in any record." returned. I've not tried deleting this from the table itself in the BE. I've only tried to delete through the user access form in the FE. Do you...

Thanks for your responses guys . . In answer to Dave, Yes, it is an autonumber and yes it is the PK in this table. It is INDEXED: Yes (No Duplicates) It's definitely 2 identical numbers in the same PK (Indexed, no duplicates) field. It's strange for sure. I'll certainly try the C & R...

That was going to be my next job. I just wondered if anyone had any clue as to why this might happen. It's worked fine for many years and I'm puzzled as to how one of the users managed to produce this. I've often said that no matter how foolproof I make it, there's always a fool who will beat...

Hi Guys I've searched the forum and can't find an answer to a tricky little situation that has arisen in our office. Simply put, we have a table of "customers" who each have an autonumber Primary Key, (CustomerID). Every time a user places an order for a customer, this generates another...

Thank you very much for your input. I really appreciate your help. The updating is now being put on hold for a week or so so I'll try out your recommendations when I get back to it. Thank you again. Paul :)

Thanks a lot guys! I did try a new table just to hold the notes a few days ago, but couldn't get the display to look right on the form. Although I do need multiple notes, they will mainly be deleted after being read. I will try this again with continuous view and see what happens. What is...

Hello everyone. I am currently updating our old Access DB 2003 to 2013 and wanted to make a few modifications along the way. I would really like to allow users to leave notes for each other on a front page. This front page form does not have any underlying table to it as it is only used as a...

As a further thought to my problem here, the subform is normally focused in a tab order. Instead of the normal tab order taking the focus to the subform, it takes it to the Form Tools, Datasheet tab above the ribbon. Although I can see the subform headers the actual datasheet is greyed out and...

Good morning everyone We have been using Access 2003 for 8 years and we're now updating to 2013. Wow, it's a big leap! I've sorted out a few issues but I'm struggling with something...... When our users, place a new order, a macro runs to open up a "New Order" form. This form contains a subform...

Wow! Speedy response. That's great, thank you! I'll try to work around that and will get back if I can't solve it. Thanks for your help and Happy New Year!

Hello Guys I'm running Access 2003 and my question relates to delivery notes that are produced for drivers as reports. These delivery notes have a blank payment box for the driver to complete if the customer pays upon delivery. As more and more customers are prepaying by credit cards, I'd like...

again, thank you all for your time and thoughts. We already have a seperate delivery address which stays with the historic invoice/order details even if the customer's billing address changes. These details are stored in an "Order Details" table. That seems to work fine but i'm still...

Thank you very much for your input. I've added a VAT table and am now looking at how to tie that into my work. I'm not exactly sure of how it will work but will puzzle over it a while. :-)

I have read several posts regarding changing of vat rates but am still struggling to find an answer. I wonder if anyone can please help shed some light on my dilemma. I'm fairly inexperienced at Access although i did write a database for my former company several years ago. This still handles...