Search results

Thanks for your help - I was rather hoping there was a simple way of creating a whole new set of blank tables - gets annoying having to delete from tables in the correct order to avoid problems with referential integrity rules but this certainly helps.

Can someone help please. I have built and tested my database and now need to delete all the data and reset all autonumbers. Is there an quick way to do this without having to create and run lots of delete queries?

Many thanks for this demo - looks like a great solution - I did not even know tab strips existed before! Clearly I still have a lot to learn and its great to have help from all you experts.

Thanks for the input. I think your first idea of using the tabbed forms but putting the subform on top of it may be the answer. It solves a couple of other problems as well. I want to use the tabs because I am adding functionality to an existing system and as much as possible want to keep it...

I could do, but this way means that all class names can be seen on the screen at one time and user can flick between them to register people as they arrive. Your suggestion is my fall back position if I can't make plan 1 work.

I have a form where the user enters a day. There is a tabbed form below where each tab contains the same subform. The tabs show the names of classes running on that day. The subforms are populated by a query that selects all students enrolled on classes running that day. What I want to do is...

Thank You! :) You are a star. Thank you. I am new to this and was doing the right thing but on the wrong event. You have saved me a lot of time and frustration.

I have two unbound combo boxes on a form that allow user to find a record on the form. The user chooses which to use depending on whether they want to search by customer name or number. Both work fine. However, if they choose to select by number, I want the second combo to display the...