Recent content by abradford

Ok got that part, combo box is in the form header, displaying names from USER table. The recordsource of the form should be somthing noted above, referencing what is selected in the drop down...Now how would I incorporate displaying the unmatched queries in the form detail...

yes I have main user name table, which is linked to each users individual table by a one to many relationship. User Name to Name...

ok so hint to get me started... Form!Formname!Combobox!Controlname.text.....close? After record source on form, what should be contained in the combo box's after update?

I have been trying to stay away from SQL as I am a bit rusty. But now have been looking at tackling this another way, perhaps playing with a union or inner join query? Should i go down this route? I am not sure i am following your suggestion. Can I set the RecordSource property of the form...

Hello, Ok i know the structure of my DB is a bit "loose" but here is the deal: I have several different user tables, all same structure, some have more/less info than others...I have created an unmatched query for each table, which compares the user table to a standard information table...

yep totals query worked good, thanks!

Hello I have a report which displays records by instance group. I have a box =count[response] in the header of each instance group. How can I sort the report to display by that =count[response] box? I have tried the grouping and sorting: [Response] descending =count[response] descending...

gotcha. thanks!

I have a query which displays user records from different offices. I would like a total number to be displayed in a column, so it counts number of active users per office, Based on office number. It should look like this: Office Name Count a steve 2 a bob 2 b Gary 1...

got it. thanks!

It is numeric, and I tried =DLookUp("total","Lookup","BSONum = """ & [BSO] & """"), however nothing is appearing on the report. No error message either. The box is visable... this in not a parameter query/report just to mention.

Can you have different Dlookup values on a report by header? I have a report which dispalys certian people from multiple offices, grouped by office. I have a office header and am trying to use Dlookup to dispaly total number of people from that office, stored in a lookup table. Is this...

hmm, ok not to great with code, where can i find instructions on how to do this?

is there another way to import besides the Wizard?

Is there a size limit to an excel spreadsheet import into access? I have a spreadsheet that is constantly growing, it had 667, rows(1326 kb)yesterday and imported into a new table fine. Now it has 753 rows (1,441 kb)and won't import..."an error occurred while importing..." I deleted some rows...