Access 2007 form controls problems

I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got
everyting running perfectly.

I then ran the database with the switchboard on a laptop which had
Access 2003, and after entering data into the database whilst away on
business, I transferred the database with added information back to my
desktop pc which has Access 2007.
The timer does not run in that the time shown stays constant and does
not refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression
you entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks

you wrote "I transferred the database with added information back to my
desktop"

which I assume means you wrote over the mdb

you should recover the original 07 application....if you deleted it ---
return it from the recycle...or with Vista you can turn back to the original
version.....

then only import the data via importing tables rather than moving the full
mdb between versions




"Bob H" wrote:

I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got
everyting running perfectly.

I then ran the database with the switchboard on a laptop which had
Access 2003, and after entering data into the database whilst away on
business, I transferred the database with added information back to my
desktop pc which has Access 2007.
The timer does not run in that the time shown stays constant and does
not refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression
you entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks

Sounds like a reference problem. See Doug Steele's web page below to help
solve your problem.

http://www.accessmvp.com/djsteele/Ac...nceErrors.html

"Bob H" wrote in message
...
I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got everyting
running perfectly.

I then ran the database with the switchboard on a laptop which had Access
2003, and after entering data into the database whilst away on business, I
transferred the database with added information back to my desktop pc
which has Access 2007.
The timer does not run in that the time shown stays constant and does not
refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression you
entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks

Actually, I realised that I didn't transfer the database file at all, as
I opened it up straight from the flash drive. So I then opened up the
older mdb file from my desktop PC and imported the tables from the file
on the flash drive. The only downside I noticed was that for some
reason, the newer data from the file on the flash drive was not
imported, only upto the newer data. Maybe this was because the newer
data was written to using Access 2003????
Anyway, lo and behold, the flash drive file then all at once worked as
it did previoulsy!

Thanks

NTC wrote:
you wrote "I transferred the database with added information back to my
desktop"

which I assume means you wrote over the mdb

you should recover the original 07 application....if you deleted it ---
return it from the recycle...or with Vista you can turn back to the original
version.....

then only import the data via importing tables rather than moving the full
mdb between versions




"Bob H" wrote:

I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got
everyting running perfectly.

I then ran the database with the switchboard on a laptop which had
Access 2003, and after entering data into the database whilst away on
business, I transferred the database with added information back to my
desktop pc which has Access 2007.
The timer does not run in that the time shown stays constant and does
not refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression
you entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks

Pete could you please repost your last post about my form problem re LTD and
NTD where I need to put the code/syntax you posted for me, because the last
4/5 posts have been deleted from 2 mail servers I use.

Thanks

"Pete D." wrote in message
...
Sounds like a reference problem. See Doug Steele's web page below to help
solve your problem.

http://www.accessmvp.com/djsteele/Ac...nceErrors.html

"Bob H" wrote in message
...
I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got everyting
running perfectly.

I then ran the database with the switchboard on a laptop which had Access
2003, and after entering data into the database whilst away on business,
I transferred the database with added information back to my desktop pc
which has Access 2007.
The timer does not run in that the time shown stays constant and does not
refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression you
entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks

Yes, in the form NTD text box place that in the NTD control source. After
you enter the
date and tab out of the LTD field NTD will reflect the actual date required.
I inclulded the link for Dateadd function as thought you might want to use
1 year instead of days. Play with it, you'll figure it out. Also this one
example will help you with many forms in the future.


"Bob H" wrote in message
...
Pete could you please repost your last post about my form problem re LTD
and NTD where I need to put the code/syntax you posted for me, because the
last 4/5 posts have been deleted from 2 mail servers I use.

Thanks

"Pete D." wrote in message
...
Sounds like a reference problem. See Doug Steele's web page below to
help solve your problem.

http://www.accessmvp.com/djsteele/Ac...nceErrors.html

"Bob H" wrote in message
...
I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got
everyting running perfectly.

I then ran the database with the switchboard on a laptop which had
Access 2003, and after entering data into the database whilst away on
business, I transferred the database with added information back to my
desktop pc which has Access 2007.
The timer does not run in that the time shown stays constant and does
not refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression
you entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks

"Bob H" wrote in message
...
Actually, I realised that I didn't transfer the database file at all, as I
opened it up straight from the flash drive. So I then opened up the older
mdb file from my desktop PC and imported the tables from the file on the
flash drive. The only downside I noticed was that for some reason, the
newer data from the file on the flash drive was not imported, only upto
the newer data. Maybe this was because the newer data was written to using
Access 2003????
Anyway, lo and behold, the flash drive file then all at once worked as it
did previoulsy!

Thanks

NTC wrote:
you wrote "I transferred the database with added information back to my
desktop"

which I assume means you wrote over the mdb

you should recover the original 07 application....if you deleted it ---
return it from the recycle...or with Vista you can turn back to the
original version.....

then only import the data via importing tables rather than moving the
full mdb between versions




"Bob H" wrote:

I built a customised switchboard in Access 2007 and crated buttons using
the onClick event. Also I inserted the Date/Time control and got
everyting running perfectly.

I then ran the database with the switchboard on a laptop which had
Access 2003, and after entering data into the database whilst away on
business, I transferred the database with added information back to my
desktop pc which has Access 2007.
The timer does not run in that the time shown stays constant and does
not refresh even though it worked ok before.
I added Me.txtShowTime=Now! into a sub event, and changed the
TimerInterval of the form to 1000. Now it does not work

Also on the swithboard buttons, I made them transparent and changed the
cursor on hover property to Hyperlink hand, now that does not work.
When I try to click. Access throws up an error saying 'The expression
you entered has a function name that Microsoft Office Access can't find'

How can I get these controls working again without starting all over?

Thanks