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?
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...
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?
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...
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...
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...
Hello,
I am trying to create a report that requires the following data for a one week period:
Date of Stay =[Forms]![FormName]
Week Day=WeekdayName(Weekday([Forms]![FormName]![txtStart])) (Takes the date input by user then converts it to day of week and then I added...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.