June7's latest activity
-
June7 replied to the thread Displaying values in button captions.Why would you have a button with no text? Why not a caption something like: "Change Project" -
June7 replied to the thread Displaying values in button captions.I don't really understand the desire to have a dynamic caption on a button but if you must, VBA is the only way. Yes, OnOpen or OnLoad...
-
June7 replied to the thread Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form.Do users really need to see ID_Activity before record is saved? Could save record and then populate field with the ID. If Me.Dirty...
-
June7 replied to the thread Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form.Yes, I did say 'ignore' the autonumber. One issue to be dealt with is that of multiple simultaneous users generating the same value and...
-
June7 replied to the thread Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form.Can't you define non-autonumber field as primary key in parent table? You can still have autonumber field in table but ignore it. I have...
-
June7 reacted to GPGeorge's post in the thread Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form with
Like.
Ah, SharePoint. Well, SharePoint is NOT a "database", SharePoint DOES do that, and it's a huge hassle. See this video for some insights... -
June7 replied to the thread Open form and filter the subform.Okay, did you see post #2? Why embed Friends in a parent form to begin with? Open it standalone and can use DoCmd.OpenForm "Friends"...
-
June7 replied to the thread Solved Copy the Primary Key [ID] and Place It In a Different Control in Same Form.Exactly what do you mean by 'server', why would a server create data? Why would migrating to another server mess up relationships? My...
-
June7 replied to the thread Open form and filter the subform.The WhereCondition criteria can only apply to form that is named in the OpenForm method, not its subform. DoCmd.OpenForm "FormB"...
-
June7 replied to the thread Multi Field Selection.Why do you ask for VBA? A query would use OR operator in criteria to apply filter on all 3 fields. However, I agree with others - db...
-
June7 reacted to The_Doc_Man's post in the thread What would an LGBT battalion look like? with Like.
I understand the humorous intent, but I'm going to back off from this one. I have a step-daughter who is in the LGBTQ+ group. She...
-
June7 replied to the thread Solved Can't Pass On Form Value to Report.Data can be pulled by direct reference to form controls or passed by OpenArgs. Using VBA to set report controls with that data is an...
-
June7 replied to the thread Solved Help with handling of Null.Why don't you use the code suggested in post 51? What is not clear about the suggestion?
-
June7 replied to the thread Solved Help with handling of Null.If Not salesRST.EOF and Not salesRST.EOF Then salesRST.MoveFirst Review http://allenbrowne.com/ser-29.html
-
June7 replied to the thread Solved Help with handling of Null.Okay, maybe put query back to the original and handle the Null in VBA .HTMLBody = Replace(.HTMLBody, "%Call1%"...