Recent content by johnnixon

Bob Many thanks for that. I wish I'd seen it a few weeks ago when I was first trying to dig into Access VB. Problem now, however, is not how to address a remote control with a literal string (which the link page covers beautifully), but how to pass the form-specific info at the time of calling...

Thanks for your futher comments, Elbweb Sorry for the delay in replying - had visitors and couldn't sneak away to the computer haven. Yes, there is also code in the subform module, which is where the standard module gets called from, but I get your drift. Unfortunately, as I have to do this one...

Hi Pat Further to my previous rushed reply, this is exactly what I was looking for. It will only need a little bit of editing to modify it for multiple columns. I certainly wouldn't have found that link by myself. Thank you once again for your very helpful contribution. Kind regards John

Pat Thanks a lot - very good of you. A quick glance at the MS article looks very promising. Will have a studious look at it later when I finish work. Kind regards John

Thanks Elbweb Appreciate the reply. Unfortunately, have tried that one, and Access doesn't agree with either of us! It just says it cannot find the subform, even though the form and its subform are open together. But I am grateful, as it had gone so quiet, it looked as if no-one was out there. I...

I want to make a tabular report in which each current record is compared with the next record. If the first field is equal, I want to suppress that next record, but concatenate each of the fields, starting with the second field, of the next record with the corresponding field of the current...

(Using Access97) I want to call this standard module sub from various form modules:- Sub NewBtn(FormName As String) Forms(FormName).BtnOK.Enabled = True When I call it from a main form, this works fine:- Private Sub BtnNew_Click() NewBtn ("MyForm") This effectively makes the second line...

Bob Thanks a lot for the helpful reply. Unfortunately, I must be too stupid. I've tried all the combinations I can think of in the call to the sub, starting with:- EditBtn("ManuscriptTitleForm.JobLinkSubForm.Form") ,then with and without the starting exclamation mark, with and without the...

(Using Access97) I have numerous forms and subforms all with the same cluster of button controls. To save repetition, have created a module where the main routines for each button is taken care of. For example, to call the routine by clicking the delete button on the ManuscriptTitleForm, the...

(Using Access97) Resubmitting this one in the hope that I have now formatted it OK. Am trying to create a tabular report with a matrix of lines (like in a Word table). Where there are multiple entries, I would like to concatenate them into a single row, with the first column entry shown only...

Brilliant, jk10 Works beautifully. Much appreciate it. Kind regards John

I'm a newbie at code and finding the Access help very hard to make sense of. It says that I can precede RunCommand with DoCmd object or Application object. Of course, DoCmd.Run...etc works, but is occasionally giving me an error 'The command or action "RecordsGoToNew" isn't available now'. The...

Fool that I am, I had absent-mindedly renamed the button - it couldn't be found. Your solution now works a treat, Elbweb. Cheers John

Thanks Elbweb That's certainly picking up the string now. Unfortunately now generating another error (Application-defined or object-defined error), but not part of this solution I think. Have no idea how to tackle it, but will blunder through it for a while. Had anyway made an error in trying to...

pbaldy - did as you said - gets the form name to the module just fine (used info in one of your recent postings to do breakpoint & F8). In the module, the form name arrives as: Sub NewBtn(FormName As String) - at this point it has the form name as a string variable - hovering the mouse cursor...