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 derfloh 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: *

  1. nonturbo

    How do I SUM it up?

    I've got a report with 2 levels of grouping. First is account number, then period of the year. Most accounts have a row for each period: 1, 2, 3, and 4; but some accounts were opened or closed during the year, so some accounts might just have a few periods. The "Account Number Header&quot...
  2. nonturbo

    How to add up a control from the Detail section into the Footer?

    After much trouble, I abandoned the idea and am attempting to recreate the report using a query rather then a whole bunch of DLookups with SQL code/VBA. Right now I'm having problems with Sums and Grouping.. If you'd still like to help, please post in the other thread in this group. Thanks.. NT
  3. nonturbo

    How to add up a control from the Detail section into the Footer?

    PLEASE HELP! I've got a report driving me crazy, the problem I'm having is that I have a control/text box in the Detail section (lets call it TestCtrl) which is a currency field that is generated from some good ole' VBA. I wish to total up the TestCtrl column into the Report Footer. If TestCtrl...
  4. nonturbo

    How can I use a SQL formatted query in VBA Code?

    Hey guys, I created a query with the Query builder and tested it. It works fine. Basically, I want the query to count the number of Active accounts at any given time. It should just return a number, ie 154. I want to be able to use the result, as in our example 154 in VBA code, but I'm not sure...
  5. nonturbo

    FTP Server Behind Linksys Router Problems

    ..Oh yeah, almost forgot.. The reason I choose such high port numbers is so that I won't run into problems of having other services on any of the same ports (huge potential security risk). Allowing the default IIS's 1024-5000 to pass over to the server will no doubt be asking for trouble...
  6. nonturbo

    FTP Server Behind Linksys Router Problems

    IF you want to run a reliable, powerful FTP server with more configurablility, security, and options under Windows behind a Linksys (or other routers, I'm guessing) Serv-U is the best way to go (IMHO). I run Serv-U as a service 24/7 and since switching from IIS > Serv-U I'd ***NEVER*** go back...
  7. nonturbo

    FTP Server Behind Linksys Router Problems

    If you have the original firmware on your Linksys Router, then it's probably time to upgrade. Visit Linksys.com and find the Firmware update for your router. As long as you know the IP address of the router and password, you should have no problems at all performing the update. I have had a few...
  8. nonturbo

    How can I create an Excel-Style Grid report?

    sko: Worked like a charm! That's EXACTLY what I was looking for. Thanks. You deserve a star! Setting Format as % is done where, in the Query or on the report's Return control? If in the Query, HOW?
  9. nonturbo

    FTP Server Behind Linksys Router Problems

    I solved the problem by switching the FTP server from IIS to Serv-U 4.0. Haven't had a single problem since. In my Linksys I have ports 20 and 21 (TCP) forwarding to my FTP Server's Private IP. Serv-U is a MUCH MUCH MUCH better FTP server with a whole slew of options, and its free to try out...
  10. nonturbo

    How can I create an Excel-Style Grid report?

    I am using Access 2002 (XP) and am not a complete newbie, yet I feel like I'm always learning new things when it comes to Access.. I've got a simple table with these 4 fields: - ID (Autonumber) - Year (ie: 1999, 2000, etc) - Quarter (can ONLY be 1,2,3 or 4) - Return (a decimal, ie: 0.0131...
  11. nonturbo

    create pdf based on report?

    It is possible to select the printer programmatically via VBA, as I've seen it done before, however I cannot provide any code. I'd look around on google and see if you find anything.
  12. nonturbo

    Use Access 97 Add-in with Access 2002

    I have an MDA file of the Internet Data Transfer Library written for Access 97. This will allow me to use FTP via VBA to backup the backend of the database to a remote FTP site. More Info can be found here: http://www.mvps.org/access/modules/mdl0037.htm The problem I have is that I cannot seem...
  13. nonturbo

    create pdf based on report?

    Just get Adobe Acrobat 5, and "print" the report to Acrobat.
  14. nonturbo

    Can it be done!? Send file to FTP server from Access 2002

    Is it possible to send a file to an FTP server from within Access without calling any separate processes (ie: an external FTP client)? I've created a backup module, and would like the ability to store a copy of the backup on our FTP server. I would also like the ability to ping the FTP server...
  15. nonturbo

    FTP Server Behind Linksys Router Problems

    I've just upgraded my Linksys firmware to the 1.42.6 release, and as expected, this did not solve the problem. As far as FTP clients go - I've tried using MSIE 6 and BulletProof FTP, as well as the DOS FTP command, and a few Linux clients. I'm mostly using the latest release of BulletProof FTP...
  16. nonturbo

    How to format a String as Currency

    That seems like it'll work too. Any ideas for the label sizing problem?
  17. nonturbo

    FTP Server Behind Linksys Router Problems

    I'm having very strange problems with the IIS FTP server behind my Linksys firewall/router. I've setup port forwarding for port 20 & 21 and allowed both TCP and UDP (I know I don't need UDP enabled) to forward to the FTP server's private IP. Being that I do not want the FTP server completely...
  18. nonturbo

    Bat file to update database.

    A batch file is essentially just a list of commands your throwing at the OS. True, there are some advanced things you can do with them, but BAT files are rather simple. If you're just getting started and you use an NT/2K/XP system, then you might want to consider looking into writing .CMD files...
  19. nonturbo

    How to format a String as Currency

    If I just have myTotal as a label, and set the format to currency, the value comes out fine. The problem is that the value of myTotal is the product of a complex string of calculations, with myTotal being very precise. For example, when I'm just looking for $0.03, it will print out...
  20. nonturbo

    Bat file to update database.

    Also, adding "@echo off" on the first line of the batch file / login script will effectively hide all of the commands from being printed on the screen. Also, you won't need to add an @ before each line to hide the line.

Part and Inventory Search

Back
Top