Search results for query: *

Refer to this video for the solution https://www.youtube.com/watch?v=UOG-UlXNmDw Things to do: [ol ] Make sure that the VPN Server's IP assignment is within the DHCP Pool. I was using from 2.2.2.1 when I should have used from 192.168.1.1 (eg 192.168.1.50 to 192.168.1.59) Allow UDP 1723 in the...

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

The code works. I just changed this UnMatchedQry = " SELECT PID " & _ " FROM Purchases " & _ " WHERE PID NOT IN (Select PID From PurchaseDetail)" to this UnMatchedQry = "SELECT Purchases.PID" & _ " FROM Purchases LEFT JOIN PurchaseDetail ON...

I'll try it out and see how it goes. Yes the Access crashing is something that I need to address and been trying to do for a couple of weeks now. On a combobox in the subform I am using the Find As You Type code provided by MajP Link Sometimes when the combobox gets focus Access freezes as crash.

I did answer. I said just the 1 record in the Purchases table but not in the PurchaseDetail table. It is generated when I open the Purchase form for Data Entry and Access crashes. The ID was not passed from the Main form to subform which is the PurchaseDetail recordset.

I only have to delete the one record that is created in the Purchases table when Access crashes. Using the "NOT IN" method takes a while just to delete that one record.

delsql = " DELETE FROM Purchases " & _ " WHERE PID NOT IN (SELECT PID " & _ " FROM PurchaseDetail)" CurrentDb.Execute (delsql) This takes very long to execute sometimes even freezing Access. The other one works fine but as you said it only deletes one. How to delete all the...

Yeah I know. I have a Main form with a subform on it, what happens is that sometimes when I move from the main from to the subform ms access crashes and the ID is left in the Purchase Table and not in the PurchaseDetail table.

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] " & _...

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

Thank you that worked.

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