Search results

Thanks Rich The code works OK now.

I have tried this code but it still doesnt work! Private Sub cmbox_AfterUpdate() If cmbox.Value = "not updated yet" Then btn.Visible = False Else btn.Visible = True End If End Sub It is something to do with the "not updated yet", because if I change the criteria to a number rather than text...

I have checked with our corporate IT manager (who knows nothing about Access!), and am able to set different permissions to individual users, for example; all my department has full read/write access. but they could set read-only access for the 'stats' dept, and no access to everyone else. Would...

Thanks Pat, I didn't realise the solution would be this complicated!

I have a database held on a intranet which details staff training sessions. Is there a way in which other departments can access the *.mdb file as read-only, and cannot amend any of the data, just manipulate and statistically calculate its data.

Thanks for the advice.

I have a form which is used to display training courses, and which also contains a Combo box, from which one of 6 options can be chosen. The default option is 'Not Updated Yet', and the other options grade the success of the training. Once the training course is finished we change the status of...

Thanks, now works great.

I have a form which has 3 text boxes, which are used to enter a filter criteria, and also a triple state toggle button, so an inputter can type data which would filter a corresponding query. I want to have a button on the form which would clear the contents of the text boxes, and return the...

That works fine, but the 'txtcountenrolled' needs to be continually refreshed, otherwise it will not recognise that the number of records has increased.

Not sure if the last post helps or not? Could you advise me how to use the code above, I'm not sure how to run it, or if it will fulfill my expectations. I'm still learning Access and would appreciate any support. Thanks

There are many previous messages relating to generating email messages from Access by using Outlook, but is there a more basic way in which emails can be generated where Outlook is not installed (like the corporate system where I work!!). I have written a db which identifies staff members who...

Thanks Paul I have settled upon =Abs(Sum([Void])) to count the number of void records, and =(Count([incidentnum]))-(Abs(Sum([Void]))) to count the 'not void' records. Works great.

I have a query based upon 3 tables, and want to have a report which will calculate scenarios from the data. The query contains the fields 'date', 'incident' and 'void' (as well as some others). I want the report to include; the count of 'incident's where they are not 'void', and also the number...

Check out This Link which works well for me in a similar position. You can assign passwords to those who need the app, and if someone modifies a form, you always have the log file, to see who logged on and off. Its only low-level security, which anyone with a knowledge of access could bypass...

Brian from St Louis, USA, has also found another bug in the baslogon module; In the Module "basLogOn" go to the "LogUserOff" routine and change this: rst!LoggedOff = Now() to this rst!LoggedOut = Now() If you amend this code, it will record the log off times as well. Thanks to Brian.

I picked up a sample db from this forum which creates a security log-on for users to access databases, and although it can no doubt be easily overridden, it is ideal for what I need. Unfortunatly, the app has a bug which I cannot fix, and would appreciate help. The app creates a log of 'users'...

Spacepro I'm pleased that you too are experiencing the same difficulty, I thought it was just me!! I have looked at a number of similar samples, but this seems a really comprehensive and 'user friendly' solution - its just a shame that this bug prevents it from running 100%. If you, or any...

I have now sorted out the Reference, by deselecting ver 3.6, and selecting 3.5 as above, but when I try to do any function within user password setup, the code errors with; Complile Error - method or data member not found. and highlights; Private Sub List10_AfterUpdate() ' Find the record that...

The code includes the line; 'Requires the reference to Microsoft DAO 3.6 Object Library to be set.' Is there some action I need to take? If I look at 'references' from the tools menu, I have DAO 3.6 installed and ticked, but the 'logged out' data is still not being recorded in the tblLogTimes table