Recent content by kamphuuzz

Here's what I've done. I've added in every blocks privat sub a TempVars. When I double click a block, it'll open the frmPatiens form and automaticly the date field will be using the date form that block. Exapmple of one block: Private Sub txtDayBlock02_DblClick(Cancel As Integer)...

I've you view the calendar, every day is a "block" with each a privat sub behind it.

The form frmPatients is the form that should open when double click a block. But I think this is disabled in the VBA code. But I marked this topic as "solved" because I've found it out myself :)

Got it. Adding a TempVars to every block's privat sub did the trick :)

Here it is :)

Hi, I've got a question about the Calender/appointment database which has been posted in the sample database section of this forum. (can't post any links yet :) ) When I double click a block, it will open a form to make a new appointment. But what I want, is that the form automatically will...

I've copied the changes to my own database, did a couple of test and it looks perfect! I say the problem is solved. Thank you very, very much!!

Did a couple of tests but couldn't find anything go wrong. It really looks like you've cracked it. Thank you very much Gasman!!

It's not completely working. I changed the line: strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear) back to: strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear) to make the date matches the right day. But this only works for the month March. When ik go to april, it'll set the 1st of...

[SOLVED] Calender Hello, I have found a calender databse witch I wanna use in one of my own databases. But.. on the form the weeks start on sunday, I want the week to start on Monday but I can't figure out how to do it. I hope you guys can help me. My VBA skills are basic, but still learning...

Hello everyone, I'm a 29 years old guy from the Netherlands and still working on my VBA skills. Hope to find some good answers on this site. :)