Use calendar on form to update dates in table

[webmeister]

I have a form bound to a table that has a bunch of dates in it. What I want to do, is to be able to have pop-up calendars on the form next to each date field, where the user can select dates from the calendar, then have those dates display on the form, and last but not least, update the date fields in the table.

At the moment, the form I'm working with let's me pick dates from little pop-ups and display the dates, but when I exit the form and then come back into it, the dates are gone! In other words, I'm missing something in the process between the dates displaying onthe form and the dates getting into my table.

If anyone has an idea as to what I might be doing wrong, I wouldappreciate your ideas and suggestions.

Thanks in advance. I don't know where I'd be without this forum!

 

[RuralGuy]

Try one of these Calendar Links.

 

[webmeister]

Ruralguy,

Thanks for responding! I'll play around with the link you provided and see what comes up!

 

[webmeister]

Rural Guy,

Those calendar links were good, but...... I still am unable to do what I want.

I have a little icon on my form, which is where I placed the calendar code. That works great - a calendar appears and I can pick my desired date, which then shows up in a text box on my form. However.... this text box is bound to a field of my underlying table and you would think the date would then end up in my table. When I get out of Access and then back into my database, the table does not contain any date data.

How do I get the data that is displayed into my table?? I tried coding a query immediately after the calednar code, but then I get a message that in effect says, "Someone else has been working with this data. Do you want to override?"

What am I missing? Any ideas?

Thanks in advance for any help provided.

 

[RuralGuy]

Web Meister,
Unless you have some code that is removing the date value, what you describe should work. There must be something else going on that we're not seeing. Any chance you can post a stripped down version of your db that demonstrates the problem so we can look at it?

 

[Jenn68]

Here is the best tutorial I have found for calendars. http://www.fontstuff.com/access/acctut09.htm
It is included in the list of links that were posted earlier. In this tutorial is a section "Code to Hide the Calendar and Transfer the Date" If you can follow the code and can figure out which of the example names you need to substitute with your db names, you should be good to go.

Hope this helps... this is the tutorial I used to learn this particular coding...

Jenn

 

[webmeister]

Rural guy,

I'll post my DB this coming Monday, as I'm about to leave for the day.

Jenn,

I'll check out the link you sent me. Thanks!

I appreciate you all for being willing to assist. How very nice!

 

[webmeister]

Rural Guy,

What I ended up doing was to completely wipeout the date fields in my table and then insert completely new date fields in my table. That appeared to resolve my problem....not 100 percent, but about 80 percent.

I still have some date fields that are giving me fits and am in the process of researching. Why the dang thing works for some date fields but not for others is frustrating. I use the same exact queries and code on every single date field.... works on some date fields but not on others.

"Ain't Access fun ???"

 

[webmeister]

Rural Guy,

What I ended up doing was to completely wipeout the date fields in my table and then insert completely new date fields in my table. That appeared to resolve my problem....not 100 percent, but about 80 percent.

I still have some date fields that are giving me fits and am in the process of researching. Why the dang thing works for some date fields but not for others is frustrating. I use the same exact queries and code on every single date field.... works on some date fields but not on others.

"Ain't Access fun ???"

 

[webmeister]

Sorry about the double post! My machine is abnormally slow today and I must've hit send twice by mistake

 

[RuralGuy]

You could still try posting your db that can demonstrate the problem. It is easier than taking wild guesses from here.

 

[greaseman]

I got it working!!

What I did was to remove the fields in my table that weren't working, and then re-entered the fields into my table, but instead of calling a field, for example, "DateReviewed", I now call it "DateReviwedA". I then changed all field names in my form to match the table field names just created.

I then used the suggestion from Jenn68's posting, of using the MS ActiveX calendar (although I realize this can cause problems once put onto other PCs) and modifying the code samples from her posting to reflect what I neded.

Lo and behold, all date fields now work! It was interesting that removing and replacing the table field names seems to have done the trick. I don't know how it made everything click, but "I ain't askin' no question!!!"

Thanks so much for your offers of help and for your assistance along the way!