Search results

arnelgp I have created a form "frmLimits' with some dynamic combos, , what I am thinking is to click the button to collect the info to the tblData and then look for the overlapping in there using global variables, once validated this data will be insert in the main table where I have all the...

Interesting topic, I was surprised to find out that the King of Congo was the one offering slaves to the King of Portugal, I always heard and learned at school that he Europeans used to raid Africa and capturing free people, but there are the letters from the King of Congo to prove me wrong...

I am doing it on my system as well, but I am using a global variable in a module that I call back every time I need the user name.

Sorry, I could not access the zip file, I tried again now and it worked fine. Thank you

I got it, I call this Sub on every btnName_Click() Thank you guys for your help. Private Sub DateTime() '''''''''''''''''''''''''''''''''''''''''''''''''''''''''Change Over txt_ChangeOverTime.Enabled = True txt_ChangeOverTime.SetFocus txt_ChangeOverTime.Text = "" txt_ChangeOverTime.Enabled =...

00:00 for short time 30/12/1899 for short date

it show some weird values....

I tried to do a private sub to clean the fieds.... text=Empty didnt work... so I tried text=" " and I got a Mask error Private Sub DateTime() '''''''''''''''''''''''''''''''''''''''''''''''''''''''''Change Over txt_ChangeOverTime.Enabled = True txt_ChangeOverTime.SetFocus...

No, I don't have, only input mask 00:00;0;_

Hi guys I hate work with date and times, on the record table these fields are Date/Time on my form the text boxes show like this (with values) even when they are not enabled. I have tried to use .value=empty and still no success, I want these fields to be blank like the others. thank you

it is not working :(

thank you :love:

I hate work with dates hahhaha

that is true the numbers can be something like 10.250 to 33.750

That is great because we can have multiple SWO (Service Work Order) that will say the limits of the Job (LIne X from KP (Kilometre Post) 1 to 350. inside this SWO we can have 10. 30,80... permits to work (PTF Permit to Foul the Track) every work group have one PTF and they can not overlap never...

Hi Guys I have this date entry form, (IMAGE1) the user have to input the TIME (typing) Day (combo box) and DATE (Date Picker) I know It is silly but it has to be done like this, it is a legal requirement that the user write/choose this information. The record inputted will generate a active...

Thanks Pat Most of the works will last a day, some couple days, some weeks.... I could have an "Active" and "Cancelled" tag to change the date or create a duplicate record for the "Active" records.... That is an idea as well. I never used an multi-field index, I will search for it. Sometimes we...

We do safeworking for the rail industry, I am building a system to manage the works when we have shutdowns on the rail lines.

That is very impressive my friend, thank you so much I will study and learn from your codding, definitely a higher level. I already have my data entry form done, I was planning to use drop boxes because the limits would be predefined, but your example have opened up a new perspective. I can have...

Hi guys I would like to assign a range of values to one variable.... var1km = 10 to 50 var2km= 55-70 var3km =85-200 I can not allow overlapping..... for example when I give permission to someone to work between 10 and 50km I can not have a second work group working in the same limits.... I am...