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 strongm 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. philliplaw

    VPN Setup: Can someone point me in right direction?

    It has been years since I setup a VPN server. Where I used to work, we had ISA server sitting between the internet and internal network. Now I am working at a much small business and I am not sure where to start. We have a business DSL modem with 5 static IP address. For this example, they...
  2. philliplaw

    How to a requery a datasheet on a tab?

    Sorry guys, I got side tracked. After hours of dorking around with this, the solution was: Forms![MainFormName].[NavigationSubform].Form.Requery NavigationSubform is not the subform name. it is the control name of the navigation subform (found on the "Other" tab - Name field). Phillip
  3. philliplaw

    How to a requery a datasheet on a tab?

    I have some navigation tabs in a sub-form. Each tab shows information in a datasheet. The first column of each data sheet is setup like a hyperlink with an "on click" event. Example: The "Purchase Order" tab list all the purchase orders, supplier, order date, etc. If you click on the...
  4. philliplaw

    Understanding a "Where" Statement

    This is a Macro: If [cboCustID] Is Not Null Then OpenForm New Customer Where Condition = ="[Customer].[CustID]=" & [cboCustID]
  5. philliplaw

    Understanding a "Where" Statement

    I have combobox with a list of customers. Once a customer is selected, I have a button to allow the user to edit the customer's infomation. The button launches a form with a "Where" statement. Where Condition = ="[Customer].[CustID]=" & [cboCustID] This works perfectly, but I do not...
  6. philliplaw

    What is the best way to Filtering Data

    I am new to Access and working on my first project. I am displaying information based on a Combo Box. The first time, I created a "Query" and displayed that in form. Then I figured out how to do a "Filter" within the form. Are there any advanatage or disadvantes to either method? Thanks.

Part and Inventory Search

Back
Top