Recent content by nonturbo

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...

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

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...

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...

..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...

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...

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...

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?

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...

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...

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.

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...

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

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...

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...