I am developing a database to assist a member of family, who runs an Aunction House. Their current database is really restrictive and so tied up on authorisation loops, they can't add any reports and I can't amend the database for them at all, and am having real difficulty exporting all the core data to be the foundations for my own new one.
However, I have one table for the actual items, another for the customers (who can be buyers as well as sellers - I have set them up one sole account), I'd like to be able to add to my customer form, a sub form (perhaps) lisiting all items they have sold and another showing how many they have bought, as well as invoice history for both.
My main question, at present, is that they currently use the items table, live on the day of the auction. They filter it for that days auction date, and add live into the table, who bought the item, the hammer price (what it sold for), as on the other side of the office, customers come up the counter to pay for their items, and an invoice is pulled off there and then.
I had thought about exporting a query and them adding the data back in, but as they are using the table at the same time, it needs to be live.
Can you suggest an alternative better way?
I have added so far, the tables and populated them, as well as a number of queries, and a customer and item form. I've not added any VBA at all as yet. I wanted to get the nuts and bolts in place first.
I'm not sure how to set permanent filter at the top of the table, so they can filter for that days auction only.
I also want to include a search on the top of the customer form, so they can search by the persons name or ID number?
I havent' added the invoice section yet, but they need to be able to pull up all items that customer has purchased and add them to an invoice, and for the invoice to stay in the history.
Also need to be able to pull invoices for the seller. They can relist items for 3 weeks, then they need to be notified to come and collect their items, I've created a report, for all sold items on a particular day, as well as a list of unsold items, with the time attached, so they can relist for the following week, or contact the seller to collect.
Can you think of a better alternative? I'd like to be able to add conditional formatting, so they know by colour if they need to go back, or can be relisted, like a RAG system (red, amber green), not sure if this is possible, I've not researched this as yet.
Sorry, lots of questions. I've only joined today. I'm self taught from books and the web, and attended a few Access Courses last year and VBA and am now hooked.
Thanks so much