Search results for query: *

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

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

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

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

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

I know I've seen somewhere a way to format a string. Right now I have (for example) MyString = "Total: " & MyTotal However, MyTotal is showing up as 13.2345634545E02, where I'd just like it to show up as $0.13. Thanks in advance for helping out with such an easy question! :) Also...

I've been working for quite awhile on this, and I know someone here can help me with probably one line of code, or just point me in the right direction. I've got a report that prints mailing labels. I have a form that pops up from the reports OnOpen() event to ask some options (what label to...

Simply put, I have a form where I've hidden the built-in nav buttons and made my own using the button wizard to make the following buttons: First, Previous, New, Next, and Last. All is well here. I took it a step further and added this code to the form's OnCurrent event: Dim recClone As...

When I go to File > Page Setup, I set my margins at .125 but when I go to the next field they reset to .25 I can make the margin LARGER then .25, but why would I want to!? What gives? I've got a DeskJet printer, could that be the reason? Can I set the margins through VBA to override the page...

I'm sure plenty of you have encountered this problem: Mailing Labels. The DB I'm working on needs the ability to print mailing labels. We're using Avery 5160 Labels and a HP DeskJet 600C Printer. I used the wizard under Access XP to create the labels, but due to the sophistication of the...

I'd like to disable the built-in navigation controls on a form and use a combobox / drop-down box to change records. The form is a subform just for addresses, and the combobox currently selects address type, ie: home, business, other. Right now, changing the combobox value changes the address...

First off, when I say Continous Form, I'm not sure I've got the correct terminology. What I am speaking of is when you have a form that repeats the detail section for each record, similar to data-sheet view, only instead of looking like a spreadsheet, its a polished form. Got it? I hope so...

Upon opening a form (with some heavy VBA) I get a dialog that says: "You cannot add or change a record because a related record is required in table 'TableName'." The table-data is all fine though, and I *CAN* add or change records in the form. This started happening when I cleaned out...

I've got 3 different labels each with associated OnClick events. I'd like the label to change it's Fore Color when the mouse is hovering over, and then back to the original color when the mouse is not over. If I can have the label underline as well would be nice. I'm running Access XP and I'm...

I've disabled the built-in Nav buttons, and created my own. They work and look great, but I'm having problems disabling the next/prev buttons on the first and last records. The underlying recordset is a table, and nothing too complex. I tried adding some VBA to the OnCurrent event of the form...

I bet this is real simple, but for the life of me, I cannot figure out how to specify the layering of controls on a form. For instance, if I draw a box with the rectangle tool, then move a label onto the box, how can I set it so the label is on top, or the label is below. Thanks in advance, I...

I've got a button on a form that runs the following code block: Dim ty As Integer Dim tp As Integer Dim ny As Integer Dim np As Integer Dim rs As Recordset Set rs = Me.RecordsetClone rs.MoveLast ty = rs("Year") tp = rs("Period") Call...

OK, I've got the following Query hardcoded into my VBA, and it works beautifully, with one exception: if the query returns no results, Access crashes! Is there an if statement I can use to say (in pseudocode) if IsNull QueryResults, do this, else do that.. Anywho, heres the query (doubt it even...