Recent content by DCinFRANCE

Yeah, Gasman, I tried it. I too assumed that "Form A" and "Form B" had to be open for B to "see" A. Double checked all references, and they were correct and specific to the form. I didn't get an error; just the display of Null (or "") in the field. Yeah, Giz, I thought that too. I investigated...

Sigh. Not really. As for coding, and employing a coder (programmer), that was the whole point -- that no, it would not require an arm and leg and months of development. The use of macros is a necessary evil...and the way Access builds them, they are simple and not nearly rising to the level of...

I never seem to ask my question specific enough. First, no code. I know how to declare variables, but there is no VBA, and can't be. I've explained elsewhere, but I will add to that that I don't want to spend the next 3 months becoming a coder. This is not even close to what I do for a living...

It may sound redundant, but I appreciate anyone's time to answer. Is there any way to create "global" variables such that two independent forms, both in memory, can share their values?

Who said anything about a multi-value field? Are we talking about the same thing? We were talking about using the Lookup Wizard when defining a field in a table. The only multi-value fields I use are for attachments...and Access defines them, not I.

I'm not sure, but that almost sounds like what I'm looking for. Every time I've tried to use something from a form in macro, it doesn't know what it is. I appreciate your time, but could I ask you to elaborate?

Aside from being a masochist you mean, Marc_? LOL. I wanted this data base built and the IT department whined and whined about how much coding it would take (read that money). I proclaimed that nonsense and said I could do it myself without any programming aside from a macro or two. They said...

Thanks, Paul. The rest of the story is slightly more complicated because building the "today" file is very complicated...like bringing 3 cross tab queries together to create the file. Yes, I see what you're doing. However, I'm doing this whole thing without resorting to VBA. So, it would take...

Thanks for asking. The contents are different, structure is the same. What it is is that there are quarterly meetings which present the current state of training. The file is then copied (archived) to another name as historical. If we look at previous quarterly meetings, we want to see the...

Okay, I have a form, working great, and it's record source is: SELECT [tblI) Training].*, [tblLU Role Codes].luRCfunc FROM [tblLU Role Codes] INNER JOIN [tblI) Training] ON [tblLU Role Codes].luRCcode = [tblI) Training].T_ROLE; What I want to do is when the form loads, be able to substitute a...

LOL...thanks, and I've heard that, but many times I have no choice. Maybe for everyone's edification, I should explain, but only after I rant on not getting proper error messages out of Access - and happens to be why I stopped using Excel (as, I've heard it a million times, Excel is not a...

Hi Minty, thanks for responding. Nope. No error message. Just the 'busy' wheel turns (Windows 10) for about a second then nothing. I did the conversion to VBA before I wrote the post, and indeed it had a syntax error...but on the very first statement (PRIVATE whatever, I'm not a vba...

I have a form, it has a subform in continuous forms. On the detail lines I have a button, with a macro to load a popup form. In the macro, I have a where condition such that data on the detail line is used to drive the data on the popup. It has been working fine. For weeks on end. Suddenly, I...

Who you callin' old?! :D Thanks Tony.

Thanks everyone. No Gasman, that's not it. Its basically as the others have responded. On click of a single button, if the field1 value is A, load frmA, else if field1 value is B, load frmB, else if field1 value is C, load frmC else there is no form for the value. Thanks for the code attempt...