Search results for query: *

I'm not sure what you want users to have only read privileges for once they exit forms. But if you build an Access form to a linked SQL Server table, it prompts you for either a trusted NT login or a SQL Server login. Perhaps you would create a group role in SQL Server that has read/write...

Before I can help you can you please let me know what field names you are using in both tables. Also be more specific as to what sort of data you need as output.

I'm thinking that a simple DoCmd.RunSQL("SQLstatement") might be of help.

I'm not sure in what sort of date format your class date field is in, but I would try this SQL statement to derive the information you need: SELECT Count([Schedule.VolunteerID])*2 AS CountClassHours FROM Schedule WHERE ((([Schedule.ClassDate])Between #Date1# And #Date2#) And...

I'm not sure where you got that information but you can most definitely sort your records within a table and then save it. The next time you open the table your records will still be in the same sort order as you specified. Just bring up the table in table view and click the field you want to...

I have developed a loan tracking database in Access 97. I do a report that tracks the number of days it takes for the file room to receive a file from a loan center. I have two date controls on a form, InterestStartDate and ReceiveDate. I subtract ReceiveDate from InterestStartDate to get the...

I'm not sure what I'm doing wrong, but any ASP code I put in the source code doesn't publish. For instance, I might use a Date function between <% %>. You can see it in the source code, but when you try to bring it up in Internet Explorer it doesn't show at all. Currently I have IIS 3.0, and...