Search results

Change the customer combo box to include the words WHERE [customer table].rep code = forms![frmYourForm]![rep]; Insert this after the FROM clause. Be sure to change the names to reflect the actual form name and the actual combo box name. Re: requery - You can use the Requery action to...

You know, the easiest thing to do might be for you to zip me a copy of the db so I can see what you're working with rather than trying to visualize it. Would that be okay with you? You can send it to me at accesseb@hotmail.com

Hi - the app I'm developing uses this very feature so I should be able to help you. Your combobox should pull records on the main form relating to the date in the combobox. On the AfterUpdate event of the combobox, refresh the form...the subforms will then only show the data relating to the...

Hi - glad you got it figured out with sgl data type. FYI - if "AVG" is a calculation, it really shouldn't be a field in a table. Generally speaking, you should follow the rules of database normalization, and not store calculated values in tables, unless you are trying to capture a snapshot...

Have you considered a simple combo box that pulls up the selected order number?

Hi - I just did a quick test on a form and I'm not having the rounding up problem that you're having. For the field named AVG, what is your control source?

I'm not sure what you mean by "highlighted on the screen." Can you give more details? [This message has been edited by Elana (edited 05-02-2002).]

I would like to programatically collapse a subdatasheet after my user has selected a particular action on a form. Any ideas on how this can be done?

First, you need to think of how your app will know the "final" total has been reached instead of showing the message as each field on the form is updated. I'm thinking you could place code in the AfterUpdate event of the last field on the form that will receive data. Or, you could have a...

Oops - thought I had this figured out, then realized I haven't yet. Wish I could delete my post, but no luck there. [This message has been edited by Elana (edited 05-01-2002).]

Your select statement for your combobox should say something like: SELECT tblTools.PrimaryKey, "TB-" & [ToolID] AS [ToolNumber] FROM tblTools; It should work just fine.

Hi I'm trying to run some validation code and I want to be able to determine whether a subform is expanded before I let the user close the main form. I've tried in the OnClose event of the main form: "if me.subdatasheetexpanded = true then...", but that's not working. I don't want the user to...

There is an easy way to do this. Create a combobox using the combobox wizard. One of the options the wizard gives you is "Find a record on a form based on the value selected in my combo box." Follow the steps and you're there. [This message has been edited by Elana (edited 04-30-2002).]

Set the "limit to list" property on the combobox to Yes. Then, on the NotInList event for the combobox, you can have code that pops up a msgbox saying "This contract does not exist. Do you want to add?" Then if the user selects Yes, you write code that opens a data entry form to add the...

I have main form and two subforms. The first subform (frmMasterRequest)shows Master Payment Requests, the second subform (frmRequestSub) shows the percentage breakdown by subscriber for the master payment request. Master and subRequests are stored in two different tables (cascading deletes)...

Look at this Knowledge Base article - it should get you pointed in the right direction: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210011 [This message has been edited by Elana (edited 04-10-2002).]

Well, here's what I did and it seems to work: Private Sub frmPolicyUwrsSub_Exit(Cancel As Integer) Dim sglpct As Single Dim rst As Recordset Dim sglanswer As Single Set rst = Forms!frmPolicySubSubform!frmPolicyUwrsSub.Form.RecordsetClone rst.MoveFirst...

Hmmm, does it make a difference that the form I'm displaying records on is a subform of another form? I'm not sure how to refer to its record source or the fields in it using the Dsum function. I can make it total the percentages for every record in the table, but I only need to total the...

Thanks David - you're right about the vbProperCase having limitations with certain names, but placing it on the AfterUpdate event of a control (not the form) is the correct thing to do. I think one runs into trouble with the code if they place it on the Before Update event. [This message has...

Thanks - I figured out the problem. I needed to add rst.movefirst just before the Do Loop starts. EB