Question Creating an outlook-style calendar using bound text-boxes

[NickDenyer]

Hi guys!

Apologies for cross-posting, but I am completely stuck and I'm hoping posting this on General will get more looks than a specific page.

I've hit a stumbling block :banghead: I've created a nice-looking outlook-esqe calendar, with the purpose that people can access it and write in important dates. The calendar (see screenshots) is made up of several unbound text boxes..which is most likely the reason that you can write in them, save it...but on load it will have wiped all the info.

Could you please help me change my VBA (if needed) or instruct me on how to keep that info in??? If I require a table, could you please assist me in how it would look, as I have no idea, and how'd I'd bind these boxes?

Please find attached some screenshots and my VBA for your consideration.

Thanks very very much for the help!!!!!

N

 

[rodmc]

if you want to save the data then your going to have to bind them to a table or query

 

[NigelShaw]

Hi,

couple of things / observations

I've created a nice-looking outlook-esqe calendar

1. The Calendar you have made is distictively familiar to this forum so i would say you didnt 'create' it as such. you probably aquired it and changed the colours.
(I will find the calendar and link back)

2. If you are able to create VBA to arrange the dates in such way as the calendar you have does, then i'd also suspect you have more than enough capability to work out that in order for the fields to display the calendar entries, tables would be required. Afterall, thats what Access does. If you can make this type of Calendar but not think to consider a table and think that the data will stay on the form, then something is terribly wrong.

i may be wrong but i doubt it. Sharading other peoples work as your own isnt very fair to the originator or the hard work put in to provide such a free source coded sample database.

Credit where credit is due


Nidge

 

[rodmc]

think he means he "utilised" the calender in his form, but you are correct, maybe a error in his way explaining his problem rather than making out he did it himself

 

[NickDenyer]

Sorry, yes I do mean 'utilise' and not create, hence why the VBA is so good and I'm here asking for help how very embarrassing :S

"i may be wrong but i doubt it" = that actually really hurt me to read it!!!!!

I don't make a living taking credit for others hard work!!! Hope this clears that up and I am still worthy of receiving help

Thanks! And Sorry!

 

[NigelShaw]

Sorry, yes I do mean 'utilise' and not create, hence why the VBA is so good and I'm here asking for help how very embarrassing :S

"i may be wrong but i doubt it" = that actually really hurt me to read it!!!!!

I don't make a living taking credit for others hard work!!! Hope this clears that up and I am still worthy of receiving help

Thanks! And Sorry!

Hey Nick,

no hard feelings I never accused you of making a living taking other peoples credit. It was just the way you had described your problem which was a bit misleading. Anyway, all clear now and it doesnt hurt to highlight the importance of origination and effort.

There are a lot of experienced people here willing to help, as long as you as the wright questions

The Calendar demo you have been using. Doesnt it already have a table? Im pretty sure it did. Have you looked at Peter Hibbs Calendar? thats a really good one and can be found at

http://www.rogersaccesslibrary.com/forum/uploads/20/Flex_Grid_Appointment-Booking_Demo.zip

Hope that helps and as the Irish proudly say-

dont take a fence, you'll an owful horl in a me gareden!

Nidge

 

[NickDenyer]

I very rarely ever re-read something I have written before I send it; I think now I'll make sure when I write something its 100% clear bot no worries. I got worried there that I might suddenly become an enemy to Access World Forums!!!! I'm glad that's all settled!

The calendar demo I FOUND (!) didn't have a table, no...unless its hidden somewhere??? It was just a sub-form.

I've had a look at the file you've sent but I keep getting debugging messages, and it only partly runs. This looks very good but its not really what I'm after: I want to have a celndar like the one I attached where people can add dates into it. It sounds so simple saying it but doing it appears to be hard!!!! I know how to bind text boxes to tables/queries etc but I don't know how to design a table that would link all this in!

And when I modified that calendar it seemed so so easy!!!! I've only been using Access for about a month now and I thought I'd got to a point where I didn't need help!!!!!

Haha, I can relate to the quote; being 1/2 Irish! Though I'm not to fussed about gardening...