Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. abradford

    Combo box in form to display unmatched query

    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...
  2. abradford

    Combo box in form to display unmatched query

    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...
  3. abradford

    Combo box in form to display unmatched query

    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?
  4. abradford

    Combo box in form to display unmatched query

    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...
  5. abradford

    Combo box in form to display unmatched query

    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...
  6. abradford

    Sort by Count of sub group

    yep totals query worked good, thanks!
  7. abradford

    Sort by Count of sub group

    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...
  8. abradford

    Count By Group

    gotcha. thanks!
  9. abradford

    Count By Group

    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...
  10. abradford

    Dlookup by Header

    got it. thanks!
  11. abradford

    Dlookup by Header

    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.
  12. abradford

    Dlookup by Header

    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...
  13. abradford

    Excel Spreadsheet file size limit?

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

    Excel Spreadsheet file size limit?

    is there another way to import besides the Wizard?
  15. abradford

    Excel Spreadsheet file size limit?

    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...
  16. abradford

    Parameter with number and letter...

    sorry I have figured it out thanks to you both
  17. abradford

    Parameter with number and letter...

    thanks, however, off couse, i am failing to get this to work, do to me being newish and not knowing where to put parens...here is my code: SELECT [Active Directory].LastFirst, [Active Directory].Email, [Active Directory].AgentNumber, [Active Directory].AGT, [Active Directory].BSO FROM [Active...
  18. abradford

    Parameter with number and letter...

    I have a parameter query which asks to enter in an Office number The problem is that there are office numbers which include letters, like 4044b. So when the query asks me to enter in office number I want to enter in 4044 and have all records displayed that have office of 4044 as well as...
  19. abradford

    DLookUp headache

    Spot on Duane, thanks again for the help. So it was just missing the extra parens and a &...was this strictly because it was a text field, not number?
  20. abradford

    DLookUp headache

    I have this DLookUp in the control source of an unbound text box on a report. =DLookUp("AgentNum","AgentLookup","BSONum = " & [BSO]) lookup table: name: AgentLookup 1st column - BSONum 2nd column - AgentNum my report is opened by a parameter asking what BSO, which is a number (could be...

Part and Inventory Search

Back
Top