It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.
See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation
Course Of The Month
7 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Adding to open record on form, from unbound textbox
Posted on 2016-09-15
I have a DB that tracks work for employees, the employee logs in and that information is stored in a temp table/query. Them the employee goes to a form and works based on date range for the assignments.
So the problem that I am running in to is, I am trying to add the person and date of when the assignment is complete. So I tried adding VBA to OnClick for the yes/no for the completed field. I created two text boxes one is a d-lookup for the employee and the other is the text box for the date.
Please let me know if addition information is needed.
So the problem that I am running in to is, I am trying to add the person and date of when the assignment is complete. So I tried adding VBA to OnClick for the yes/no for the completed field. I created two text boxes one is a d-lookup for the employee and the other is the text box for the date.
Please let me know if addition information is needed.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
Active today
Where are you adding the Date the Assignment is complete?
And how do you determine if it is Complete?
Remember that we cannot see your screen, so referring to things like "completed field" means nothing to us.
If your goal is to "stamp" records with the current user and time, then I generally leave the login form open but hidden, and refer back to that form to get the username. If you want to get the current date, just use Now() or Date()
And how do you determine if it is Complete?
Remember that we cannot see your screen, so referring to things like "completed field" means nothing to us.
If your goal is to "stamp" records with the current user and time, then I generally leave the login form open but hidden, and refer back to that form to get the username. If you want to get the current date, just use Now() or Date()
Sorry for the delay, still learning Experts Exchange.
I have attached a screen shoot.
#1 on screen shoot is the unbound fields that I want to update 2
#2 on screen shoot is the is the bound field for the open report.
#3 on screen shoot is the OnClick for completed.
Sorry for lack of information. still learning all of this.
I have attached a screen shoot.
#1 on screen shoot is the unbound fields that I want to update 2
#2 on screen shoot is the is the bound field for the open report.
#3 on screen shoot is the OnClick for completed.
Sorry for lack of information. still learning all of this.
Active today
So the two items in Item1 contain the data you wish to use to fill the two items in Item2? And you want to do this when the user checks the Complete box?
If so, then you could do this in the AfterUpdate event of the Completed checkbox:
Me.CompletedBy = Me.QNumber
Me.CompletedDate = Me.QDate
Of course, I have no idea of the names of your Controls on that Form, so you'd have to change those to match the ones in your form. In the example I gave, the two items on the left side of the equal mark are the items in #2, and the two items on the right side of the equal marks are the items in #1.
If so, then you could do this in the AfterUpdate event of the Completed checkbox:
Me.CompletedBy = Me.QNumber
Me.CompletedDate = Me.QDate
Of course, I have no idea of the names of your Controls on that Form, so you'd have to change those to match the ones in your form. In the example I gave, the two items on the left side of the equal mark are the items in #2, and the two items on the right side of the equal marks are the items in #1.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 17 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.