Search results

@Plog: I don't understand this

Finally! with all your help, i am able to build a piece of it. Would you mind taking a peak of it? for improvements? for a better world? :D PS: Issues i still can't resolve: I want to set the focus to txtMon1 after i click on date picker of txtStart How to elegantly minimise the code in...

what's the difference between my previous code "rs.addnew and .edit" with your sql strings?

So that rs.addnew and rs.edit is best for what kind of operation/process?

so you mean the solution of Auntiejack56 will generate a runtime error?

@ the record layout: if you were the one designing, how would you do the layout? @ normalised: i thought my table is normalised?

Auntiejack56: I think this will do. it will look like this rs(mon1) = c. value rs(tue1) = c. value .. right? then i'll just manually input the empno right?

how do you squeeze this thru looping Private Sub cmdSubmit_Click() Dim t As TextBox Set rs = db.OpenRecordset("SELECT ID, EmpNo, StartDate, EndDate, " & _ "Mon1, Tue1, Wed1, Thu1, Fri1, Sat1, Sun1, " & _ "Mon2, Tue2, Wed2...

Ok. Thanks.:p

I want to move the cursor or set the focus to other control after i click or pick a date from the date picker. i get error 2110 with this code: Private Sub txtStart_AfterUpdate() DoCmd.GoToControl "txtEnd" txtEnd.SetFocus End Sub

Solved! https://www.access-programmers.co.uk/forums/showthread.php?t=71319 Thank you!

I have another thread. please help Time format Problem Thanks

SOLVED BY: ME.txtEmpNo.Undo THANK YOU!

i'm trying to extract a data based on 2 criteria. date is not cooperating! the supposed to be October 7, 2017 (10/7/2017) is interpreted as July 10, 2017 (7/10/2017) Set rs = db.OpenRecordset("SELECT ID, Mon1, Tue1, Wed1, Thu1, Fri1, Sat1, Sun1, " & _ "Mon2...

it returned to txtEmpNo but did not highlight the text inside it.. maybe access vba doesnt have such capability.. im starting to give up..

attached is what i mean.. just to highlight the text inputted after it set focus.. :(

Plus i cannot extract the data that i want with the date criteria. Please check code/database i have uploaded Thanks

because using txtEmpNo.setFocus give me this error

Last thing regarding txtEmpNo, I want to highlight the text when it return focus, :D Thank you for that solution!

Why do i receive this message? no docmd no setfocus?:banghead: