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!

Recent content by jchollo

  1. jchollo

    Queries

    ok - tks
  2. jchollo

    Queries

    Hi VRoscioli To answer your question, yes I want to group different values for the org. For ex. Q488 is the head org and they have 8 students and within that org is Q4884 which has 2 students. Instead of producing line by line of each org like I have above, I was looking just to be able to...
  3. jchollo

    Queries

    Tks for the replies - I will try those.
  4. jchollo

    Queries

    Hello, If I have a query which produced the following: Org: Status: Count of Status: Q488 Student 8 Q4883 New Hire 10 Q4884 Student 2 Q4886 New Hire 5 The Org field and Status field are Group By in the total line and used...
  5. jchollo

    Data Access Pages

    ok - tks
  6. jchollo

    Data Access Pages

    I did not say DAP sounded complicated. The process of getting it to update the table is what I am trying to do. I already have the DAP generated and I would upload that page to the server. What I want to figure out is how to get the input data to go into the Access table. And when you...
  7. jchollo

    Data Access Pages

    Doing the splitter and putting the table database on the server, and also putting the DAP on the server - wouldn't they be able to assess the DAP via a web page and the info entered would go the the table database?
  8. jchollo

    Data Access Pages

    We thought about a shared drive but it would be a lot to keep track of permissions since dealing with about 300 people. That's why I was looking to having it on a web page on the INTRAnet where people can just access and submit their entry. When you say splitting the database, you mean parts...
  9. jchollo

    Data Access Pages

    Tks - this seems complicated. If I should use it on the intranet, would it be the same procedures? Do you have to use DAP using IE? Can Netscape be used?
  10. jchollo

    Data Access Pages

    ok - that worked - tks. I was able to input. Is there a way to have the DAP open in add mode? I do not want to have all the other records available. Only want to have a blank form displayed for input entry only which the data will go into the database. For this to work on the web, would I...
  11. jchollo

    Data Access Pages

    Sorry, but what is the DAP. How do I go about doing that? tks
  12. jchollo

    Data Access Pages

    I generated a data access page but when viewed in the browser, I cannot type in or edit any of the fields. Is there something else I need to do to the page? What I want to do is have a page on the Internet which I generated the page from a table to have people to be able to input data on the...
  13. jchollo

    Query Question

    ok - I see. I guess I was thinking when an item is closed, I wanted it not to appear in the table. But creating a query for the active items would do the trick. tks for enlighten me.
  14. jchollo

    Query Question

    I have a table with a field called Status of Action which has the choices to choose Active, Completed, Closed. Once an item is closed, how do I go about placing this entry in a closed table. Do I have to set up another table named Closed. How would I write the code to put an entry once...
  15. jchollo

    Still Trying to Query Overdue Dates

    When I do the query, it displays the Overdue column along with the days overdue. But when I want to review in the report format, it just displays the Overdue column without displaying the days overdue.
See more

Part and Inventory Search

Back
Top