Calender/Appointment Database

[kamphuuzz]

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 use the date that is the date from that block. I've tryed using the TempVars function, but can't find out where to place this function to get it working like it should.

Can you guys help me out?

 

[kamphuuzz]

Here it is

 

[kamphuuzz]

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

 

[HiTechCoach]

Hi,
When I double click a block, it will open a form to make a new appointment.

I tried double-clicking on several of the forms and never got a new appointment form to open.

Can you guys help me out?

Need more detailed instructions on exactly how to duplicate what you are doing from the time you open the database.

 

[kamphuuzz]

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

 

[HiTechCoach]

Thanks for the update.

Where is the "block" you were doubling clicking?

Glad to here you got it solved.

Good luck with your project.

 

[kamphuuzz]

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

 

[HiTechCoach]

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

Thanks for the info.

 

[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)
  TempVars!TempDate = "" & CDate(Me![txtDayBlock02].Tag) & ""
  DoCmd.OpenForm "frm_AfspraakDetails", acNormal
End Sub

 

[HiTechCoach]

Thanks for posting your solution.