Search results

No, No, No! You're getting your knickers in a twist as we say over here!:) On form 1, you have 2 combo boxes (cbo1 & cbo2). You select "Alabama" from cbo1 and "Hominy grits" from cbo2. You then click a command button WHICH CALLS FORM2(from its On_Click event), not a query. Form 1 remains...

Yes, it will work. I don't exactly know what you want to do, but as David R says, you can have as many criteria as you like. Your query can get its criteria predefined from a form field (or fields), a combox (or boxes) or you can call them as parameters at run time. If you call them as...

See what I mean? How are your field names, Pete?:D

Look up the Close method in help

Left([Last name],6)&[MI]& Left([First Name], 1)

It's not necessary to post the same topic in three forums. It leads to confusion. Did the answer I gave in the Queries forum not work?

Did you get my post describing how to use an append query to put zeroes into "absent fields? " Didn't that work?

What you are describing is equivalent to opening a form based on a query, isn't it? Provided that the recordsource of your form contains the name of your query,you can alter it at will by using parameters which are called when you open the form. Is this what you want?

Sam? There are better ways to approach a searchable database that uses keywords http://www.asksam.com/downloads.asp try this link.

It's eminently possible, but pointless! In effect, you are performing a simple calculation to derive the second field. But if you want to return that value you can simply do the calculation at the time it's needed. And your table is half the size. But, if you insist, you need a form based on...

You get your data into a new table each time then? And you want to append the data to a master table? Make sure the field names are exactly the same in both tables. All fields must be present in the master table, but not always in the imported table. Construct an Append query which uses the *...

A filter is really a query or a subquery. But in this context it's not the same as an SQL statement because it's saved and appears in the database window. Say you have a table and you want to frequently look at Customers from Alabama, Baltimore and China. If you don't want to enter parameters...

access xp automatically updates all field references when you change a name.

It's because the form must be open, but hidden, when that line is executed. Shift the OpenForm line above the statement. Use the Hidden windowmode to open it. then use Forms!myForm.visible=true to display it

How do you get the info and add it to your table? Presumably you add rows, some of which contain nulls. Run an update query on your table to update all null values to 0

Yes, that's why you need to replace the existing recordsource (your table) with your complete SQL by putting a statement like Me.Recordsource=strSQL in the code before you open the form. Me may need to be replaced by the full form reference if this is in a standard module

Tess, your humility does you, and your nation, great credit. Yes, that is what our postmen have to endure, plus savage dogs and seductive overtures from bored housewives. They wreak revenge by stealing our credit cards and disembowelling our letters. It's not all cakes and ale here... Glad...

O yes you can! Change field names I mean. Provided you buy a recent copy of Access.... or perhaps you've spent all yer cash on a puncture repair outfit?:D

DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs] wherecondition A string expression that's a valid SQL WHERE clause without the word WHERE. An SQL string must go after the third comma, not the second. Your form is opening with its...

Square brackets go round FIELD NAMES that contain non-alphanumeric characters. (eg. those with spaces) Field Names without spaces can be optionally square-bracketed. The specific syntax for a command can be found in HELP. So for example, for your DOCmd.Open query Help gives: DoCmd.OpenQuery...