If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Access 2007 form controls problems
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 |
#3
|
|||
|
|||
Access 2007 form controls problems
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 |
#4
|
|||
|
|||
Access 2007 form controls problems
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 |
#5
|
|||
|
|||
Access 2007 form controls problems
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 |
#6
|
|||
|
|||
Access 2007 form controls problems
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 |
#7
|
|||
|
|||
Access 2007 form controls problems
"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 |
Thread Tools | |
Display Modes | |
|
|