Recent content by Garcimat

I need to check if the work section X to Y is not been used by another work group, if it is free I issue a Work Permit.... I can not have overlapping ( two groups working in the same work section)

Actually it is not working, it is not getting the second "AND"

hey @CJ_London , this is a query that @arnelgp helped me with, but I am doing some modifications... it is working now but is there a better way to write this ? Looks weird and too long.... having two "AND". strSQL = "SELECT * FROM tblData WHERE Section ='" & Me.cmbSection & "' AND " & "((" & X...

I need to stop and learn all this concatenation.... Thank you

Hi guys how do I call a variable inside a sql query ? I can do it on the sql server but no with access. I want to use the value from a combo box as filter, actually several combos :) Dim sql As String Dim varCMB As Variant ' value from the combo box varCMB = Me.cmbSection sql = "SELECT* FROM...

@arnelgp I am trying add more conditions on that query for overlapping that you helped me with.... :giggle:

Thank You it will be very useful

All credits to this guy.... Access - Visualize Query Results from VBA - Bing video Found it... ------------ Module Public Sub ShowdataSheet(ByVal sql As String) Const Query_Name As String = "qry_dummy_display" Dim db As DAO.Database Dim qd As DAO.QueryDef DropQuery Query_Name Set db =...

Hi Guys Is there a way to see the result of a SQL query on access like we have on the SQL Server ? for example I have this query Dim sql As String sql = "SELECT * FROM tblOrder Where OrderStatus = ""In Progress""" And I would like to see the result so I can make changes, sorry if it sounded...

Now it is a matter of honour, I will get this to work !

Thanks, I will print it.... make understanding easy when everyone is speaking the same "language"

Everything looks fine BUT.... doesn't work hahaha gvar_index is a global variable on a module do I have to declare again ? frm_ActivePTFs2 Private Sub txtRecordId_DblClick(Cancel As Integer) MsgBox "test" ' it is working ! gvar_index = Me.txtRecordID MsgBox gvar_index ' it is...

I thought about that yesterday, but I don't know how to get the index from that record and open the editing form.

It is not working ..... Why do I get this msg ?

Thanks, very interesting... I try it in a test database, I really need the conditional formatting and the ability to call an specific record on a editing form.