Search results for query: *

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

So you did not have to scroll down when there were 100's of records?

Sorry, did not see the previous question. It is in the VBA code.

Yes, I can add new records with the code. The code works great when I open the form directly but when it is called from the main form is when I have the problem of not being able to modify the data using the macro on current event in the subform. The datasheet now without any code works...

Tried placing the code in the open event of the main form. It did not work. My datasheet subform has a master/child relationship. The only thing that seems to work partially is placing the gotorecord macro in the current event on the subform. It will let me add a new record but not modify any...

I apologize the code you provided worked, however, if the datasheet had a few records then it opened on a new record. If the form had over 20 records then I had to scroll down to get to the new record. Whereas, the gotorecord took me directly to the new record regardless of how many records...

Tried the code you provided in the open event , however, it did not jump to the bottom of the datasheet, I still needed to scroll down. I tried a gotorecord macro in the current event, it partially worked. When the subform opened it opened on the new record without scrolling down however, it...

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?

It's working, thank you so much! You're awesome! Thank you! Thank you! Thank you!

Hello, Thank you for the new code, however, it is still including the guests that have both check-ins (overnight and dinner only). Any assistance would be greatly appreciated. Thank you!

SELECT Guests.ID, Guests.[Last Name], Guests.[First Name], [Guest Attendance].[Overnight/Dinner Only] FROM Guests INNER JOIN [Guest Attendance] ON Guests.ID = [Guest Attendance].ID GROUP BY Guests.ID, Guests.[Last Name], Guests.[First Name], [Guest Attendance].[Overnight/Dinner Only] HAVING...

The SQL code you provided returned all guests that ate dinner to include those guests that also stayed overnight throughout the season, however, I need the results to only include guests that ate dinner only and did not stay overnight throughout the season. Every night when a guest checks in...

Hello, Thank you so much for the query, it is partially working. However, the query is returning all guests that ate dinner including the guests that on some evenings stayed overnight. So in the example below I would not want Jane Smith to show because although she ate dinner on 1/1/13 she...

Please disregard the previous message,I found the problem. However, when I run the query no data shows up.

Hello, I am receiving the following error message: You tried to execute a query that does not include the specified expression 'And [Guest Attendance].[Overnight/Dinner Only]="Dinner Only" as part of an aggregate function. Please assist. Thank you!

Table Guests ID Last Name First Name Table Guest Attendance ID Date Overnight/Dinner Only Table Guest 1 Smith Jane 2 Doe John Table Guest Attendance 1 1/1/13 overnight 1 1/2/13 dinner only 2 1/1/13 dinner only 2 1/1/13 dinner only The only result I would like to see in the query is Guest...

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, Using the Guest Admittance Status Table described above, is there a way that once the "Date Restriction is over" is less than the current date a new record is added to the Table for that guest with the Admittance Status of clear and the Date Restriction is over to a future date such as...

The following code worked: =DLookUp("[Admittance Status]","Guest Admittance Status","[Guest]=" & Nz([Forms]![Student Details]![ID],0) & " AND [Date Restricted]=#" & Nz(DMax("[Date Restricted]","[Guest Admittance Status]","[Guest]=" & Nz([Forms]![Student Details]![ID],0)),#1901-01-01#) & "#")...