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: *

  • Users: ewd97
  • Order by date
  1. ewd97

    Search based on input boxes

    I have an access database that is being used through data access pages. I have a search critera DAP that has input boxes for "Date" and "Employee". I am trying to find a way to query a table in the database and have the record that matches these two search criteria, populate a different DAP...
  2. ewd97

    Search Based on Input Boxes

    I have an access database that is being used through data access pages. I have a search critera DAP that has input boxes for "Date" and "Employee". I am trying to find a way to query a table in the database and have the record that matches these two search criteria, populate a different DAP...
  3. ewd97

    Search based on Input boxes

    I have an access database that is being used through data access pages. I have a search critera DAP that has input boxes for "Date" and "Employee". I am trying to find a way to query a table in the database and have the record that matches these two search criteria, populate a different DAP...
  4. ewd97

    input mask data access page

    I have seen this question asked before with no responses. So far I have been able to find very little information about applying an input mask to a data access page. Can anyone explain this procedure to a vbscript beginner? Thank you!
  5. ewd97

    input mask on data access page

    I have seen this question asked before with no responses. So far I have been able to find very little information about applying an input mask to a data access page. Can anyone explain this procedure to a beginner? Thank you!
  6. ewd97

    Using NewRecord Method

    I figured it out. I was putting the entry in the wrong area. I used the "ondatasetcomplete" area and it worked fine.
  7. ewd97

    Using NewRecord Method?

    I figured it out. I was putting the entry in the wrong area. I used the "ondatasetcomplete" area and it worked fine.
  8. ewd97

    Using NewRecord Method?

    I am new to vbscript. I have a Data Access Page that I created in MS Access. What I am trying to accomplish is when the page opens in IE, it will begin ready to add a new record. Currently, it begins with a list of existing data and you can then click the navigation button to create a new...
  9. ewd97

    Using NewRecord Method

    I am new to vbscript. I have a Data Access Page that I created in MS Access. What I am trying to accomplish is when the page opens in IE, it will begin ready to add a new record. Currently, it begins with a list of existing data and you can then click the navigation button to create a new...
  10. ewd97

    Date Variable Union Query

    I have a union query where I am combining several queries into one. They all are searching by the same date. I have the statement "WHERE benefit_Query.Date=[Enter Date]" and every other query in the union query is set to be equal to "Benefit_Query.Date", but when the query...
  11. ewd97

    Auto Fill Form Field

    That worked better than I could have expected. Thank you for the help mgolla!!
  12. ewd97

    Auto Fill Form Field

    That sound easy enough, but what type of statement structure is the dlookup and how would I enter it. I know where the event afterupdate would be, but is it a macro, expression, or code?
  13. ewd97

    Auto Fill Form Field

    I have an employee table that lists, among other things, Full_Name and Department. I have a form that is being used to populate another table(Daily_Sheet), that will allow you to type in a full_name and it will pull from the employee table to prevent mis-spellings. That is done and that was...
  14. ewd97

    Combining Queries and eliminating duplicates

    JonFer, you are correct that the tblSchedule just tells what the current schedule is. It does not track time actually worked. I am handling that through a different table since the schedule and time worked never seem to match. I still have not had time to try the suggestion, but plan on...
  15. ewd97

    Combining Queries and eliminating duplicates

    JonFer, I understand what you are saying, and that was the original direction that I was heading with this database. The problem is, with 365 days per year and 71 employees, the schedule table then has 25,000 entries. This would work fine, except, if the schedule for any person changes...
  16. ewd97

    Combining Queries and eliminating duplicates

    I am trying to create a query where the resultant is a combination of information from a table and a query and eliminate duplicates. I have created a database where I run a query to display a schedule based on the information in three different tables. To display this information it will...

Part and Inventory Search

Back
Top