Search results

What you need to do is create a field that sets negative values to zero, then sum that field. Create an unbound control. I'll call it [PosPoints] and set its visible property to 'No'. Set it's source to: =IIF([YourPointsField]<0,0,[YourPointsField]) Now, instead of having the summation field...

Perhaps you could place it in the first list box's 'OnChange' event or the second list box's 'GotFocus' event. You may also want to take a look at the post titled, 'Cascading text boxes' under the General topic for more information. ~Abby

Hello Dale. Here's what you do. Create a form based on your query. Place your, Price, Discount and Balance fields on the form. Add an unbound control on the form instead of the 'Object Name' field. For the purposes of these instructions I'll call it 'SearchName'. Now code the SearchName field's...

Hello. The reason you're only seeing the last name after the item is selected is the combo and the last name are each 1 field. You can view multiple fields in your list but only one can be placed into the control. What you need to do is combine the first, middle, and last names into a single...

Sorry, I should have specified in my original reply. You'll need to code the unbound control's 'After Update' event to: Me.Requery This will cause the form to rerun it's underlying query and give you the current recordset. ~Abby

Don't take this personally. I'm just trying to help. Rather than deleting your original post and putting up the one above you would probably have been better off replying to, or editing, your original post with this new information. The reason being, anyone reading this topic now has a more...

If you want the report to always ask for input when opented you can use a filter. In the reports property set the 'Filter On' option to Yes. For the 'Filter' enter: NameOfDateField >= [Report from when?] ~Abby

I was working on a very similar problem just yesterday. Here's the solution I came up with. Perhaps you can adapt this to your own situation. I coded the unbound control's 'After Update' event with the following. Hope this helps. Dim strResponce As String Me.RecordsetClone.FindFirst...

I don't know of any way to delete a group with VB. (Not to say you can't. Just, I don't know.) However, so long as you always have the same number of groups, you can change which fields it groups by. You can do this with the GroupLevel() method. For example, if your report has 2 groups, you can...

I'm not sure I understand how your form is set up. Here are my assumptions. You have a main form with a subform. The subform is based on a query with its criteria set by a combobox on the main form. The Control Source property for the combo box is a control in one of your tables. i.e. It is a...

That did it. Thank you Travis. Though I still don't understand why the dialog came up with the Update query and not the Append query.

My best advice is to go ahead and make the 8 different reports. But, if you're dead set on doing it with code, take a look at the CreateGroupLevel Function in the help file. ~Abby

I'm trying to create a script that appends or updates a table when a report is opened. I've written a script and tied it into the report's 'On Open' event. It works fine except for one thing. When the script goes to update the table I get a popup message that says, "You won't be able to undo the...

The VB method to save a file in RTF or TXT is fairly simple: DoCmd.OutputTo acOutputReport, "Report Name", acFormatRTF (or acFormatTXT), strMyReportName, False You'll need to come up with a naming scheme to set 'strMyReportName' with. See the help file for OutputTo for more information. The...

If you want a rectangle around the entire record_type footer and report footer, you are correct, it is simple. Just code the On Print event for each section you'd like a rectangle around with the following code. Me.Line(0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B If you want the rectangle...

Two questions. First, in what format does the client want the file saved? Second what method are they using to open the report and/or print it? Is it a command button from a form or are they opening the report from the database window? ~Abby

This can get a little complicated, depending on exactly what you're trying to do. However, if you base the second and subsequent list boxes on queries with criteria based on the first field, that usually does the trick. If you go this route you should also code the first fields 'After Update'...

The extra width you're looking for is probably the margins. If your report's width is 8" you'll need to lower the left and right margins to 0.25" each. Margins can be adjusted in the Page Setup. Your logical width value is fine. Hope this helps. ~Abby

I believe that query is the problem. Create a main form based on the design table and a subform based on the process table. Be sure to set the subform's data properties, link child and link master to your part number fields. If you create the subform with a wizard it should take care of that for...

I haven't used this my self. But, this may be what you need. http://www.mvps.org/access/modules/mdl0018.htm