Search results

But it works, thank you Minty! No more problem, Thanks for both of you!

Thank you Minty, I did what you said and it works! Only one question left: how to get this query work on opening the form?

Thank you guys, but neither solution worked for me, they didn't do anything, the datefield remained the same, didn't disappear. I used the this code as suggested: I removed DbSeeChanges as it turned red. And the other code:

Thanks, but I don't how how to make this through a query. I want to make it done automatically when the form is opened.

Hello everybody, So I want on opening a form to set some datefields back to null or empty by some criteria : Private Sub Form_Load() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = CurrentDb.OpenRecordset("validity") If Not (rs.EOF And rs.BOF) Then...

Success! :) I searched the net and found the right syntax for any locale here: http://allenbrowne.com/ser-36.html So in my case it works with this: stLinkCriteria = "[Datum]=" & Format(Me![Datum], "\#mm\/dd\/yyyy\#"):cool:

I used custom in the sense that it is common. This format is built in the hungarian windows :D I set it custom to mm/dd/yyyy format, it is not built in this windows. I tried yyyy.mm.dd. (which is default), and without dot at the end yyyy.mm.dd but no success. Thanks for your help :)

Now, I figured out, there is somehing wrong with my local date format. If I set windows to to mm/dd/yyyy format, everything OK. But setting it to my custom local format: yyyy.mm.dd. I can't make it work. If nobody can't solve this discrepancy, I have to bow to using the here inconvenient date...

yes, still getting the type mismatch, and sure it is a date field. hard coding the value : [Datum]=#03/13/2017# and stLinkCriteria = [Datum] and I get: Syntax error in number in query expression : '2017.03.13'. and for debug.print stLinkCriteria I get: 2017.03.13.

this is the debug: [Datum]=#03.13.2017# the second # is OK, no /

OK, I tried your original code: stLinkCriteria = "[Datum]=#" & Format(Me![Datum],"mm/dd/yyyy") & "#"still the error : Syntax error in date in query expression '[Datum]=#03.13.2017'.

I changed a little your code, because my regional date format is yyyy.mm.dd. stLinkCriteria = "[Datum]=#" & Format(Me![Datum], "yyyy.mm.dd.") & "#"But I get the error: Syntax error in date in query expression '[Datum]=#2017.03.13.'.

Thank you Minty, I tried it, but what is the exact syntax? with this: stLinkCriteria = "[Dátum]=#" & Me![Dátum] & " #" I get syntax error

Hello, I want to open a subform with this code: Dim stDocName As String Dim stLinkCriteria As String stDocName = "validalas" If IsNull([Nyilvantartasi szam]) And Not IsNull([Cim]) Then stLinkCriteria = "[Cim]=" & "'" & Me![Cim] & "'" End If If...

Thank you, setting their Visible Properties to No worked! Opening the Form using just DoCmd.OpenForm stDocName didn't work, but the point is my problem solved :-)

Thank you, yes it works! Another little problem, that I'd like "Arch2" and "Label1" hidden by default when I open this form. : Dim stDocName As String Dim stLinkCriteria As String stDocName = "validalaslist" stLinkCriteria = "[Arch] = false" DoCmd.OpenForm stDocName, , ...

Hello all! I have inherited an incomplete project, with a limited knowledge to Access and VBA, please help. I have a form, called "validalist". There is a checkbox named "Arch" in the header. I want to hide or reappear another checkbox named "Arch2" and a label "label1" with checking or...

hi everybody, I'm just trying to continue the work of my previous coworker, with minimal knowledge to Access and VBA. I'll appreciate every help:)