By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,323 Members | 2,006 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,323 IT Pros & Developers. It's quick & easy.

DateTime Picker Nightmare!!

P: 108

I have an issue with my datetime picker where its not active until I select another field on my form.

Any field on the form.
I have tried to manually setfoucus and give values with events and form load with VBA without luck (unfortunately I cant remember my exact actions to repeat here, apart from banging head on keyboard alot)

If i right click when running the form and action 'remove filter/sort' it automatically becomes active too.

All this has become an issue because dll files and other components on my pc are different than those used at my university. Very confusing.

All machines (university and mine) run acess 2003 (mine Sp2 theres Sp1) but for some reason it states my database is acess 2000 format, really confused.

Other than that all is good :)
Nov 27 '06 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,661
If it reports the database as Access 2000 format then surely it will let you upgrade it to the latest version?
Remember to take a back-up first (or upgrade to different file instead).
Nov 27 '06 #2

P: 108
Im not worried about the access 2000 file format at the moment.

Think I need a break from access keep making silly mistakes!

My booking table has an autonumber field as the unique reference for a booking.
On my form load to enable the user to add a new record I have added the following

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer
  2.              DoCmd.RunCommand acCmdRecordsGoToNew
  3. End Sub
The Datetime picker is only activated when the reference number is autogenerated, this happens when a form field is bound to a table field.

I know its trivial but somehow seeing the datetime picker become active after updating a field doesnt look athestically pleasing.

Is there anyway around this?

PS Apologies for not using CODE tages in other posts!
Nov 27 '06 #3

Expert Mod 15k+
P: 31,661
I wish I could help you but I've never dealt with a date/time picker.
I can't think of anything I know which could help you on this one.
Nov 27 '06 #4

Expert Mod 10K+
P: 14,534
When you speak of a date/time picker are you talking about an activeX calendar control. If so what code are you using.
Nov 28 '06 #5

Expert 5K+
P: 8,434
Perhaps it would help if the date/time field on the table had a default value?
Nov 28 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.