Search results

  1. D

    No idea what to call this

    Hey, I have a query with the following code which runs great SELECT tblstj.hhmm, Sum([tblstj]![acd_calls]+[tblstj]![abn_calls]) AS Total FROM tblstj GROUP BY tblstj.hhmm, tblstj.fdate, "All" HAVING (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate])); I want to include this code is the last...
  2. D

    Access Charts/Graphs

    Hi Everyone, Just wondering if anyone knows were I can get some information(Examples) on charts/graphs. I have been searching around the net with no luck. I have tried to create many charts using the wizard but I do not get the required output. I find creating charts in excel straight forward...
  3. D

    Using the Find Unmatch Query

    Hey, I am having some trouble using the a unmatched query. Bascially I have 3 tables(Master, Table1 and Table2). In the three tables I have a unqiue field(Not the Primary) named ID#. I want to run a query on Master table and return the ID# if it is not listed in either Table1 or Table2. Any...
  4. D

    Importing ANSI Format?

    Hey, Anyone know if it is possible to import an .ansi file?. If yes do you know were I can find some information regarding it? Thanks Chris
  5. D

    Macro Question - Set Warnings

    Hi, I have a macro setup that exports excel files to a network path. Each day when I run the macro its asks me to over-write the previous days file, I was wondering is there a way to prevent this prompt from appearing. Thanks Chris
  6. D

    Read-Only Text Box

    Hey, I have a txtstart box on my form and the Locked Property is set to "Yes" becase I don't want any users typing. But I also have a "Clear" button on my form, but when I click, I get an error because Locked textboxes can't have focus. Any Ideas a work around for this? Thank you in advance
  7. D

    Form based on a Query

    Hi, I have form created(frmsearch) based on a query(qrysearch) which searches based on partial last name. For example when you run the query it asks the user for Partial Last Name, so when you type "smi" it returns two values on the form smith, john & smith, kathy. And on this form next to...
  8. D

    4 Query's in one report

    4 Query's in one report I have a Report graph that is based on 4 querys. These 4 querys prompt the user for the same 3 questions Name, Start Date & End Date. The criteria for the Name field is Like "*" & [Enter Partial Name] & "*" and the criteria for the start/end date is >=[Start Date:]...
Top Bottom