Recent content by gpeirce

I recently became a fan of UG. I programmed mainframe computers since 1971 and was involved with databases since 1980. Transferring that knowledge to MsAcess has been difficult. All the apostrophes and double quotes and continuation lines etc etc have been difficult to master. I got spoiled...

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