Search results

Try this: Private Sub Combo58_AfterUpdate() If Me.Combo58.Column(1) = "Cranks" Then Me.Text167.Visible = False 'Hide the first text box Else Me.Text167.Visible = True End If End Sub

Thank you ByteMyzer. It worked !

Hi all, I am using Access 2007 and I'd like to disable right clicks on forms through a VBA code (not from the Access menue or other). If someone could help, I'll be grateful even after the incarnation of my little soul. Thanks in advance :)

No solution worked, but I did in another way. Solution : totprecsql = "SELECT tbl_actualVal.[totalFTE], tbl_actualVal.[typeActual], tbl_actualVal.[averageFTE] " & _ "FROM tbl_actualVal" & _ " WHERE tbl_actualVal.[monthActual] = " & Me.perPrec & " AND tbl_actualVal.[yearActual] =...

Hi arnelgp, Yes, the spelling is correct. I tried you suggestion but still have the same problem. Thank you anyway.

Hi arnelgp, Yes it is a value in the field which i wish use a criteria.

Dear all :) I am using Access 2007. I am building a form, almost finished, but the last part sucks. I did a SELECT statement to bring a value based on several criterias but when I run it, it demands A PARAMETER VALUE. Here is the SELECT Statement : totprecsql = "SELECT...

Solution Private Sub lboActuals_DblClick(Cancel As Integer) Dim cond As String Dim cond1 As String Dim cond2 As String Dim cond3 As String cond = "idInitiative = " & Me.lboActuals.Column(0) cond1 = "typeActual = " & Me.lboActuals.Column(9) cond2 = "monthActual_tbl_actualComment = " &...

I just deleted the ORDER BY condition fsql = "SELECT [rsel_frm_viewInitiatives].[idInitiative] AS ID, [rsel_frm_viewInitiatives].[initiativeName] AS Name, [rsel_frm_viewInitiatives].[initiativeType] AS Type, [rsel_frm_viewInitiatives].[teamName] AS Team...

Hi, I don't think it's the same, because here it's a DoCmd.OpenForm and not an sql statment.. The issue is in this line: DoCmd.OpenForm "frm_initiativesDetails", , , cond, cond1, cond2, cond3

Thanks Bo.. and to all, It's solved ;)

Hi folks, I built this code to open a form based on 4 criterias but I have a problem in this line : DoCmd.OpenForm "frm_initiativesDetails", , , cond, cond1, cond2, cond3 When I do just one condition (cond for example) it works the message error is, I think it's a syntax error .. Full code ...

Thanks Cronk but it doesn't work :(

Hi Bob, It doesn't give error nor a program crash it just run the first condition (teamName)

Hi Cronk, It doesn't give error nor a program crash it just run the first condition (teamName)

Thansk JHB. It's a number but when i tried it it gave me this error :

Hi all, I'm trying to use a WHERE condition that holds two conditions I succeeded to execute the first condition (teamName) but when I add the second one it doesn't work. What I want to do is to add this condition to the same code : [rsel_frm_viewInitiatives].monthActual='" &...

Can I have your email ? Because the database excceds the 2MB

Not even with this.. I don't know what could be the reason :(

I'm really thnaking you arnelgp for your time but it still don't filter data ..