Search results

I am having a recurring issue with an Access Lock file that does not get deleted when all users exit the application. It does not look like users are prevented from opening the db, but I want to repair the db and am not sure if this is OK to do with the lock file hanging around. I was...

I am running Access 2000. I was wondering if anyone knows if there is a way to open querys in SQL View when the Design button is clicked. I edit my querys in SQL View 90% of the time and find it cumbersome to have to change views from the UI designer to SQL every time. Thanks

OK - I gotcha. I commented out the following line in my form's OK click event handler. DoCmd.OpenQuery "qryInventoryDetailsDivisionParam", acViewNormal, acEdit For some reason, I was thinking that this is what got the query to execute to populate my report. I forgot that the RecordSource...

In Access 2000, I have created a report that uses a Query as the RecordSource. rptMyReport RecordSource: qryInventoryDetailsDivisionParam The Query requires one parameter which it gets from a form. SELECT [InventoryItems].[InvCtrlNum], [InventoryItems].[ItemDesc]...

Both PCs have Access 2000 which is 9.0 if I am not mistaken. My PC also has Visual Studio 2003 installed and I am guessing that this is how the Office 10.0 Object Library stuff ended up on my PC. I think have narrowed the Reference problem down to a Mid$ function call. When the code executes...

Both PCs have Access 2000 which is 9.0 if I am not mistaken. My PC also has Visual Studio 2003 installed and I am guessing that this is how the Office 10.0 Object Library stuff ended up on my PC. I think have narrowed the Reference problem down to a Mid$ function call. When the code executes...

I am running Access 2000 and included the Microsoft Office 10.0 Object Library in my VBA references. I am now sharing the DB on the LAN and one of my users does NOT have the Office 10.0 Object Library. We both have the same version of Access and VBA and the same OS - XP Pro SP 2. Microsoft...

I have configured my Access db Security so that users in my Clerks group can do pretty much anything except Delete records. The db now resides in a shared folder on our LAN. When I launch my DB from my PC as user CLERK1 (with the /workgrp option and the appropriate MDW file), I have no problems...

VBA code for Switchboard I figured it out (and am guessing that this is where you were headed). The Click event in my Switchboard code was getting an error trying to launch any form with no permission. I ended up adding code to check the error and if it was No Permission to display a more...

I decided to try a slightly different approach (per your suggestion). I removed all permission to my Maintenance Form for the Inquiry group. Seems simple enough. HOWEVER........... If an Inquiry user trys to launch the Maintenance Form ia my Switchboard form, instead of getting "No Permission"...

Yes it helps.......but I am still quite confused. Are you saying that updating the contents of a combo control on a form via a query requires Modify Design permission?

The RowSource query is not defined in a Query object if that is what you mean. The query is defined in the combo's RowSource property as follows. SELECT DISTINCT [ItemTypes].[ItemTypeID], [ItemTypes].[ItemTypeDesc] AS [DESC] FROM ItemTypes ORDER BY [ItemTypeDesc]; The contents of the combo...

I am getting a "Recordset is not updateable" runtime error when the following line of code tries to execute. ' Set the combo to the 1st record Me.ComboSubtypes = Me.ComboSubtypes.Column(0) This ONLY occurs with users in my new Inquiry group (defined in the Security/Permissions). The...

Same message but not the same problem. That guy only had the problem after installing a new Access Version and forgetting to apply a Service Pack. I have no changes to Access and/or my OS whatsoever. The only thing that I have changed is I configured Access security/permissions and the...

RE: Hiding the button I am tempted, but the premise is that Access Security & Permissions is supposed to make this easier - with no need to modify code. The user either has permission or doesn't. I am part way there, but apparently I have done something wrong because the message being...

I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured. I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main...