Search results

  1. E

    how refernce a value in a field to a table and populate another field with a value

    Here is my table layout.I also have sample data in thetblHoppingPattern table, this table is just a reference table that has the values already in it and those values will not change. On the subform is connected to the tblSystemConfiguration. The field sysNetworkNumber on the subform will have...
  2. E

    how refernce a value in a field to a table and populate another field with a value

    Hey all, I am having a problem figuring this out. I am developing and database app that house numbers for frequency pattern. I have a form with a subform in datasheet view. The two forms are form two separate tables linked via accountID. My problem is I have this field called network number...
  3. E

    how to hide access window

    I found it, I have to use ptrSafe in the function declaration. Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long Dim dwReturn As Long
  4. E

    how to hide access window

    yeah my bad, I meant how do I adapt the function to work on a 64 bit OS
  5. E

    how to hide access window

    How do you set up the function to work with 64 systems? I am running window 8 pro and Access 2010. I want just my user forms to show and not the access window. Here it the code but I don't know how to set the function API to 64 bit users Private Declare Function IsWindowVisible Lib "user32"...
  6. E

    Filter By Multiple Comboboxes on a form

    I got this code I found and tweeked for my purpose but you can create a form and have drop down boxes and link them to values in you tables. You can pull distinct values for you drop down if you want or hard code them. This code helped me. You create the form add the controls and add the...
  7. E

    how to disable a control on another form base on user login

    I figured it out, I need to get some values from my login form, I was closing the form instead of hiding it once the login button is click, I keep getting a error saying it could not reference the form. It's a learning process :)
  8. E

    how to disable a control on another form base on user login

    Hi, I am still new to Access VBA and was wondering if you could help me. I created a user login form that checked the value of a dropdown box for user name and text box for password. I have a table called privileges that has the following fields ID, username, password, and privilege level. The...
  9. E

    Hi all I am new to Access

    Hi members, my name Evanark and I have just join the forum. I have started using Access about a year ago and have learn on my own so I am still new to the VBA program. I hope to learn a lot from you all!
Back
Top Bottom