|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
"Time and Billing" database question -- accessHi, I downloaded the “Time and Billing†database for access from the
“templates†section of your website yesterday. The link is: http://office.microsoft.com/en-us/templates/TC010184611033.aspx. I have office 2003 and Windows XP. Everything works fine until I click on “Projects.†When I click on “Projects,†instead of seeing numbers in the fields for “Total Hours,†“Hourly Billings†and “Total Expenses;†the word “#Name?†appears in each field. Also, the word “#Error†appears in the “Total Billing†and “Amount Due†fields. I know the program is adding up all of my hours because the reports print correctly. Any idea how I can fix the error messages? Please, please, please help! Best, Susanna A few things:
First, I downloaded the application, and with a2003, it runs just fine. 2nd: The forms ref works fine also. You do not need to re-write, or change the forms ref. While it is true that you normally need the full forms reference, since the control is on the current form..then you can ELIMINATE the main forms references (so, all those other posts about trying to fix the forms ref is a wild goose chase...and....and the download as "is" should work just fine on your computer). You do NOT need to qualify the full forms ref as the posters have suggested. So, what I would do is launch the application, but hold down the shift key..and not have/allow the main menu form (often called a switch board) run. Now, while looking at the application, hit ctrl-g, and then go debug-Compile "Time and Billing" Do you get any errors? It would not make sense for this application to be posted with errors...as the amount of feedback would be so great as to have the application removed. It is certainly only a "sample" application..but it does run just fine on my computer.. What this means is some how you accident modified the application, (or modified references). Or, there is perhaps something wrong with your install of office. So, try the above compile idea.....and make sure it compiles. As a further thing to try, would be to convert the database to 2002-2003 format, and give that a try... Tools->database utilities->convert database. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal Okay, I was able to get to a point where most of the problems with the
template disapeared simply by putting Macro security to low (risky, I know, but if I only ever use Access for trusted databases I should be fine), so now everything works just fine, right up to the moment when I hit the "Preview Invoice..." button in the "Client" form. When I hit this button, the "Print Invoice" Form comes up propperly, and the Project ID and name display propperly, but no items appear under the words "Time worked on this project for the specified time period." Also, all information under "Total Hours", "Total Hourly Billings", etc. show up as zeros. When I press the "Preview Invoice..." button, the "Invoice" Report comes up, with all company and client information correct, but nothing listed under either "Time:" or "Expenses:" and an "Invoice Total" of zero. Any suggestions? Show quote "Albert D. Kallal" wrote: > A few things: > > First, I downloaded the application, and with a2003, it runs just fine. > > 2nd: > The forms ref works fine also. You do not need to re-write, or change > the forms ref. While it is true that you normally need the full forms > reference, since the control is on the current form..then you can ELIMINATE > the main forms references (so, all those other posts about trying to fix the > forms ref is a wild goose chase...and....and the download as "is" should > work just fine on your computer). You do NOT need to qualify the full forms > ref as the posters have suggested. > > So, what I would do is launch the application, but hold down the shift > key..and not have/allow the main menu form (often called a switch board) > run. > > Now, while looking at the application, hit ctrl-g, and then go debug-Compile > "Time and Billing" > > Do you get any errors? > > It would not make sense for this application to be posted with errors...as > the amount of feedback would be so great as to have the application removed. > It is certainly only a "sample" application..but it does run just fine on my > computer.. > > What this means is some how you accident modified the application, (or > modified references). Or, there is perhaps something wrong with your install > of office. > > So, try the above compile idea.....and make sure it compiles. As a further > thing to try, would be to convert the database to 2002-2003 format, and give > that a try... > > Tools->database utilities->convert database. > > -- > Albert D. Kallal (Access MVP) > Edmonton, Alberta Canada > pleaseNOOSpamKallal@msn.com > http://www.members.shaw.ca/AlbertKallal > > > >Now, while looking at the application, hit ctrl-g, and then go did you try the above?>debug-Compile > "Time and Billing" > > Do you get any errors? I'm fairly certain I did, because when I go into the Global Code under
Modules the Compile option isn't even available under the Debug menu, it's been greyed out. Show quote "Albert D. Kallal" wrote: > >Now, while looking at the application, hit ctrl-g, and then go > >debug-Compile > > "Time and Billing" > > > > Do you get any errors? > > did you try the above? > > > I too am trying to find a solution for this exact scenario. I have already
tried the macros on low security and have gotten the same results: 0's and no projects associated with the invoice. This is better than the #erro messages in the fields, but not right. I still haven't tried the solution mentioned by Russell (while looking at the application, hit ctrl-g, and then go debug-Compile "Time and Billing") and will try that next, but just wanted to let you all know that I am also running Access2003 and make no changes to the db as downloaded from MS, I have all latest security patches running and no other complaints about my machines config. In fact, I have tried this on several machines and it is the same results. So I will try a few more things and hope that it works, but if anyone has any more suggestions, please feel free to bring them to our attention. thanks Show quote "Russell Ault" wrote: > I'm fairly certain I did, because when I go into the Global Code under > Modules the Compile option isn't even available under the Debug menu, it's > been greyed out. > > "Albert D. Kallal" wrote: > > > >Now, while looking at the application, hit ctrl-g, and then go > > >debug-Compile > > > "Time and Billing" > > > > > > Do you get any errors? > > > > did you try the above? > > > > > > See
http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678 MS Shane wrote: Show quote > I too am trying to find a solution for this exact scenario. I have > already tried the macros on low security and have gotten the same > results: 0's and no projects associated with the invoice. This is > better than the #erro messages in the fields, but not right. > > I still haven't tried the solution mentioned by Russell (while > looking at the application, hit ctrl-g, and then go debug-Compile > "Time and Billing") and will try that next, but just wanted to let > you all know that I am also running Access2003 and make no changes to > the db as downloaded from MS, I have all latest security patches > running and no other complaints about my machines config. In fact, I > have tried this on several machines and it is the same results. > > So I will try a few more things and hope that it works, but if anyone > has any more suggestions, please feel free to bring them to our > attention. > > thanks > > "Russell Ault" wrote: > >> I'm fairly certain I did, because when I go into the Global Code >> under Modules the Compile option isn't even available under the >> Debug menu, it's been greyed out. >> >> "Albert D. Kallal" wrote: >> >>>> Now, while looking at the application, hit ctrl-g, and then go >>>> debug-Compile >>>> "Time and Billing" >>>> >>>> Do you get any errors? >>> >>> did you try the above? -- Joan Wild Microsoft Access MVP The info in the link works, but only partly. For it to have full effect, you
must also alter similar (but not the same) code in the "Print Invoice" form. This has worked for me. Also, I have discovered that the "Begin Date" and "End Date" fields cannot be left blank. Show quote "Joan Wild" wrote: > See > > http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678 It looks like the discussion ended without a solution. Did anyone ever figure
it out, or is it just a crappy template? Show quote "Russell Ault" wrote: > The info in the link works, but only partly. For it to have full effect, you > must also alter similar (but not the same) code in the "Print Invoice" form. > This has worked for me. Also, I have discovered that the "Begin Date" and > "End Date" fields cannot be left blank. > > "Joan Wild" wrote: > > > See > > > > http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678 Have you followed the steps outlined in the google group thread? That
supplimented with Russell's notes should solve your problem. Are you still having problems? As for the usefulness of the template, it might be looked at as a starting point. I doubt that any of the templates can be used as is; they'd all need tweaking I would think. Show quote "KHAN SUL-O" <KHAN SU***@discussions.microsoft.com> wrote in message news:5ECD7073-A11A-4684-8F22-83BE05799BD3@microsoft.com... > It looks like the discussion ended without a solution. Did anyone ever > figure > it out, or is it just a crappy template? > > "Russell Ault" wrote: > >> The info in the link works, but only partly. For it to have full effect, >> you >> must also alter similar (but not the same) code in the "Print Invoice" >> form. >> This has worked for me. Also, I have discovered that the "Begin Date" and >> "End Date" fields cannot be left blank. >> >> "Joan Wild" wrote: >> >> > See >> > >> > http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678 -- Joan Wild Microsoft Access MVP I checked the Google group link and tried to follow the instructions but I
can't find the "Broken Expressions". I used ctrl-g to get to the modules and tried to find it there. What am I doing wrong? Also, what is "sandbox mode". I am reasonably computer literate but not particularly experienced with Access. When I tried the debug-compile there was no indication of anything happening. Thanks! Show quote "Russell Ault" wrote: > The info in the link works, but only partly. For it to have full effect, you > must also alter similar (but not the same) code in the "Print Invoice" form. > This has worked for me. Also, I have discovered that the "Begin Date" and > "End Date" fields cannot be left blank. > > "Joan Wild" wrote: > > > See > > > > http://groups-beta.google.com/group/microsoft.public.access/msg/9c97a482f446a678 "Dana" <D***@discussions.microsoft.com> wrote in message When you use find, be sure to check off 'search entire project' to find the news:DB8E9706-118B-4FA2-A17C-3584174A4461@microsoft.com... >I checked the Google group link and tried to follow the instructions but I > can't find the "Broken Expressions". I used ctrl-g to get to the modules > and > tried to find it there. code you are looking for. You may find that going to Tools, Macro, security and setting it to low will get things working for you. -- Joan Wild Microsoft Access MVP Thanks Joan. At the risk of sounding like a complete idiot, there is security
option under Tools, Macro. I looked other places to set this option (e.g., Tools, Security) and did a help search and can't find anywhere to set any security setting to low. I am using Access 2002. I appreciate your help. I ever get this database working we'll have to have a celebration! Thanks again, Dana Show quote "Joan Wild" wrote: > "Dana" <D***@discussions.microsoft.com> wrote in message > news:DB8E9706-118B-4FA2-A17C-3584174A4461@microsoft.com... > >I checked the Google group link and tried to follow the instructions but I > > can't find the "Broken Expressions". I used ctrl-g to get to the modules > > and > > tried to find it there. > > When you use find, be sure to check off 'search entire project' to find the > code you are looking for. > > > You may find that going to Tools, Macro, security and setting it to low will > get things working for you. > > -- > Joan Wild > Microsoft Access MVP > > > "Dana" <D***@discussions.microsoft.com> wrote in message That's the option I meant. Tools - Macro - Security. Did that work for news:A49D6808-3D36-4F04-AED4-0D1EF14EDC80@microsoft.com... > Thanks Joan. At the risk of sounding like a complete idiot, there is > security > option under Tools, Macro. I looked other places to set this option (e.g., > Tools, Security) and did a help search and can't find anywhere to set any > security setting to low. I am using Access 2002. I appreciate your help. I > ever get this database working we'll have to have a celebration! you? -- Joan Wild Microsoft Access MVP Oh the power of one little word! What I meant was there was NO
Tools-Macro-Security. There was Tools-Macro, but no security option and not other options where I could set the security. Show quote "Joan Wild" wrote: > "Dana" <D***@discussions.microsoft.com> wrote in message > news:A49D6808-3D36-4F04-AED4-0D1EF14EDC80@microsoft.com... > > Thanks Joan. At the risk of sounding like a complete idiot, there is > > security > > option under Tools, Macro. I looked other places to set this option (e.g., > > Tools, Security) and did a help search and can't find anywhere to set any > > security setting to low. I am using Access 2002. I appreciate your help. I > > ever get this database working we'll have to have a celebration! > > That's the option I meant. Tools - Macro - Security. Did that work for > you? > > > > -- > Joan Wild > Microsoft Access MVP > > > "Dana" <D***@discussions.microsoft.com> wrote in message Reset your menubar (View, Toolbars, Customize). Select the Main Menu (don't news:75925AC9-6551-473D-8848-1C1D8FFE9043@microsoft.com... > Oh the power of one little word! What I meant was there was NO > Tools-Macro-Security. There was Tools-Macro, but no security option and > not > other options where I could set the security. uncheck it thought) and hit Reset . -- Joan Wild Microsoft Access MVP  |
|||||||||||||||||||||||
Other interesting topics