Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ergonzalez

    How do I Restrict Access to Users?

    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...
  2. ergonzalez

    Need Help with Forms Combo Box

    It still does not work for me.
  3. ergonzalez

    Need Help with Forms Combo Box

    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...
  4. ergonzalez

    Need Help with Forms Combo Box

    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...
  5. ergonzalez

    Need Help with Forms Combo Box

    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...
  6. ergonzalez

    Need Help with Forms Combo Box

    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&quot...
  7. ergonzalez

    Need help with drop down list

    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...
  8. ergonzalez

    How do I create formulas between two workbooks.

    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.)
  9. ergonzalez

    How do I create formulas between two workbooks.

    It would be easy if I only had to do a few cells, but I've got about over 300 cells that I would need to do that with. Is this the only way
  10. ergonzalez

    How do I create formulas between two workbooks.

    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...
  11. ergonzalez

    Excel Macro

    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&quot...

Part and Inventory Search

Back
Top