Recent content by Ralph

You are right! There is probably a lot of things wrong with the structure... [Table1] holds information about people. This includes (amongst many other things) their name, the date they started and the amount of licence fee they pay (per month). The records in [Table2] show changes to licence...

Hi All, Another simple one i'm sure, but as I'm in the slow reader's group maybe someone could help? I have a form [form1] that when populated adds a record to a table [table1]. Nothing amazing there. I have another table [table2] that requires some of the information from [form1] to be added...

Thanks CJ_London. I'm on it! (After lunch obviously!)

Also - I note that if i don't open the form (and the query asks me to manually input a guardian name) everything works just fine? Does this make things worse or better?

Ah! I'm probably guilty on all three counts. Almost all of my tables (25 or so) have lookups in them... as in a person (who is a record in the persons table) is linked to a building (a record in the buildings table).

The query (that i want to alter using a criterion selected in a combo box on a form) gets its information from two separate tables and one other query. Both the tables in question use lookups. If I remove them, wont the whole world fall apart?

Will look at your first pointer first!!

Hi all, Apologies if this is super-simple, but: I have a query that I returns a list of results as expected.. until... I add a criteria to a field as below: =[Forms]![Guardian Termination Form]![Combo0] which makes the query return no results even though the form in question is displaying...

I have sorted it.... I think. It seems that where I was calculating something in a query field - Access would allocate a name to it (Expr1 or similar) which is fine, but if I try to use that name in a calculation in another field in the same query, Access does not accept it. Sound at all...

Erm... I think maybe i've made a hash of the whole thing rather. Very much new to this and have fumbled my way thus far using expression builder and macro builder, without really understanding everything that is going on. I have queries that draw on information from other queries. I know where...

I really cannot find anything that fits the bill. I have 3 expressions that prompt the parameter query box to appear on various queries and reports: An example of one: Expr2: Round([New Licence Fee Amount]/30.42,2) This is a calculated field in a query. Any thoughts?

Thanks! I'll go and check.......

Hi All, Everytime I run a query that I have created it asks me to input Expr1 and Expr2 in an enter perameter value pop up box. I don't enter anything, just click okay and the query runs as expected. Is there a way to get rid of these? (and maybe more importantly, why do they appear?) Any...

Brilliant - Works like a charm! Thanks guys.... (which undoubtedly means I'll be back).

Thank you! I have used this, but it seems I'm missing ),],or Item in query expression.....