Recent content by rbertram

I have sucessfully connected to SBS 2003 using PPTP from an XP client, but cannot browse the network shares. The local IP for the client is 192.168.1.102, the VPN IP is 10.100.100.2. The local IP for the VPN server is 192.168.10.10 and VPN IP is 10.100.100.1. The server is using AD, but not...

I want to run some code based on what security group the current user belongs too. I know how to check for the currnet user, but not the group. Any ideas? Thanks.

Yes, I have tried using DAO, but it results in the same error. I have a reference to the DAO 3.51 library.

I am trying to update a form after I change the value of a combo box. I have tried the code listed in the FAQs (faq702-3765), but I am getting a 2105 run-time error on one line. I highligted where the error is occuring. Private Sub Office_Number_AfterUpdate() Dim rs As Recordset...

Nevermind - I figured it out. I just created another query that grouped by ID and I set my critera to the MaxOfDate, then created and inner join between to the other query. Sometimes I think too much into a problem and miss the easiest and should be most obvious solution.

I am working with a table that records historical transaction data for an ID. The table uses an auto number as the PK. A record is created every time a new action takes place for a particular ID. I need to create a query to report all records or last record <= to a certain date, but not if...

Actually your code helped a lot. I was able to expand on your idea to do what I needed. Here is the code: Private Sub ProcessMove_Click() On Error GoTo Err_ProcessMove_Click Dim db As Database Dim rs As Recordset Dim strEmailID As String Dim strLocation As String Dim...

If I am following the code correctly, isn't this just a direct replacement for what I am already doing in the 2 SQL statements? I still need to move fields not listed on the form to the new cooresponding record. Is there something I am missing?

I have a form that moves someone from one office to another. The form a combo box for the persons ID ([EmailID])and their new location ([NewLocation]) limited to only available locations. Below it the code I currently have, but I have not been able to figure out how to copy other fields...

I thought I had. I had referenced it in another DB on a different workstation. It works now, thanks. Any ideas about my other issue?

This code does almost everything I need it to do. I am in a situation where our network will not let me link tables through UNC paths. It tells me that I do not have access rights to the path, even though I do. This may be because of the extremely long paths and the use of many spaces. There is...

Windows XP SP1 QuarkXPress 5 MS Excel XP HP LJ4000 Problem: I just upgraded from Excel 2000 to XP and now my embeded Excel tables will not print background row shading when printing to the postscript driver. They print fine deectly from Excel and display properly in Quark. If I print using the...

Is there a way to automatically fill form fields based on the value of another field? This is what I am trying to do. I have a customers table with the customer ID as the PK and I have a products table with the product ID, revision number, and the customer ID as CKs. The customer ID is part of...

Dell just dropped their prices on the Axim again.

Your right - just hit the wrong key.