date picker and breakpoint issues during app migration to Access 2007

[Xavier]

Hello,

I am in the process of migrating an application from Access 2003 to Access
2007 (RTM running on Vista RTM). This applications contains a lot of vba
code and I am facing 3 issues:

1. I used some DateTimePickers in my application. I know that there is now a
built-in date time picker and I am trying to use it. I have one question
about this, since the control is a text box, am I correct if I assume that
the data returned by the control will be a string and not a date ? If so, I
guess that I should adapt my code like this: "rsPerformedWork!dteDate =
dtpCalendar1.Value" would become "rsPerformedWork!dteDate = CDate
(newtextbox.Value)".

2. The second issue that I am facing, is that breakpoints don't seem to work
anymore ??? I have declared my applications in the trusted locations and I
have enabled macros.

Any help or pointer would be appreciated.

Thanks,

Xavier

 

[Allen Browne]

Re #1, the new built-in data picker appears in Access 2007 beside any text
box that is bound to a date/time field (unless you specify an input mask.)
It also appears automatically beside an unbound text box that has its Format
property set to one of the date types (such as Short Date.) There is no need
to write any code or convert data types. If you don't want the date picker
to appear, there is a property you can set to No. Again, no code is needed.

Break points should work as before. Try decompiling the application in
Access 2003 before conversion. Then make sure Name AutoCorrect is off, and
compact twice. If you are really stuck, you can achieve the same result by
inserting the line:
Stop

 

[Tom Wickerath]

Hi Xavier,

To add to Allen's second answer, make sure that "Use Access Special Keys" is
enabled in Access 2003 (Tools > Startup), in order for break points to work.
I'm not sure where the equivalent setting is found in Access 2007.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html

 

[Xavier]

Thank you !

Following your advice and Allen's, I am now able to fine tune my application
for Accesss 2007.

Xavier