I am having on heck of a time trying to sort a subdatasheet in my table. I have a table that has tiered subdatasheets as follows:
Table 1
Table 2
Table 3
Table 4
For some reason when I open table one and get to the record I need in Table 3, Table 4 is sort...
I have tables that have various date fields with dates in most of the fields. The date fields that are empty are fine, but I want to be able to put something like "N/A" in a date field if a date doesn't apply. Is there a way I can accomplish this? Thanks for any help offered.
Brad
Hi all,
I want to thank anyone who might be able to help me with this and appreciate you taking the time to read my problem.
Ok, I have a table in my DB that is populated from a word form that I have created. In the form I have 7 "Date" fields that are filled by a user and 7 "Hours" fields...
I would like to have my page header show up on every page except the 1st page. I am using Access XP(not by choice...work comp). Any help would be appreciated.
Thank you
I am trying to get data from one table to another. What i have so far is
Private Sub btnTransfer_Click()
Dim db As DAO.database, sSQL As String
Set db = CurrentDb
aSQL = "UPDATE Projects RIGHT JOIN InspectionReports ON Projects.ProjectNumber =...