Search results

Hi, I did actually remove the admin user from the admins group so that cant be the problem. Please could you explain how I setup a shortcut with the MDW file? And how do I split the backend from the front? Do I need to place the workgroup file on the network? Thank,

Hi David, It is part of the Access security workgroup. It works fine on my PC just not on other users!! Thanks,

Ok, so how do you go about actually doing this?

Hi, I have an access database which i've converted to a 2003 version so that I can use Access User names and permissions. I have setup a number of logons with various levels of permissions and am now ready to release the database to the users. The login works fine on my local machine...

Hi, I've just finished creating my first database in Access 2007 and to finish it off I just want to add some user security. For example I want 3 different types of user - an admin, someone who can edit data and a read-only access user. I thought this would be relatively simple to do...

Hi, Ok, so I have a problem that in theory should be straightforward to fix but I cant seem to do it! I have an excel spreadsheet which contains a number of columns which each relate to a column within access. All fields except one will be imported into only one table called 'Master table'...

Hi, Thanks for the response. That works if the combo box is not bound to another field. However, as soon as I associate a value with the 'Control Source' option of the combo box it wont automatically select the value. Is there anyway around this problem? i.e. so that when the user adds the...

Hi, Basically, I wish to automatically select a combobox value when the form loads based on a value selected in another form. So just to give you an overview of what my forms look like I have a form called 'View_Sales_Orders_frm' with a combo box which we'll call combo1 for now. If the...

Just for reference I have now solved this. Basically the code was pretty much there, just had to change the last line to 'Me.RecordSource = sSalesOrdersSQL' rather than 'Me.Sales_Order_tbl_subform.SourceObject = sSalesOrdersSQL' Thanks,

Thanks YNWA for your help. Is there anyone else who knows how to do this? The code I have so far is this: Private Sub Project_Name_cbx_AfterUpdate() Dim sSalesOrdersSQL As String sSalesOrdersSQL = "SELECT * FROM Sales_Order_tbl WHERE [Project_ID] = " & Me.Project_Name_cbx.Column(0)...

Yes that is correct. The project is selected and it should show all records related to the selection in the subform - which is displayed as a table. So if I create a field showing the project_ID then link this to the subform?

There are 2 columns and the bound column is column '1'. Is this information ok or do you need more? Basically, the combo box shows a list of projects and I want the subform to display a list of records based on the users selection (The link will be the 'project_ID' field). At present the...

Hi, Im new to access and am trying to link a combo box to a subform. Basically, the combo box is called 'Project_Name_cbx' and the subform is called 'Sales_Order_tbl subform'. The combo box has 2 columns, its row source is: SELECT [Project_tbl].[Project_ID], [Project_tbl].[Project Name]...