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 TouchToneTommy 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: *

  • Users: swmagic
  • Content: Threads
  • Order by date
  1. swmagic

    Email enables Sharepoint contacts

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

    Hosted Sharepoint; Incompatible Hyperlink

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

    Dlookup a value and displaying it on a form

    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"...
  4. swmagic

    SaveRecord isn't available now

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

    VB: Convert cvs to xls

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

    Expression typed incorrectly...

    I click on a report button on frmA (data entry form) that brings up the report's parms on frmB. Then I click on the print button in frmB, close frmB and the rptC displays. When I click the toolbar print icon, it says "Now Printing" followed immediately with the message "The expression is typed...
  7. swmagic

    Document Assembly w/Pagemaker

    Does anyone know how I can string and print multiple documents together for a single printing. I have about 200 forms and I would like to print all of them at once. I'd rather not just highlight a list, but instead have some profile set up to do it. Is there any document assembly software that...
  8. swmagic

    Result set access in VBA

    Why is this not a valid construct from within a form? Specifically, when I put in the msgbox the whole operation just simply fails (no msgbox, no breakpoint). It works fine when I take out the Msgbox Dim db As Database Dim QD As QueryDef Dim RS As Recordset Set db =...
  9. swmagic

    qryA access of result set in code

    I've heard that you can't get access in the vb code to any of the fields in an OpenQuery and that you have to do a DLookup. Yet here in some production code I found that the field [annualizedcharges] is being stuffed back into an update table. When I use "msg [annualizedcharges] the program just...

Part and Inventory Search

Back
Top