Recent content by dcobau

there are probably better ways of doing this but how about: 1) create a small pop up form with a single field and make it invisible, 2) on the OnChange event of the cbobox assign the value selected to the field in the pop up form 3) refer to this field when the value is needed Dave

that's where you need a button with code and proper field formatting

is the sorting field I suggested initially included in the subform?

You said that the subform is based on a query that has 2 tables. The query must have only tblMonths in it and its data must be sorted by field SortOrder (or whatever you called it). Just to make sure we are on the same wave lengh: 1) The main form is based on tblPayments, 2) the subform is...

A query that is based on 2 tables is not updatable. Base the subform on its own query and link it to the main form in the usual way. Dave

1) is the AllowAddition in the form properties set to yes? 2) is the query based on 1 or 2 tables?

It does not matter if a form/subform is bound to a table or to a query but, as long as it is bound, any data entered will be saved to the table. try it. It's normal to have a form bound on a query because often, like in your case, you need to do things with data and display it in the form. Dave

is the form unbound?

1) add a new numerical field to the table (eg. SortOrder) 2) use a modify query to allocate corresponding month values (ie. Jan = 1, Feb = 2, etc) 3) base your form on a query rather than the table and sort by SortOrder Dave

I would: 1) Import/link the spreadsheets and 2) use a make table query to recreate the table but be careful, funny things can happen with data from Excel. Dave

try something like the following: SELECT Avg(IIf([ckField]=-1,CInt(1),CInt(0))) AS CountField FROM tblTableName; Dave

create a group query with something like the following CountBill: iif([FieldName]>0,CInt(1),CInt(0)) when you group the query ensure you replace Group with Sum in the total field. Dave

What I meant to convey to jimdan is that a BE is not opened like the FE and therefore does not need to be closed. Hoping I am not making things worse..... Dave

I have just discovered this link: http://office.microsoft.com/en-us/excel/HA102218401033.aspx Dave

from memory: 1) Create a query that contains the values to be exported, 2) Use the TransferText command to send those values to a text file (you might have to create a temp table for those values). Dave