Search results

Isaac and Tony, et al The more I attempt to use Chatgpt and CoPilot(Bing Chat) productively, the more I am becoming convinced that the major beneficiaries of these tools will be/are the scammers. As with a lot of technology, the "bad guys" have an intrinsic knack for making the best/worst? use...

Did you try the query I suggested in #4? It should show the unique values in Category.

I agree that readers need to see your table design and some data. Is it possible there is a spelling mistake? You may try Select distinct Category from Contact_People; to see existing Categories.

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.