Search results

Ok...one more compile error, now at the ".setfocus" part saying "expected function or variable"....? [This message has been edited by lscheer (edited 08-26-2001).]

Thanks...Now, though, it just says Syntax Error for the "If (x>0)" part........

Thanks, now the Compile error says "IIf (x>0)" Argument Not Optional. Here is what I have in my module. I'm not too VB literate, so any help is great. Thanks! Private Sub DUMMY_AfterUpdate() Dim x As Integer x = DCount("*", [Participants Table Query], "[PART ID]=" & Me.DUMMY) IIf (x > 0)...

In a post from a couple weeks ago, Marion posted this code/message: Hi there If you still need help - I usually use apply filter to do what you need. You need to put an unbound control at the top of your form for a "...

I want to create my own search/find form to use when the user selects my Add New Record button. This way, before they can add a new record, they must search to see if the person they want to enter is in there already. I'd like to have the first and last name fields on the form so they can...

I have a form (Form2) that I am updating some data on based on info from another form (Form1). I have set up a macro that updates all the necessary information (ID, contact info, etc.) into Form2 by opening Form2 and using SetValue to set the ID number to match the ID from Form1. This all...

You could also put a command button on your form with a macro attached to it (onClick) that has two steps: 1) RunCommand (SelectRecord) 2) PrintOut -Print Range: Selection -All other arguments are up to your specifications. Hope this helps!

...or something like that. I am dealing with this compound problem and banging my head against the wall...any help would be greatly appreciated. First of all...I have a form (CONTACTS) with ContactID and all other pertinent contact info (address, phone, etc.). I have another form...

1. Check 2. Check ...still no luck!

If your form has fields in it, it has to have a RecordSource. In the design view, click on the properties button (finger pointing at a page). Make sure the upper left hand corner of the form is clicked (has a little black dot/square in it) so that you are looking at the FORM properties. The...

What is your form's RecordSource? (you can find this out in the properties sheet for the form). If it's a query, you might be limited by the query's recordset type (set it to dynaset to update records). If it's a table, make sure your AllowEdits property (on the form) is set to yes, and under...

Thanks, but I have tried to add Requery, Refresh and Repaint as the final action in my Macro above, and none work. If I hit Shift+F9 (to refresh the form), that does it (after refreshing the form, it goes back to the first record, and ideally, I'd like it to go back to the last), but don't want...

You should be able to skip the VBA work by using the button wizard. You can choose a command from the wizard to open query. Otherwise, you can use a macro, assigned to OnClick for the button, that will open the query.

I have a form "Contacts" that is my master form, into which all major data entry occurs. Then I'd like to query the "Contacts" table and another table of supplemental data "Job History" to display on another form "Participants." To avoid re-entering all the contact info previously keyed in, I...

Thank you very much, but neither of these suggestions worked...

I have a simple calculation I'd like to perform in my form, but it doesnt seem to work. I want to calculate a percentage, using values from two fields, [Pre Test Raw Score] and [Test Score Total] to be displayed in a separate [Percentage] field. I used =(([Academic Credit]![Pre Test Raw...

I have a Labels report in which I want to display two fields (two different contact names), however, I only want the second field to be displayed if there is no data in the first field, and then suppress whichever field is not displayed. Is this possible???

I'm trying to run a calculation on a field in a subform that uses data from the subform and the main form. In the subform, the calculation works (so I have the syntax correct), but when I try to run the Macro from the AfterUpdate or OnChange events from the field I use on the main form, the...

Thanks pdx_man, But I've tried that. I had originally set the combo box to display 2 columns, with 1" and 3" widths, respectively, with the bound column property set to 2, and it still fills in the box with the value from the first column.

I am trying to have a combo box in my form that, when the arrow is clicked, displays two columns from a query, but fills in the data only from the second column. I can make it work if I hide the first column (column width =0 and bound column is #2), but I need to have both columns displayed...