Search results

I agree with theDBGuy---There are several links to Northwind 2.0 Starter Edition here.

Welcome to AWF.

Welcome to AWF Edward45.

Tell us more about your application and the "set-up-for-new-year" process. For consideration: 1-take an extra copy of your year-end data base, name the database New Year, delete all the data, At this point yo have all tables--just no data--What am I missing? =or= 2-List all the tables you need...

Welcome to AWF! snappyfridge!

James, Regarding your Please see this article on Stump the model. Create some sample data and some sample scenarios and test your model. It is much easier to adjust the "paper model/database structure" during some serious vetting of the model rather than attempting to adjust a physical...

I agree with George and would emphasize that ClientDsqID needs an AssessmentDate if you are( or plan to) monitoring scores over time intervals.

Mylton, Google "sample msaccess front end with sqlite backend" and you will find some info. I am not a sqlite user so cannot offer direct experience. If sqlite supports ODBC, and I'm sure it does, then that's probably a big player in your setup. Let us know your progress.

Welcome to AWF, Martin! You may find the videos by Pharos Technology (DR. Richard Hanson) helpful. He runs a small business with Access. (eg. )

Welcome to AWF, Jaks!

Welcome to AWF, teemax!

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.

Hi and welcome to AWF!

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)

Good point Roger. In any hospital situation that would be a med-error with serious repercussion possible-especially to the patient.

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 !!

Hi and welcome aboard AWF!

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...