Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
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"
Today at 8:09 AM
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...
Today at 7:08 AM
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...
Today at 12:49 AM
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...
Yesterday at 11:57 PM
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...
Yesterday at 11:29 PM
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...
Yesterday at 11:07 PM
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"...
Yesterday at 9:49 PM
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...
Yesterday at 9:29 PM
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"...
Yesterday at 5:20 PM
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...
Friday at 5:06 PM
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...
Thursday at 4:53 AM
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...
Wednesday at 2:46 AM
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?
Wednesday at 2:40 AM
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
Tuesday at 4:16 PM
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%"...
Tuesday at 4:03 PM
Home
Members
Top
Bottom