Recent content by swmagic

OK, so I moved my contacts from Public Folders to a Sharepoint folder with the hopes of using the Activities tab, but that does not show any activities. Here's the big question. If a user is using Exchange & Sharepoint and only using a public contacts folder, how does the email get associated...

Hi Jedownsjr: The first part didn't matter but the aha! appeared with your second suggestion. Even though I had a www.outlookmagic.com in the website name, as soon as I manually prefaced it with an http:// everything worked. I think that's a bug so heads up all! Paul

Well I guess this should be simple, but it does not appear to be. After I set up Sharepoint and connected to my exchange mailbox folder, Outlook added a Sharepoint folder. Good. Intuitively I believe I should be able to drag a contact down from the Mailbox Contacts folder into the Test...

This is probably an easy one. I have an SSN that the user types into form field. The Dlookup (which works) should display the result back to the form in the Exit Event Procedure for the SSN field that that they type in. [Forms].[frmAddSBNbr].[Last Name] = DLookup("[Last Name]", "tblEmployee"...

OK, so what I get is that [Last Name] and [First Name] as items in the table are NOT loaded with the lookups like [Note1], [SuppressPrintFlag] = chkPrint are. so when I do something with them: varX = DLookup("[Last Name]", "tblEmployee", "[SSN] = '" & Me.[StaffSSN] & "'") [Last Name] =...

Well I've tried all of your options, but I still get the Saverecord error. Also I thought that varX stores the result of the lookup and that it automatically maintains it in the [Last Name] and [First Name] fields without my having to explicitly load it from varX (but an attempt to load fails...

I open a form and prepare to add records: DoCmd.GoToRecord , , acNewRec The user adds in fields to the form (like a new SSN). 2 new records are created in 2 existing tables. Given the SSN, I need to lookup the first and last name from tblEmployee to include them in one of the new records...

Done and it works great! '----------------------------------------------------------------------- ' CONVERT CSV FILE TO XLS AND PROCESS XLS ROWS AND COLUMNS ' Opens and closes Excel and iterates xRows and xCols ' The Pathfile xls is NOT saved ' The hidden Excel...

Duh. Yes, sorry 'bout that. So when I add that Dim back in, I get the message "Object variable or With block variable not set". Any ideas why?

You are quite right, it does leave Excel running in the background (my bad, for now). But with the removal of objXsheet variable, the "For XRows" line gets an error "object required". What do I use in it's place: 'Dim appExcel As Excel.Application Dim Pathfile As String Dim...

Thanks for the error handling tips. OK, the code below works pretty darn good. The only problem now is that when I go to delete the xls file Windows has it locked. Anyone know how to close and delete it when I'm done?,,,oh and by the way, if an excel app is running does this code open a...

The function is passed a string path/file. The call is supposed to convert a cvs document into an xls. It works except for saving the file. I don't see the saved file anywhere. Thoughts? Public Sub ConvertCSVtoXL(strCSVPath As String) Dim appExcel As Excel.Application Dim Pathfile As...

Isn't that what DoCmd.SelectObject acReport, "rptC" did? (in the 16:38 post above) We commented that out. Even with that live, the error message stil comes up. And closing frmB just prior ot that should have closed the "modal" behavior anyway, right?

Ok, sounds awesome and I'm really excited to try that out... Just one problem. I need a translation of what that means. ;-) Clueless in LA.

True, the last two lines were added as a workaround to the initial problem. With those removed, frmB is highlighted and stuck, rptC just underneath it. Stuck means that I cannot click on anything in the toolbar, nor the report...just frmB (modal and popup="yes"?) Note that the main menu...