Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: slim2
  • Content: Threads
  • Order by date
  1. slim2

    Access Denied

    Can anyone help on this?? This simple window open from the main window causes an &quot;access is denied&quot; error on the open line. I beleive this used to work and now I cannot figure out why it does not? It is tested using I.E. 6.0. on an XP machine. Thanks Les <html> <head> <title>Access...
  2. slim2

    outlook: connection failed!!

    I have two accounts on outlook express. Both use the same email server. One works with no problems, all of a sudden the other one doesn't work. This has been working for about a year. Can anyone give me a clue. I get the following error message: Thanks The connection to the server has...
  3. slim2

    TextWidth error??

    I have a statement i = TextWidth(list(c)) + 400 wich I used in a form. I moved the code to a class module and get an error on TextWidth. Sub or Function not defined If anyone can help I would appreciate it. Thanks in advance.
  4. slim2

    Stored Procedure

    Can anyone point me to where I can get an example of how to create, store, and execute a stored procedure in MS ACCESS. I have searched evrywhere and all I can find is that it can be done with no examples or specifics. Thanks in advance Les
  5. slim2

    Multiple table relationship?

    I have say two tables school1 and school2. Also a group of teachers. A teacher can be in both schools. What would be the best way to handle this. Multiple schoolid fields in the teacher table does not seem like the way to do it?? A third table containg only schoolid and techerid? Of course...
  6. slim2

    outlook express multi-user

    Hello, I have set up three accounts on my outlook express 5.0. When oultook goes to retrieve e-mail it retreives it for all three accounts regardless of which identity is logged on. I am sure there is a way to fix this but cannot find it. Thanks in advance for any help.
  7. slim2

    express will not send msgs

    All of a sudden my outlook express has errored out when sending mail. I have tried everything even reinstalling the latest IE. Can anyine help with this. The error is listed below: Thanks The message could not be sent because one of the recipients was rejected by the server. The rejected...
  8. slim2

    Crystal report design crashing

    Hello, Can anyone give me some advice on how to solve this problem? I had a report that was working and i added some fields to the report. When I refreshed the data Crystal crashed, did not save my changes, and crashes now even without the changes when I refresh the data. This has happened...
  9. slim2

    date field

    Hello, I have a field which is YYYYDDD the DDD is julian date. So 2002015 is 01/15/2002. I have tried every date conversion but cannot get it to work. Is there a way to convert this with a function. Thanks in advance for any help.
  10. slim2

    Suppress header

    Jim if you see this post.. I applied your solution to supressing the header in the group break, and it worked perfectly. I added another line or two to the footer and all of a sudden I am getting a header only page before each printed page. A 2 page footer print at the group break prints 4...
  11. slim2

    Page Break, Suppress Header

    I have a report with the detail suppressed and the information printed in the group footer at a break. The information spans 1 page and I would like to break at a certain spot in the footer and continue the print on a new page but without the page header and then start a new page on the next...
  12. slim2

    Link two tables

    Crystal 8.5, ACCESS 2002. I have a table from which the report is produced and a second unrelated table which contains percentage values used to calculate totals from table one. I cannot link the tables in visual linking because there are no matching fields. There is only one record in table...
  13. slim2

    ERROR 20515 IN VB. HEEEELLLLP

    Error in formula <AmtYldArray>, 'WhilePrintingRecords; ' The remaining text does not appear to be part of the formula. Can anyone tell me how i can find out what the error is. There are many other statements in this formula, and it works fine when running in Crystal.
  14. slim2

    group break

    Can anyone tell me where I can place a formula which would occur at a group break but before the group footer. I want to do a calculation before printing group footers. Tnanks
  15. slim2

    nested IFs

    Is it possible to do nested Ifs in Crystal or If Endif e.g. If x = y Then ...... If a = b Then .....; I also saw If EndIf in the online help but it does not work it will not recognize ENDIF or END IF. I was trying If a = b Then statement statement statement If x = y Then...
  16. slim2

    Running Total formulas missing??

    I create a new runnning total field and all the formulas I have created are not listed. I want to use one as a weighted avg field. Can anyone help with a clue to this problem Thanks
  17. slim2

    Formula calculation on group footer

    Thanks to all who have responded to help me on the shared variable problem on my report. One more question. Can anyone tell me where I can find information, as yet I have not been able to, about when a formula is evaluated and what/where these events are available at. I want to process a shared...
  18. slim2

    the word else is missing?? Crystal formulas killing me

    I keep getting the word else is missing. What am I missing?? There is no information to indicate anything is wrong in crystal help. If not inRepeatedGroupHeader Then ( Global NumberVar Array TotLnDol := [0,0,0,0,0,0,0,0,0,0,0,0,0]; Global numberVar Array NonAcDol :=...
  19. slim2

    Yet another problem in Crystal. Formula in RT???

    I have an array of 13 amts. I print the array field on the print line with this formula: @Jan Global numberVar array TotLnDol; TotLnDol[1]; It seems that I cannot use @Jan in a RT??? Is there any way to do a running total on @Jan???? Thanks
  20. slim2

    How to access shared array in another formula HELP!

    I have an array Shared numberVar array TotLnDol := [13]; I have defined it the same way in another formula to access it, but I do not get any values, I know there are values there. Is this correct? I can find no information in any if the manuals. Thanks

Part and Inventory Search

Back
Top