Search results

I got it :):) Private Sub Command877_Click() Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tbl_Data") Do Until rs.EOF If rs![SWO_Number] = gvar_SWONumber Then ' gvar_SWONumber Global Variable If rs![PTF_Number] = gvar_PtfNumber Then...

It does not changing the fields….

I am really green with SQL, I can never get it to work, I will give it a try

Hi guys I want to search the table and when some conditions are achieved I want to change the value in one of the fields, I am trying the code below but it is not working... Thanks in advance. Private Sub ModifyStatus() Dim i As Integer Dim db As Database Dim rs As Recordset Set db = CurrentDb...

I want to open a form based in 3 conditions 2 conditions will come from global variables the third one is a value from the tbl_data When I double click in the list SWO Number will send the value to the global variable gvar_SwoNumber and PTF Number will send the value to the global variable...

Thanks I spent my day doing exactly that, today I am fixing all the problems caused by these changes.

It is complicated this fields have to be field manually by law…. I can’t for example use time() or date()

Thanks I will try that

Swo holds 1234-2022 It will never be bigger than this, I thought it would be text because the “-“ in the middle

I think it is the data type….

.

Actually it is getting the values

This one

I am getting an error, gvar_swonumber is variant I think it is seen this variable as string because the format is 1111-2022. The form is bring all the records.

Hi guys I can’t get it to work, my form opens with a random record. double click in a list box > get values from columns with global variables (variants)> open form with the record based on the variants…. Coding below Private Sub lst_ActivePermits_DblClick(Cancel As Integer) 'On Error GoTo...

Thanks I am going on this way, easier to filter my records…. It was a good challenge.

Well I have a main form frm_welcome that will direct the user to other data entry forms (frm_PTI and frm_PTF) if they close using the access X button I get broken or incomplete records, I don’t want that and exiting in the main form looks more professional as well. My problem now is: if I use...

Wow Thank you guys

No, still doing it :(

Hi guys I am trying to not allow users to close the application using the Access X button. I have an public variable called fcanIclose as Boolean here is the code: Private Sub Form_Unload(Cancel As Integer) If fcanIclose = False Then Cancel = True MsgBox "You cannot close using tis button.You...