Code Issue

[Jkittle]

I have a calendar that I have tried to modify for my vacation property database. I'm trying to add reservation information in a form to update a calendar so I can see availability but I'm getting run time errors and my calendar is not displaying the information.

I found a lot of the code here and tried to modify it. Help!

 

[Zigzag]

Hi

In the on current event of your form there are two lines of code that set myset
Try replacing them with this code.

Set myset = CurrentDb.OpenRecordset("SELECT [T-Reservation Calendar].*FROM [T-Reservation Calendar];", DB_OPEN_SNAPSHOT)

Garry

 

[Jkittle]

Zigzag,

That worked thanks!!! Any chance you can look and see why the report I created isn't working in the same DB. I've been working on this for two lousy days.

 

[Zigzag]

When the error happens, go click on debug.

When the fulty code is showing press CTRL + F to find.

Find and replace "F-add reservation" with "F-Reservation Calendar"

Dont forget to save.

Try that and let me know

Garry

 

[Jkittle]

Thanks again! This worked