Search results

Re: Access 97 side by side with 2007 Runtime Never mind, I found the trick about cleaning out the self-registering file (MSACESS.SRG) in the Access installation directory.

I have a Access 97 Database running just fine. In order to mix things up a little bit, I would like to add a 2007 Runtime database on the same desktop. It will be accessing it's own database, not the 97 database (which is being fazed (sic) out.) So far, this has not worked as when the 2007...

Thanks Doc! Greg

I have an Accounts Form which the user opens after entering an account number. Then, when the user wants to record a payment, the user clicks a payment button which opens up the Payment Screen and sets the filter to the current account. (The payment data is actually part of the Account table)...

Thanks. I finally figured this out using a macro. Hope you get your issue figured out. I looked it over, but it looks like you have many good suggestions already. Greg

Access 97 I have a Parent Form named Employees. I have a second form which is brought up when clicking a button. The second form is called frmAbsences. When the button is clicked I want to create a new Absence, and I need the EmployeeID already populated along with the EmployeeName. Right...

OK, I have gotten this far. However, I get the following error: Object variable or With block variable not set. Dim isAdmin As Boolean isAdmin = False Dim currentUser As user Set currentUser = currentUser() Dim currentGroups As groups Set currentGroups = currentUser.groups Dim aGroup As...

I have a form. When the form closes, I need to take action based on whether or not the user is a member of the Admin Group. Is there a way to do programmatically determine the group of the current user in Access 97? Thanks, Greg

I have a screen that has one large textbox on it. The user goes to this textbox and adds information to the bottom. The text can get very long, several thousand characters or more. (I know it's poorly designed, but I can't change that at the moment.) I would like to add some code so that the...