Search results

Is there a way to define a form I've already developed as a Template, so that when I create my Autoform (to draw data from query) I can use that template? I'm wanting the form to be based upon the query- yes, but I want the form I've already developed to be doing it- I don't want to develop a...

Well, the issue is that my boss wants the "add client" form to be (or at least look) the same as the query-driven form... It would allow ease of browsing and editing for particular Project Managers over their records. The form you suggested, the one I've created and which is driven now by...

Well I was hoping to use an already constructed form, but this will work I guess. Thanks a lot ;)

I would like to run my query, but have it open into form view- any suggestions? *I don't want filter by form, or query-by-form, I want the info that would come up for the query, "MsterQry1", to be shown in the form. Thx~

Ok, the only problem is that when I = [Forms]![Sort]![Contact] Or Trim([Forms]![Sort]![Contact] & "") = "" for 8 parameters, the "query is too complex" error pops up. And that doesn't include the four sector fields that will draw from the single form field (still haven't figured that out, even...

I still have one issue remaining before I can complete this DB: 4 table fields, supported by 4 query fields, with four criteria parameters drawn from a single selection on the form. How do I tie those four fields into one parameter function without having them crash?

The other criteria besides these two are totally empty. Contact is one combobox, State is another one- from the form. I found this: = [Forms]![Sort]![Contact] Or Trim([Forms]![Sort]![Contact] & "") = "" which seems to work on the first try...

Ok, here's what I put in my contact and state sections of table: Like IIf(IsNull([Forms]![Sort].[Contact]),"*",[Forms]![Sort].[Contact]) Like IIf(IsNull([Forms]![Sort].[State]),"*",[Forms]![Sort].[State]) The query produces a table when entries are chosen for both contact and state, but if...

http://www.mvps.org/access/queries/qry0001.htm Even that says the same, but when I put in [Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null but this does not seem to work at all.. I get the right response if I put in a value in the dropdowns or nothing if there is none or...

Ok, but that returns only when I have a value in the form area associated with that parameter. What I really want is if there is a value on the form for a particular parameter for it to be used, but if there is not one that it skips that parameter using "*". Something like ...

New Question :( Ok, what I got going in my query design. In my criteria for one of the fields in the query there is: Criteria: [Forms]![Sort]![Contact] Or: [Forms]![Sort]![Contact] Is Null This brings back information only if I put in a value on the form, when I don't put in a value the...

Ok, thanks a lot!

Hey Wayne, that looks good. A small issue: I put in "Where (Field2 = Forms![Sort]![Contact] Or Forms![Sort]![Contact]! Is Null) as criteria in my second query field and I'm being toldthat a parenthesis or dot(.) is invalid.. Tried a few things otherwise and did not have any luck. Any advice...

I'm running a 9 parameter query, where values for the criteria are drawn from a form. I'm confused as to how I build an "if, then" string so that if one of the parameters is left blank, the program will skip it and go to the next. Any suggestions?

Multiple Query Issues Ok, I have a DB of client contacts. I'm drawing the values for a query from a form using [Forms]![Sort]![Contact] in criteria and using the parameter field to give values to each. The query works fine for state, contact and industry- all in conjunction with each other...

Ok, thanks a lot for the help.

Thanks Garabito, I'm trying to use custom functions now to reference fields from the form in my master query (which includes all the 9 fields). I believe the database is not normalized, that is I have done no setup to reduce redundancy.

I just started using Access a couple weeks ago. I bought a couple books, have read some help stuff in forums webwide, but I am still stuck on the basics of how to do the following~ Please Help ~ My DB: I have a single main table, in addition there are several mini-tables used to support combo...