Search results

  1. S

    import from access to outlook

    I think the user defined fields in Outlook have to be referenced differently. Take a look at www.slipstick.com, especially the link for OutlookCode.com or something like that.
  2. S

    Excel VBA Listbox

    I tried exactly what you've posted here and it worked fine. ??
  3. S

    Not all pages print in a report of images...

    It sounds like you may be exceeding the memory of your printer??
  4. S

    Transfer details from one page to another

    <form> <input type="text" name="MyText" value="<%=request("TextBoxFromPreviousPage")%>"> </form>
  5. S

    British Television

    I'm not sure what part of that was swearing. OK, how about this old favorite... "Who wants to be on a copy a British TV show?"
  6. S

    British Television

    We (wife=British; me=Yank) catch it on BBC America now and then. I think it's quite funny, but then...I suspect my wife has brainwashed me to think that anything British is far superior to anything American. Advice from a slightly Anglicised American: If you see a British show that you don't...
  7. S

    SaveAS Question

    Here's something to get you started...Public Function SaveIt() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogSaveAs) fd.InitialFileName = "c:\MyFileName.xls" fd.Show Set fd = Nothing End Function
  8. S

    Syntax Error

    I have used LIKE with/without a wildcard and it worked for me. For instance, a combo box on a form with definitive selections for query criteria, and a "*" added to the rowsource in case you want to pass all records... In the query, I use LIKE Forms!MyForm!cboCriteria. If you select the...
  9. S

    Great Function - if it worked....!

    Once I embed an image into a button, I can trash the source pic and it still works. (Access 2003)
  10. S

    Make MSGBOX come up over all apps running

    Take a look at AppActivate... From Access VBA help: AppActivate Statement Activates an application window. Syntax AppActivate title[, wait]The AppActivate statement syntax has these named arguments: title Required. String expression specifying the title in the title bar of the application...
  11. S

    Scooters

    The pics ain't workin' for me.
  12. S

    Syntax Error

    It looks like you are filtering the primary key (senderID) with text criteria (SenderName).
  13. S

    Type Mismatch in For Loop in ASP

    Look in your For loop...you forgot to put an '=' or Response.Write in front of the array... <% For I = LBound(arrSelectedItems) To UBound(arrSelectedItems) %> <%=arrSelectedItems(I) %><BR> <% Next %>
  14. S

    Catch empty item template?

    Thanks for the insight there...seems like a good method. I actually put this project on the back burner because my EMPLOYER has no plans to load the dotNET 2.0 framework.
  15. S

    Unspecified error

    Shouldn't that be adoCon?
  16. S

    formula in excel

    Yes, it sums all the A2 cells in the range of sheets.
  17. S

    Upper Case Wildcard?

    Right, I wrote that function quickly over my morning cuppa. It has no error control at all. This mod to the function will ignore blank entries... Public Function InsertSpace(txt As String) As String If txt & "" <> "" Then For i = 2 To Len(txt) If Asc(Mid(txt, i, 1)) < 91 And...
  18. S

    Upper Case Wildcard?

    Use your table's field name in place of pname.
  19. S

    Upper Case Wildcard?

    In the database window, go to 'Modules' and select 'New'. VBE opens...paste a function in the white space and click save...call it Module1. Here is the SQL for a query that uses the function I presented in my last post:SELECT InsertSpace([pname]) AS SplitName FROM ppl;Presto...you are...
  20. S

    Server Computer = Home PC ??

    This is something I've been pondering on. Vassago, would you care to give a few pointers on using a home PC as a server? Is it necessary to run Windows Server OS? Would it be possible to set up a PC with WinXP Pro as a pseudo-server? I'm thinking...chock it full of hard drives, connect...
Back
Top Bottom