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!

Register Log in
  • 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. StevenFromSouth

    VPN Connects but cannot access remote network computers or folders

    I am connecting to a remote network via VPN. I can make the connection but cannot access the remote's local network even though I have allowed access on the Server's Incoming setting. The login account has read/write permissions to the local shares. Both Remote and Client have different local...
  2. StevenFromSouth

    Delete record from one table if it does not exist in another

    I am having problems debugging this code. Private Sub Form_Load() Dim delsql As String Dim UnMatchedQry As String Dim rst As DAO.Recordset UnMatchedQry = "SELECT Purchases.PID" & _ " FROM Purchases LEFT JOIN PurchaseDetail ON Purchases.[PID] = PurchaseDetail.[PID] " & _...
  3. StevenFromSouth

    Using .Fields() method in Recordsets for calculations.

    Hi all, I was fiddling around with Recordsets in VBA and I noticed that you can do things like this "SELECT TOP 1 TotalCost/Amount FROM Sales WHERE [SalesDate] <= " & strDate & _ " And [ProductID] = " & PID & _ " ORDER BY [SalesDate] Desc;" also With...
  4. StevenFromSouth

    How to join tables to get current price of a product.

    Hello, new member here. I'm not too good when it comes to queries but I wanted to stop using DLookups, I've read that they can be highly inefficient and unstable. I saw some posts on this forums and Allen Browne have emphasized that joined queries and subqueries are far superior. I have a...

Part and Inventory Search

Back
Top