Search results

Thank you, Uncle. It occurred to me today that a union would do the trick. That's a nice offer to post Youtube videos of solutions. I may take you up on that. I'm an OLD mainframe programmer that did just about any kind of program in SQL. Transferring to Access has been quite a jolt!

I have a need to produce a report based on a combo box of Nurse's names. However, I also want to be able to produce the same report for every Nurse. Is there a way to populate the combo box with a table of names PLUS the value field with the word "All"? My form VBA can figure out what to do...

Think I'll go kick myself. All it took was maximizing the window I was interested in. Time to drop the Access for Dummies book on my head.

I actually learn more by clicking everything I can and learning from my mistakes. I just wish there was an "undo" for this button. I'll just maximize the one I want and forget that Microsoft is trying to help me.

I stupidly clicked the "cascade" option in the Window Tab of my VBA code. Now every module shows up. How do I get it back to showing just the VBA code for the form I'm interested in? Thank you in advance.

Thank you. That almost worked on the first try but the results were inconsistent. However, if I saved the record first to the table, then issued your command, it worked like a charm!! I had seen web references where you can just look at the field holidays.text but that was a complete...

Thank you, Ranman. Can I see what is in the data sheet?

I know there must be a way and someone must know. I'm looking at the &^%*$( box on the screen right now and it's laughing at me.

I have a multi-value field on a form that I want to examine. I would like to see if my field (that I called Forms!FrmVisitAdd.Holidays has a certain word in it. Is there one field I can examine to check that? i.e. Let's say the box choices are: New Years Day Mothers Day Christmas Boxing...

You're a genius. I can't thank you enough. That solved it.

Why are the simplest tasks so complicated? I'm looking for a MAX value from a table. It will return just one row and one value. My coding looks like this: strSQL = "SELECT Max(PCID) as maxPC FROM TblPallConsultant" Now, how do I execute that statement? I know I can't use docmd.runsql...

Thank you all for your help. Turns out the answer to #1 was: me.Text24 = agenow and I just could not figure that out.

No, these are just variables, such as: Dim intA as Integer Dim intB as Integer What do I put in the text box properties to display them?

I posted before but things got too confusing. I have some variables coded in a VBA module. The results are in fields called intA, intB and intC. I also have 3 texts boxes in a form. How do I code the text boxes so I can display intA, intB and intC? Do I put something in the control...

Can you explain what you mean by: Me.NameOfTheBl...TextBox= agenow I'm confused about NameofTheBL... means. If my text box is named "text24", what do I put where??

Thank you spikepl for that clarification. I want to display the value of the person's age. What do I put into the text box properties? I have the name "agenow" in the control source of the text box but that is obviously wrong. Do you have an accdb that shows the calculation of variable from...

Thank you also, Galaxiom, but I'm really trying to learn out to use a text box.

Thank you, CJ, but that did not address my items #1 and #4. How the devil do I show a variable name in the textbox? I have other variables that I'll be computing in a VBA but all I get is #name? when it displays. Thank you again.

I'm an experienced SQL programmer but I'm finding I know diddly-squat about Access. I'm trying to make the simplest of text boxes on a form. I want to display a person's age just to the right of where they would input a birthdate. My age calculation works like a charm, putting the value in...

I did it with the subqueries idea. The 1st subquery points to the pain for the minimum date for each patient. Brilliant!