Search results

Hi you would need to use the access log-in system: Tools > Security > User & Group Accounts - you would then create your users, then use the user & Group permissions to set up permissions etc... i also use some code that disables or hides certain elements depending upon which group the user is a...

Another possible route, copy the system.mdw file to another location and point to that mdw via a shortcut similar to: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Performance_Pack\Local_Performance_Pack.mdb" /WRKGRP "C:\Performance_Pack\offline\Security.mdw" Hope you get the...

Not too sure if this will help as i dont have access to a97, but do your log in credentials place you in the admins group, if so - would it be possible to change the properties of each of the forms, queries etc... to give administer rights to the users group??? This is probably the only route i...

Hi AN60 - I forgot to mention that - if you have no security setup on your database, it will change the default user account and set it with the password you set. obviously user name would be Admin but the password which is usually blank will change to whatever you desire Ian

I cannot take credit for this form but have used it in several databases and thought others may find it usefull, if you use security enabled databases drop in this form and without any modification it allows users to change only their own password, but if you are a member of the admins group...

Not too sure what a pass-through query is but i have a similar query which takes yearstart and yearend from a form, may help then again may not... SELECT qryAmbCatA8.MonthEnding, qryAmbCatA8.TotalCatAResp AS [Total Category A Responses], qryAmbCatA8.Performance, qryAmbCatA8.Target FROM...

The only way i could think of would be to add TB to the Query as well as TA - then change the 'Table' that is referenced using the drop-downs, Then remove TA - but this is time consuming, as i have just had to do the excercise myself. But it does save re-creating them all Ian

would the following work? UPDATE table1 SET table1.quantity = [table1.quantity] - 1 WHERE (((table1.barcode)=[Barcode please])); Ian

Hi - I found the following link a very usefull knowledge base for this type of datediff calculations http://support.microsoft.com/?scid=kb;en-us;210604&spid=2509&sid=202 Regards - Ian

Im still a bit of a novice at SQL but would this work: SELECT SUBGROUPS.*, TAGS.ID, ALARMS.* FROM SUBGROUPS, ( SELECT TAGS.ID, ALARMS.* FROM TAGS RIGHT JOIN ALARMS ON TAGS.NAME1=ALARMS.NAME1; ) AS QUERY1 LEFT JOIN QUERY1 ON SUBGROUPS.ID=QUERY1.ID

Thanks for your help Neil, will have a read up on that Regards Ian

Hi Neil, Thanks for the reply, where you say i would probably have to build the query in code, i am a little unsure of what you mean, would i have to create the code as SQL in the vb window on an event for example on load or on update? Thanks Ian

Hi - I wonder if anyone could possibly help, I have a list box that is populated by a query, which currently populates the list according to which site is selected within a combobox - what i would like to do in addition is to have a check box which controls how much data is shown, ie, if the...

Add this code to the on_click of your exit button, Which will prompt the user if the want to exit, if confirmed then the query is run without warning and the application then closed. Private Sub btnClose_Click() Dim Answer As Integer Dim myRec as dao.recordset Answer = MsgBox("Do you wish to...