Solved

Adding to open record on form, from unbound textbox

Posted on 2016-09-15
4
43 Views
Last Modified: 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.
0
Comment
Question by:Raymond Rule
  • 2
  • 2
4 Comments
 
LVL 84
ID: 41800030
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()
0
 

Author Comment

by:Raymond Rule
ID: 41800131
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.screen shoot
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 41800176
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.
0
 

Author Closing Comment

by:Raymond Rule
ID: 41800257
That worked perfectly, thank you.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now