Here is some info about autonumbers from UtterAccess.
What they are NOT:
1. Row (record) sequence numbers.
2. An "order of entry into the table" number
3. A "gapless" series of numbers.
4. Editable numbers.
5. A series of (necessarily) always increasing numbers.
6. Intended to be viewed/used by...
knoet,
Can you step back and tell us a bit about your database application? Not only do current readers need some context in order to offer focused advice, but anyone reading this post in future would be "lost/confused" without some additional descriptive material.
What is/are "right records...
Hi Craig. Welcome to AWF.The site has a broad range of users and experiences. I'm sure you'll get answers/advice if you pose any questions clearly. The players are all volunteers and will assist where possible.
Suggest for thoroughness you consider:
Medication name (DIN)
Medication strength (if applicable)
Quantity
Person name/id doing this transaction
Patient receiving the medication
Date/timestamp
Directed by (Doctor)
Can someone point to the latest database with the latest features mentioned in this thread? There seems to be a lot of conversation and additional code, but I haven't found the authoritative file with latest info.
MajP, you've done a lot of great work on this !!
Thales750,
Is this a hypothetical to get some ideas from others, or a serious design consideration? I agree with comments , and it is a bit thought provoking. The typical issue we see with front-ends is where user-developers build and use a single front end----and do not have individual FE on...
moi,
Further to the responses received so far, here's a link to project management concepts that apply to database, building a house, starting a business....
Tim,
Here's a link to an older article by Martin Green on Dynamic Reports. His website is no longer online AFAIK, but the article is still relevant and the link points to an archived site. You may find it helpful for concepts and examples.
Tim,
You have received responses to your "debugging issue". I suggest you tell us more about the Reports you wish to run and the combobox used to select such reports.
Ramzi,
Based on your original request, saving names of tables/forms and reports to your own table, you have been given various options -all relating to MSysObjects. However, it seems to me that your underlying issue is assigning roles and permissions to various users, and that your desired...