I have an access database that has a table and a form. I want to give access to the users to only be able to enter information in the form.
What do I do so that I am the only one that has access to make changes to the form and table?
How do I only give access to users to only be able to...
Please disregard my previous message.
cboCategory.RowSource = SELECT DISTINCT Category FROM tblReason (I took out the quotations)
I entered the following under AfterUpdate. (I selected Event Procedure and clicked on the three dots:
Private Sub cboCategory_AfterUpdate()
If...
Thanks for your quick response. I still need help.
I have the following:
cboCategory.RowSource = SELECT DISTINCT Category FROM tblReason (I took out the quotations)
cboCategory.AfterUpdate = If IsNull(cboCategory) Then
cboCode.Enabled = False (I only have the options to select yes...
Do I need to do something to make the Category and Code are joint primary keys?
I need help with the following:
In cboCategory.AfterUpdate event put
If IsNull(cboCategory) Then
cboCode.Enabled = False
' ( This stops user selecting Code before Category is valid )
Else...
I have created a form with two different combo boxes. The 1st combo box is named: "Reason Category" and the second one is named: "Reason Code". There are 14 different choices to chose from for the Reason Category.
Here is where I need help. The "Reason Code"...
I am creating a table with different information. This is the first time I've used access so I don't know if I'm using the correct terms.
I built two drop down boxes that depending on what I choose on the first box, something different will appear on the second box. For example: If I...
It has the information but there are several sheets in the Brock Email that I need to transfer to the Estimator. The Brock Email is updated constantly and I need this information to automatically populate to the Estimator. (I also need to transfer 3 other workbooks into the Estimator.)
I am not sure if this will make sense but I'll give it my best shot.
I have two different workbooks. One is called "Estimator" the second is "Brock Email". I need for "Estimator" to automatically populate the information from the certain cells in "Brock...
I am not sure if this will make sense but I'll give it my best shot.
I have two worksheets. One is called "Estimator" the second is "Brock Email". I need for "Estimator" to automatically populate the information from the certain cells in "Brock Email"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.