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 derfloh 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. Remdul

    Attempting to ease users repetative use of database.

    Ah, I see! Thank you very much, PHV! I just have to redesign my switchboard now to that I can have this one form open all the time. Not quite sure how I will do that yet, though. This form is definately very helpful for folks like me who are attempting to learn access. :) Once I figure out why...
  2. Remdul

    Attempting to ease users repetative use of database.

    Sorry about my vagueness there. WHat I did was I created a form called Date, then put within it two text boxes called Date1 and Date2. WHERE ((([ACO Report].[Date of Pickup]) Between [Forms]![Date]![Date1] And [Forms]![Date]![Date2])); When I ran the query, I recieved input boxes much like my...
  3. Remdul

    Attempting to ease users repetative use of database.

    PHV, I was unable to get this way to work, unfortunately. I kept getting prompted with search boxes as I ran the query. Aceman1, I am afraid I do not know a whole lot about the Visual Basic side of Access. How would I be able to set/change the variables as the need called for it? I put it in as...
  4. Remdul

    Attempting to ease users repetative use of database.

    I have a database that counts a number of events between a certain set of dates. The code looks something like.. SELECT Sum([ACO Report].[Board Fee $]) AS [Boarding Fee $] FROM [ACO Report] WHERE (([ACO Report].[Date of Pickup]) Between [First Date:] And [Second Date:]); There are 20+ queries...
  5. Remdul

    Access Database disappearing...? Confused as to what may be wrong.

    Hrm, this is going to be a hard problem for me to explain. I havce a MSA Database I have been working on for 60+ hours. During the final touches of the database, something happened that has me very confused.When I open my database, it opens MS Access, but my switchboard is missing. On my...
  6. Remdul

    Reports, Queries, and Dates.

    It looks that that gave me the same problem as before.. Perhaps I need to change something in the rest of my code to get it to work? Thanks again! You've been very helpful so far Randy! Bryan
  7. Remdul

    Reports, Queries, and Dates.

    I appreciate you trying very much! I will continue to research this also. It's a very confusing matter, for attempting to get some simple data, hehe. Thank you again, Bryan
  8. Remdul

    Reports, Queries, and Dates.

    Is there any way to have the report run the query? Bryan
  9. Remdul

    Reports, Queries, and Dates.

    Here's some of the data, very small portion on it. If you need more, please let me know. Type Date of Pickup Pup 1/1/2006 Dog 1/1/2006 Cat 1/2/2006 Dog 1/2/2006 Dog 1/2/2006 Dog 1/3/2006 Pup 1/3/2006 Dog 1/3/2006 Pup 1/3/2006 Pup 1/3/2006 Pup 1/3/2006 Pup 1/3/2006 Cat 1/30/2006 Dog 1/31/2006...
  10. Remdul

    Reports, Queries, and Dates.

    SELECT Type, Count(Type) AS [Pets Processed], Format(Month([DateProcessed]),"mmmm") AS [Month Processed] FROM [ACO Report] WHERE DateProcessed Between #1/1/2006# And #12/1/2009# GROUP BY Type, Format(Month([DateProcessed]),"mmmm") Sorry about that! And thanks very much for your help! Bryan...
  11. Remdul

    Reports, Queries, and Dates.

    When running this code, Randy, It gives me The type, how many total, and the wrong month? Cat, 48, December (for 1/1/2006) Bryan
  12. Remdul

    Reports, Queries, and Dates.

    Yes, all the queries are created from the Main Table, ACO Report. It gave me an error when I tried to combine them into on report using the wizard saying that didnt work, so I used subreports. Bryan
  13. Remdul

    Reports, Queries, and Dates.

    Thank you very much Randy! I am not entirely sure I set it up right though. SELECT Type, Count(Type) AS [Pets Processed], Format(Month([DateProcessed]),"mmmm") AS [Month Processed] FROM [ACO Report] WHERE DateProcessed Between 1/1/2006 And 9/9/2009 GROUP BY Type...
  14. Remdul

    Reports, Queries, and Dates.

    Howdy, I am attempting to design a database for a local animal shelter to count how many dogs come through in a year, and I am fairly new to the access field. I have 5 queries, each specific to the type of animal... I have Dog, Cat, Kit, Pup, and Other. The SQL code for my 5 queries look like...
  15. Remdul

    Seaching on the Web Interface

    Is there a way to search the Access Pages? For example, you can use the Find button on forms (Command Button) to search the database for a record. But I hate not found a way to do so on the web pages. Thank you, Bryan Elliott
  16. Remdul

    Attempting the Impossible? Totaling names.

    So on the report, I would have it Dlookup the query? I'll try that. Not entirely sure what you mean by using the subreports to present the data though. I am attempting to bring 5 queries into one report, and it's presenting me with an error saying that it cannot connect. Thank you, Bryan Elliott
  17. Remdul

    Attempting the Impossible? Totaling names.

    Actually, that was merely an example. What I am currently doing is building a Database for the Animal Control Division of my local Police Department. I have an extensive plethra of fields, including name, address, ID Tag, Rabies Tag, Type, Breed, Description, Citations, etc... It's a fairly...
  18. Remdul

    Attempting the Impossible? Totaling names.

    Thank you for your quick replies! I will try these immediately. I appreciate it very much! Bryan Elliott
  19. Remdul

    Attempting the Impossible? Totaling names.

    Is it possible to total how many times someone is mentioned in an access datasheet? For example, A datasheet containing the list of all the techs that have helped users, and specific users they have helped. Joe helped Jane Frank helped Billy Joe helped Bob Joe helped Craig Frank helped Alex...

Part and Inventory Search

Back
Top