Search results

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

Hey, Bob. I don't know if you still monitor this site, but btabdevelopment.com appears to not exist at this point. Do you have an alternative website where you've posted this example? I could really use it to study for a problem I'm having with one of my databases. Thanks

I just tried the code you had given us. I couldn't believe it when I got it to work on the very first try. I am definitely not an expert when it comes to Access. You may have just gotten me a job at this company permanently. Excellent work and thank you very much for helping with a very...

Typically you need that form open so the report can refer to the correct text boxes when it is generated. If you close the form, you lose the dates in it and the report doesn't know what to refer to. Unless you want to have Access open an invisible form from which it can read text boxes, but...

That depends. Is the form still open with dates in it when you change to Report View? If not, it may not be able to reference the names of the text boxes that contain the dates. You can create a blank form that contains buttons to open whatever form or table you need. Then, under the...

The parameters it is asking for aren't from the form. They come from the text boxes in the header of your report. In those boxes, you entered the phrase "=[enter the start date: mm/dd/yyyy]" and "=[enter the end date: mm/dd/yyyy]" Change those to match the criteria from the query behind the...