Search results

Looks like the same question may appear on more than one survey, yes? For example, "Have you been previously seen at this medical center by a primary care provider in the last two years?" This is why I was looking for junction tables earlier, so that you could re-use both questions and...

What is the purpose of the Clinic table? Do surveys belong to clinics? If so, let's have a FK field in the Surveys table assigning it to the proper clinic... --Clinical Mac

The QuestionID field is unecessarily complex--if you know what survey the question is linked to, you don't need to put a marker for it in this field. Making this a simple int will also clear up your sorting problem (noted earlier) and eliminate the need to include the question numbers within...

Probably just a person preference, but I always use autonums for Primary Keys unless there is a specific reason not to (e.g., a junction table). I'm revising your db to do this now... --Auto Mac

Check out this thread. Just starting to take a look... Your questions are coming up in the wrong order because of the way Access sorts text (as opposed to numeric) values. The simplest way to correct may be to add a new column to your query with the following: MySort...

Probably by creating a separate table for questions and another for answers, with a junction table in between? --Conjunction Mac

Just double checking, the .bat file was installed on the remote computers and was unable to go get the new front end on your host, yes? You've probably hit the point where you have to start working with the admins of those other systems to get proxy, firewall, and directory permissions set just...

God forbid...:rolleyes: --Catty Mac

Below is a quote from this thread which you will probably find very helpful. This and many other posts can be found by searching the forum archives on phrases like "distribut* AND front AND end" --Resourceful Mac

Anick: It's considered bad form to cross-post a question for which folks are already offering you advice in another thread. --Miss-Manners Mac

Your choice, of course. One final bit of advice--when you finish the scope of the bid/project and a bit of time passes and this person comes back wanting another change... stick it to 'em! :D --Wrathful Mac

But Pat, that's why we love you!:D RayChoy, you may find this article useful in differentiating nulls, zero values, and zero-length strings. --Prefers-Picky Mac

So the "basic" record then becomes an entry in tblVisits, which has a complex PK of fkPatientID and dtmVisitDate. Links to tblProcedures and tblComplications as they arise. [B] Of course I don't know all the details, but at this point I'd probably try to renegotiate. Imagine if you were in...

Given the above, I'm not sure you need the whole hidden text-box step. If the form is opened via buttons, with separate buttons for "open in read-only" vs. "open with edit capabilities", couldn't you just add a line of code to the existing OnClick for each button that sets the form-level...

You could always go with a listbox set to multi-select extended... --Extended Mac

Here's a quick example of an alternate design... you would have to adapt, then create & run some queries to xfer your data from the old structure, but take a look at the vastly simplified queries here... --Exemplar Mac

All the more reason to practice normalized design from the start of every project ;) Seriously, while I'm sure Pat H. or Jack or Rich or SOMEBODY with more experience than I could untangle the underlying problem in a snap, I'm stuck... just sitting in a corner twiddling my fingers, which only...

... thing's don't seem normal ... I just d/l'd your sample and will look at it in more detail as soon as time permits. However, you should really consider going back a couple steps and normalizing your tables. You've got info in this one table that ought to be in at least three, maybe more...

Sorry, Chris, just went back and re-read your post and realized you're looking for something a bit more than just "how do I handle a null value". Zip up a copy of your db that has any sensitive data replaced by dummy data and post it here. --Too-Hasty Mac

Search Access help on the Nz() function. Also, you may find this article helpful. --Blank Mac