Search results

Thanks for that info. I will definitely be trying this. In my case the application will be deployed to many individual end users. Not users in a network or corporate environment. As such each end user (single workstation/pc) will have both the BE and FE on their machine. As bugs are found, or...

Thats a simple enough way to update the front end. Any ideas on how to update the backend without the loss of data? I really hope that I wont have to do much back end updating...I really hope I have planned well enough that I have all the tables I am ever going to need. However, no matter how...

Thank you for the reply pbaldy. I should have said in the original post that the application is for a single user on a single machine. I have no problem with splitting the database. Both the FE and BE would reside on the users machine. There would be no conflict with other users. I think I...

1. Once I have packaged my database (Access 2007) to use the runtime, how do I upgrade the installed application to include changes to the database (eg new forms, new tables, new functions etc) without losing the data that was in the previous version? At the moment, a user must uninstall the...

That is an option if I cant get it to work, but hopefully I can sort this out so the report and be generated as needed. Could you give me a basic example how select queries are "unioned"?

Hi Neil, I agree the design is not ideal, but unfortunately redesign is not an option at the moment. The database will be completely re-worked next year and migrated to Oracle. However in the meantime I need to be able to report on money won by players. Each event (record) pays players up to...

Hi dmonney, I'm not sure I follow your question. The information is in a table. I have a form that I am using only to search the table. Basically its a search form where the user can search for players that have won money. The form calls a query thats run against the table to extract the...

Hello Everyone, I have a table called tbl.Shows. In that table are several columns e.g. WinnerMoneyWon, RunnerUpMoneyWon, ThirdPlaceMoneyWon, etc (all the way to EigthPlaceMoneyWon). Each record can contain values for any or all of those columns. The values are currency values. I am trying to...