Search results

On the subform, create a field on the form footer that calculates the sum of the IU Value, ie, set the control source to "=sum([IU Value]). Name it txtSumIUValue, or something like that. On the main form, create another field and set its control source to '=SubFormName!txtSumIUValue', that'll...

I'm not positive, but I believe the command is 'GetCurrentUserName', as in: LogonName = GetCurrentUserName() Hope that's it! EDIT: Whoops...helps if I spell the command correctly.. [This message has been edited by Jonathan Kok (edited 03-12-2002).]

OK, I've got a form in which I need to compare two fields and ensure that the numbers are the same. One field is a standard, unbound text box with Currency formatting. The second is in a subform, tied to a table, with the Number format in the table, and currency formatting on the field. If I...

Nevermind, answered my own question...just put the chart directly on the form, instead of as a subform, for some reason, it worked! Thanks anyway!

Hey, all, been a while since I last posted, good to see this board's still up! First, a pic of what I want to work: OK, so here's the problem. I've got a table that contains ten fields per record that I need to chart in a line graph as a subform on a form. Since I can't do it using a...

I'm having a similar problem--trying to create calculated fields on a subform. My counts & sums all return #Error (and yes, they're located on the Form Footer). I'm doing a couple of things differently, though. [list=1] I'm using a Countinous Form view for my subform (allowed for easier &...

Try basing your main form on a query instead of directly to the table, and add a field to the query that calculates the 1st two letters of your postcode field. pcleft: Left([postcode], 2) You should then be able to include the new field on your form, and link it to the subform.

Is there any way to send a command directly to the printer? Here's what I'd like to do: I have RightFAX installed on my client PC's, which allows users to fax documents directly from the desktop. This program allows the use of 'embedded codes' in documents to control how a document is faxed...

Good day all, I'm developing a Purchase Order database for my company. I've run into a bit of a problem. The form I'm working on is the actual Purchase Order Entry form--you can imagine what it looks like. The difficulty I'm having is that on the Ordered Items subform, (where the user enters...

I have a similar problem, in fact, the exact same one. What I've had to do is create two reports, one for the fax, one for the printer (I had to do that anyway, because the fax printer didn't fax any drawn lines). I then send a test print of the Fax report to the fax driver from the Reports...

Is there any way to save a report as a snapshot file using VB Code, or do you have to Save As/Export from the Print Preview manually? Ideally, I'd like to export a report to a .snp file without any user intervention required.

Assuming you're entering the information on a form, could you not create code that will change the RowSource property of your serialnumber list box to list only those products with the appropriate ProductID? You would put this under the OnExit property of your ProductID field. The code would...

I think this is what you're looking for... This will open up the "Filter By Form" screen. Put it in the OnLoad event of your form, and it will run when you first open the form. DoCmd.RunCommand acCmdFilterByForm

Thanks, it worked fine!

I'd like to be able to print a document to multiple printers. For example, when I print a purchase order, I'd like one copy to print to the default printer, and another to automatically print to the accounting printer. Alternatively, I'd like to automatically print to the Fax printer when I...

I have a text box (based on a "Memo" Data Type Field), and I want multiple lines of information to be entered into it at the click of a button. But, it can't erase what's already in the text box; I want it to append to the end of the text as a new line in the same field. The current code is as...