Recent content by themurph2000

Actually, I ended up getting DLookup to work. I just have to pick a better site to explain it than the one I did (wasn't this site). And get better at not accepting the way this database was designed when I inherited it. For now, all's good. Thanks for checking in.

I think this was a case of being too clever for my own good. (hard to believe, I know) I have a table that is basically a survey form. The same series of options was available for 35 questions, and the table used to have a text string written for each answer. Because of all the repetitive...

HOW COULD YOU WRITE @#$%@# LIKE THIS??? THIS IS THE WORST PIECE OF CODING I'VE EVER... (just kidding :D) Not sure what's going on. I just tried it myself and added the corresponding data. It took the correct reords. Here it is when I entered it into my database. SELECT Item, Description...

What does any of it mean? Why are we all here? Who invented liquid soap and why? Why is it a pair of panties but only one bra? Why is there braille on drive-up ATM machines? Why is it a penny for your thoughts but you have to put your two cents in? Who kept the other penny? Why does...

Create the two text boxes first on your form. Then click on the first checkbox and, if the Properties pane isn't up, hit [ALT]-[ENTER] on your keyboard to bring it up. Click on the Event tab and the AfterUpdate row. There should be a button with an ellipsis (...) at the right. Click that and...

Sorry, I misunderstood. What will you be doing with the numbers once you get them? Another option would be to create two text boxes on the form, set them to invisible, and set the AfterUpdate() to fill the text box with 00 (or 01) when that particular checkbox is selected. You would then use...

They can't check both; that's the idea. If they click on one checkbox, the other one automatically turns off. That way, there's only one value and you can make your iff statement to read IIf([Forms]![TPTC Analyzer]![P Future cost]=True, "00", "01") I would recommend also making the default...

In Access, you can use two IFF statements in a nested format. That way, there's only one value returned. iff(condition, iff(condition2, truepart, falsepart)) In your case, unfortunately, what if someone checks both boxes? Just to be safe, you may want to put the following VBA code in the...

I second essaytee, because it sounds like what Fahad needs. Fahad, is the item you want emailed on the screen in a single form? If so, the solution here works because you email the contents of each of the individual bound text boxes that would be on your form. If those boxes don't have names...

Actually, I figured it out. The solution was a bit ugly but it worked. I created invisible check boxes in the form. When you clicked on a button for the range you wanted (dates, weeks, or quarter), its check box was set to true and the other two were set to false. In the query, I then created...

Oh. I'm sure it works great, but I'm at work and YouTube is definitely blocked.

That sounds just about right. Here's the SQL code SELECT [DataSelect-AtRiskScores].ID, [DataSelect-AtRiskScores].EntryDate, [DataSelect-AtRiskScores].Week, [DataSelect-AtRiskScores].Qtr, [DataSelect-AtRiskScores].Observer, [DataSelect-AtRiskScores].[Location/Department]...

Another one of those that should be a piece of cake but I'm having one of those :banghead: type of days... I have a form where users can enter the beginning and ending dates into text boxes. They could also do it for the number of the week (1 to 52) or a single text box for the quarter. I...

You can make several reports tailored for the type of timetable that you want, and the majority of them can be based off of the same query. The grouping option will be a powerful tool for you if you want to devise a master schedule of patients or one for each therapist in question, and even...

I wouldn't use one big table. You may want to split into three tables: list of patients, list of doctors, and the schedule itself. Give each patient and doctor some sort of ID number, and those IDs would be linked into the schedule table PATIENT_TABLE Patient ID Last Name First Name (other...