Search results

The first column is the clients name, the seconds is the day summary and the 3rd is the order details, the others are common function-subrutine used. the day summary is usually avoided by my employee because they have to type a lot in short time so I try to make it faster because it is useful...

I have 1 normal form and 2 manually populated form (the records is a date from a function so the query is not updatable) depend on the filter on that query for 70-100 record in 5 employee is no more than 20 records, one for the opening and one for the closing, on more than half I need to add a...

the problem is that I have 3 forms and on every is more that 20 textbox to fill When I enter in the box in the new form save the form name in the text55 and the textbox name in the text0 so I call the correct event. and avoid : Select Case Me.Text0 Case "Text21" Call...

Dim txtbox As TextBox Set txtbox = Forms(Me.Text55).Controls(Me.Text0) txtbox = Me.Text8 missing after update code DoCmd.Close I tried: Call txtbox_AfterUpdate Call txtbox.AfterUpdate txtbox.AfterUpdate txtbox_AfterUpdate Application.Run "Form_" & Me.Text55 & "." & Me.Text0 & "_AfterUpdate"...

nice... but you need to be careful centre europe is in CET +1 zone but now in summer we are on legal CEST +2 and that function calculate the correct time but not the difference between we and 0 zone example: Rome 14:05 London 13:05 ConvertLocalToGMT(Now()) 'Rome time 12:05 because GMT is...

I'm interested too if someone know how to get GMT time not from system time. if your time is -9 and your system clock is correct you can set dateadd("h",9,time())

unbound control = Mike unbound control2 = Brown me.control=me.parent.unbound control & " " & me.parent.unbound control2 me.control = Mike Brown is this what you ask?

if your field is a date you can simply use +1 if you get an error use: DateAdd("d",1,[fieldname])

Wow. Thank you. Probably when I copy all the list and paste here it pasted all there. How did you find it?? Ty ty Sent from my SM-G930F using Tapatalk

is that filter so difficult??

use your immediate window to test it helps me a lot ?dateadd("yyyy",5,date()) 09.04.2021. ?dateadd("y",5,date()) 14.04.2016.

try Forms!UpdateAgent.Form.txtUpdateFrom = Forms!Maintenance.UpdateAgentInfo.Form.ToDate

try to put grouping on the field you want to see in the top and force new page before selection of group header, and remove the report header. this way you will have on top the field you want on every new page.

the problem as I see is the open event not in the code put that code newrec and if on the first button and not on open event and should work. if not put all in a module and call it from the 1st button, it works to me

see if the form1_correct is now working?

do you try both or only one? If Jurisdiction.Value = "California" then works? If BusinessUnits.Value = "M" then works? if bth works try If (Jurisdiction.Value = "California") AND (BusinessUnits.Value = "M") THEN if not, I had a similar problem when I store the data in table with looukp field...

it's hard witout see your database. I use the immediate window to test all that string with the form open to see if work. if you use the navigationcontro on a normal form the sintax is near that. Sent from my SM-G930F using Tapatalk

navigationsubformname is the name of yout object on the form. the navigationsubform is the subform in the navigtionsubform object [STUDY NAME]=Forms!NAV_DATABASE.NavigationControl0.navigationsubform.Form.SetStudy) Sent from my SM-G930F using Tapatalk

because your query criteria call the form FRM_PROTOCOL not the navigationsubform on the main form. try: your [STUDY NAME] = Forms!Mainform.navigationsubformName.navigationsubform.form.SetStudy not sure but it is something like this

It's not a big problem but annoying and not good for reputation with my clients. A simple list on a form filtered based on a field on the form. It's work every time but one wrong result it always appear if I digit a correct number. For make it easier to understand I attach the simple database I...