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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RCSNC

  1. RCSNC

    W2K3 Server - Mac Clients can't connect to UAM

    I have just installed a Windows 2K3 Server in a school with a 15 node Mac lab running 9.2. I installed File Services for Macintosh but am unable to get any of the Macs to load the UAM volume to update the AppleShare The server appears in the Chooser but when selected returns the message...
  2. RCSNC

    Sending an e-mail to the results of a query

    When sending the message to one recipient I'm using the code: Private Sub EnableEmail() ' Update the email button On Error Resume Next cmdEmail.HyperlinkAddress = "mailto: " & Me!EmailAddress End Sub I think I need to create a string of addresses in something I can call...
  3. RCSNC

    Sending an e-mail to the results of a query

    I've read through several posts on this topic but none seemed to answer my question exactly. I'm new to Access and need "exact" I want to (from a command button) start an e-mail to all the e-mail addresses in a query. For example, I have a query named newStudents which selects all...
  4. RCSNC

    In a question somewhat related to m

    Sorry, I'm new to Access. I did mean table - but regardless the column property only works in macros and vb. I probably broke several other design rules but I got it to do basically want I want by changing the bound column to the second column.
  5. RCSNC

    In a question somewhat related to m

    I'm sorry for the delay in responding... The column property is not available in Design view. However, at least I understand now why it's showing the ids. Any other ideas?
  6. RCSNC

    Combo box selection based on another Combo box disappears?

    Eupher, Once I make a selection in classTypeCombo it should stay selected unless I change the divisionCombo. For example, if I select "DivisionA" and my choices in classTypeCombo are "TypeA1", "TypeA2", etc. I want to be able to make a selection, go on to the...
  7. RCSNC

    In a question somewhat related to m

    In a question somewhat related to my previous post... In a table named schedule I have two combo boxes named divivionCombo and classtypeCombo Here's my record source for divisionCombo: SELECT [divisionID], [divisionName] FROM Division ORDER BY [divisionName] and for classTypeCombo: SELECT...
  8. RCSNC

    Combo box selection based on another Combo box disappears?

    I have two combo boxes,divisionCombo and classTypeCombo, on a multi record form named schedules I am trying (as many other newbies before me have) to have the contents of the classCombo based upon the selection made in divCombo. Here's my record source for divisionCombo: SELECT [divisionID]...
  9. RCSNC

    Problem communicating with OLE Server

    I figured this one out - after a restart the databases opened without error. The error message above began only after opening MS Outlook, then Access I reinstalled MS Outlook - loading everything, not just the typical - and it now works fine. No idea which of the components actually fixed the...
  10. RCSNC

    Problem communicating with OLE Server

    On a W2KPro SP3 box, running MS Office 2K, SP3 a user cannot open any database without getting the following error message: "A problem occurred while Microsoft Access was communicating with the OLE Server" The message is received even if you open a new blank database. The databases...
  11. RCSNC

    Modifying Data in Access then Exporting to CSV file

    Thank you! This was exactly the info I needed.
  12. RCSNC

    Modifying Data in Access then Exporting to CSV file

    Access Newbie - Here's my problem: I need to import a CSV file into Access 2K, modify the fields (for example - concatenate the fields firstName and lastName into "CommonName=firstName(space)lastName..." and place the modified data into a field in a different table) and then export...

Part and Inventory Search

Back
Top