Search results

Found the problem :-) How one symbol can give you haedaches for days ... strSQL2 = "logPersoneel.prsID=" & RST!prsID & " AND logInterventies.intDatum>=#" _ & Format(dtStart, "mm\/dd\/yyyy") & "# AND logInterventies.intDatum<=#" _ & Format(dtEind, "mm\/dd\/yyyy") & "#;" Removed the ";" and it...

Yes, did that, but I see no the size limit of 2MB ... If I try to compress and zip the databse, I have a 8MB ...

I tried to upload the database in ZIP-file, but it didn't succeed. I will give the full code, maybe you see the problem ... : Option Compare Database Private Sub cmdSend_Click() Dim DB As DAO.Database Dim RST As DAO.Recordset Dim OUT As Outlook.Application Dim REC As...

The Immediate Window gave me this: (([logPersoneel.prsID]=2) AND ([logInterventies.intDatum]>=#01/10/2012#) AND ([logInterventies.intDatum]<=#31/12/2012#)); No, I don't use periodes in my fieldnames. This is just the way I learned this. I did what you asked, removed all the squared brackets...

Thanx, but the syntax-error is still there. There is a problem in my "WHERE"-part and I can't find it ...

Thanx, I will try to remeber that, and change the first post. But as I said in the original post, I do not use underscores in my code, so the problem of the syntax-error isn't solved yet :(

Hello I just can't get this piece working! I'm pulling out my hairs right now ... I hope one of you can point me to the problem ... I just paste the part where I have a problem with: Dim dtStart As Date Dim dtEind As Date ' ... If Me.cmbKwartaal.Value = "Q1" Then dtStart = "01/01/" &...

Stupid mistake of myself. I forgot to refresh the form first ... Well, back to the first problem. With this the first record chaged itself correctly, but the other records do nothing ... This is what I have: Public Sub Update() On Error GoTo ErrorHandler DoCmd.SetWarnings False...

Hi After a week on training, I finally could try your suggestion. As soon as I converted the code to use this option, I get the error '7878' (Data has changed). I wished the data in my table has changed, but it isn't ... The way the procedure follows ... - After update event calls update...

Hi all I hope one of you great people can help me with this. I searched this forum and google for days now, without finding a helpfull sollution. The situation: I have a main form where I have 3 sections. The form itself, a listbox and a subform (continuous form). The form displays the data...

Hello My name is Kurt, male, 25yo, living in Belgium. My native language is Dutch (Flemish), so my excuses beforehand for the spelling mistakes and bad grammar. I work as a security officer at a multinational company. My specialisation in the team is IT, like programming Access databases for...