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!

  • Congratulations Chriss Miller 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: Aspen77
  • Content: Threads
  • Order by date
  1. Aspen77

    Changing default file location when adding attachments

    I created a form that allows a user to add an attachment. This is working fine however, the user is having to browse through many folders to get to a location where all the files are stored. Where can I change the default file location when adding an attachment?
  2. Aspen77

    Unrecognized database format

    My database was originally created in Access 2007 and for the past year we have been using Access 2010. I recently moved the database to a Windows 8 Operating system. The DB opened fine and the users were able to add data, however, after a couple of weeks later is when we received the error...
  3. Aspen77

    automatically have the subform open on the a new record

    I am using Access 2010 and I have a tabbed form. On one tab I have a subform in datasheet view. The user is having to scroll down hundreds of records to add or modify the last entry. Is it possible once the form opens to jump to the last record or a new record so they do not need to scroll down?
  4. Aspen77

    Query

    Hello, I need assistance with a query. I have two tables: Table 1 - Guest Name Name of Guest Table 2- Attendance Date Overnight/Dinner Only I would like to query quests that only attended for Dinner Only for the season and that at no time stayed overnight. So if Jane Smith attended dinner...
  5. Aspen77

    filter last record for each Guest and display in report

    Hello, I need assistance, I am trying to display in a report the last record for each guest based on Date restriction is over. Following is the table structure and a sample of data: Guest Admittance Status Table ID Guest Name Date Restricted Date Restriction is over Admittance Status Restricted...
  6. Aspen77

    Display entry of last record added in a field from a different table

    Hello, I am using the template Students DB provided by Microsoft. On the Form Student details, I would like to display a status field from another table. It seems that the form is bound to a query with one table, but when I add the second table to the query it creates many problems. Is it...
  7. Aspen77

    Hello, I am trying to create a r

    Hello, I am trying to create a report that requires the following data for a one week period: Date of Stay =[Forms]![FormName]![txtStart](Input by user) Week Day=WeekdayName(Weekday([Forms]![FormName]![txtStart])) (Takes the date input by user then converts it to day of week and then I added...

Part and Inventory Search

Back
Top