I am novice access user (2003) but am generally well versed with extracting data in queries etc.
I am building a restaurant kitchen screen and need to show the top say 16 orders all on one screen but listed horizontally. the data is stored in at least 2 tables, one for order number, type, time of order etc and one with the order details (the kinds of food items). I dont have a problem with getting this data represented in a query. THat was the easy party.
Now to the hard part. I need to show the orders to be fulfilled by the kitchen across the screen, i.e. order 1, order 2, order 3 etc. so continuous forms do not work. I've also tried to use separate forms with subforms (datasheets) and use the GoToRecord command to go to a specific record in the query, e.g. form2 would show the second outstanding order, with a timer controlled Requery command to constantly refresh the forms to reflect the latest orders. I had a button on each form which when clicked would then say that the order was fulfilled and the Requery command would then refresh that form and load the next record in the query.
The problem i have encountered (apart from needing to position the 16 forms properly on the screen with the MoveSize command) is that Access is giving me error code 3048 Can't open any more databases.
Is there anyway around this or is there an easier way to get what I want accomplished say using listboxes? I have tried using one main form with 16 subforms but whenever i run the GoToRecord command it says the forms aren't open. Pls help me, I have been at this for months now trying to get this done.
Thanks a million..