Search results

  1. K

    Modifying a query to return all info if select criteria is left blank

    Sorry David, I need a little more help than that. I understand that by converting the blank field to a "*" (wildcard) that should return all employees. Where I'm not following too well is where to do this. From what you wrote, I'm inferring that I go to the Properties of the form that's used...
  2. K

    AC97: Switchboard help

    Perfect! My hero! :)
  3. K

    Counts not counting the field that I'm asking it to

    Not really, unless I'm misunderstanding something.... (but I do appreciate the suggestion! :) ) What you've cited will sum the detail records. My report will have a several headers w/ multiple details. I want to count the headers. I will try this but at the header level and see if it...
  4. K

    Modifying a query to return all info if select criteria is left blank

    I have a form that is called by a switchboard. In this from, "callreport1", you enter criteria which in turn, a query uses to build a form. The criteria is: to date from date employee name As it works now if you enter your date range (to/from date) and an employee name it generates a report...
  5. K

    Counts not counting the field that I'm asking it to

    In this report, I have it subsort by "BA". In the "BA Footer" (not the page footer), I've put in a count: =Count([DtReceived]) "DtReceived" is a field in the Header. So, basically, for each "BA", I'm trying to count header records. What it is doing, though is counting the detail records...
  6. K

    Text field limits

    Yeah, but in 97 at least, you can't search the memo field, at least not w/ the basic search functions. That's why I never use it. I was hoping that by XP they'd overcome this somehow. But its not that big of a deal to me, but woulda made some things nicer. Thanks for the quick replies.
  7. K

    Text field limits

    We use access 97 and the text field is limited to 255 chars. I'm just curious what the limit is in 2000 and if anyone knows what it is in XP? We'll be jumping to XP later in the year.
  8. K

    AC97: Switchboard help

    Doh! Spoke too soon! Well sort of. The basics work. I can get the filter predicated on the employee that is selected. The problem is when I leave the employee blank, it returns nothing. You did predict this when you said: <Once you have the code created by the Wizard then add this code...
  9. K

    AC97: Switchboard help

    Jack, I figured it out! The wizard was working just fine! I just found some extraneous garbage hanging about that I had to clean up. Thanks again! Case CLOSED! :)
  10. K

    AC97: Switchboard help

    ok, I tried this: DoCmd.OpenForm "[ISIF Form]", , ,"[BA] = '" & Me.BA & "'" ISIF Form=That the forms I want BA=employeefield BA=also is the name of the combo box. I now get this error: "Microsoft Access can't find the macro 'DoCmd.' I did cut/paste the original code from that field that...
  11. K

    AC97: Switchboard help

    Yeah, I can see how this wizard wants to help me do what I'm suggesting. :) But, I got this error: "The object doesn't contain the Automation object 'ISIF'." ISIF is the table that the form I'm calling is tied to. The combo box gets the employees names from a table, BA. The table BA is...
  12. K

    AC97: Switchboard help

    I did use the wizard and as it currently works, that is what happens. But, I've added the "complication" of trying to limit the data that's returned to what I happen to put in the combo box (employee name) that I added to the form. You do mean the command button wizard? I'll retry. Also, one...
  13. K

    Error Messages on my form!

    Just a stab in the dark, but did you rename any of your tables? I've have bound combo boxes then renamed the source table and guess what.... they didn't work. I think the error you site is the one I got. To fix (and sorry if I get some of the terms wrong, I'm still pretty new to Access), go...
  14. K

    AC97: Switchboard help

    OK, I have a switchboard. On the switchboard I added a combo box that allows you to pick an employee name. I'd like it to work so that when you select a name, say "Jones", then click a form, it filters so that you only see the data for employee "Jones". I hope that makes sense? I'd like to...
  15. K

    AC97: Would like to make 1 control dependent on another.

    OK, I've got some stuff to work w/ from some of the old posts. I'll let you know if I can get this to work.
  16. K

    AC97: Would like to make 1 control dependent on another.

    I'm making my first DB in Access 97 and have this stumbling block (among many!): I have to combo boxes. They read records from table 'project' and the form writes to table 'ISIF'. When the user selects one of the choices of the 1st combo box, I would like the 2nd combo box (I guess this could...
Back
Top Bottom