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!

Register Log in
  • Congratulations derfloh 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: TLady
  • Order by date
  1. TLady

    IF HasData

    Ok, and what about a STAR for the man who solved your 3 days headache ? I'll do it, Ken. TIA
  2. TLady

    How can I declare a variable that will contain value from by db

    Open Table that contains data you reffering to (in Design view) and look what datatype field is. This will help I hope Ask if need to be TIA
  3. TLady

    VB SQL paramaters

    Yelling is form of weakness...everyone know it...as slaming the door... So, yell now... It is such a pitty that mined so brilliant is so angry. I know, I was your target more then once myself. And then I didn't feel like a peer, I felt like a customer who didn't pay :) (sigh and sadly...
  4. TLady

    actions on all workbook sheets except except some sheets

    For i = 1 To ExcelWK.Sheets.Count xSheet = ExcelWK.Sheets(i).Name If xSheet <> S1 and xSheet <> S21 and xSheet <> S33 Then you can do from here anything you want and when loop will meet unwanted criteria - it'll skip to the NEXT Have fun !!!
  5. TLady

    VB SQL paramaters

    Do not be affraid of xlbo, he is yelling at customers all the time? Men !!! Psss, kenanber, here how to parsRS.FindFirst (&quot;[Level]='&quot; & xSheet & &quot;'&quot;) where [Level] is value from the table and xSheet - variable This is a brilliant way to pass parameter... Are you Ok now ? TIA
  6. TLady

    Global variables in Excel VBA

    You create Global module and declare : Public Const ContractStartDate = #7/1/2002# Public ReportStartDate As Variant Then you need to write function Initialize those variables. Very important. Untill Initialized - they asleep !!! I suppose this is why isn't working for you ... Function...
  7. TLady

    Need help splitting large worksheets

    I've done so much of this and have a code written. Need more detailes, though... Where id data coming from, query ? Respond if you still looking for an answer. Or I suppose Dale took care of it already ? Then star should be awarded ! TIA
  8. TLady

    Unique Item N in an Excel List

    I want FX(A1:A7,1) to return the value Albert, FX(A1:A7,2) to return the value Bessie and FX(A1:A7,3) to return the value Carrie etc, for some function FX. So, practically you want to loop through every cell and read values ? I don't see &quot;unique&quot; part ... Or you want to loop...
  9. TLady

    Outlook 2002 &quot;leave mail on server&quot; where is that option?

    You not talking about Draft, do you ?
  10. TLady

    Unreadable Word Documents

    I am dealing with Excel doc corruption right now. Try running ScanDisc to see if virus present, by then I hope someone will step up and tell more... Good Luck TIA
  11. TLady

    Hightlight Down VS Across

    You can export it for the first word TO BE in separate cell, can't you ?
  12. TLady

    Hightlight Down VS Across

    Excel definitely would... TIA
  13. TLady

    How do I the substitute a field name with a memvar?

    m_tempa = &quot;H1&quot; ' I store the value in a memvar rs.Fields(m_tempa).VALUE ' I get an error when I try this. If you set m_tempa as a Variable - you suppose to not assign value to it. Value should be calculated What you have is like Apples = &quot;Green&quot; rsFields(Apples).Value...
  14. TLady

    how and where do i declare a global variable?

    OK, open up Access and click on Tab &quot;Module&quot; then button &quot;New&quot; and Save it as _Global. Open Up and you'll see Option Compare Database Option Explicit Public YourVariableName As String (or whatever you need to be) Then next step Function GetYourVariableName()...
  15. TLady

    how and where do i declare a global variable?

    Or even better - tell what you are trying to do
  16. TLady

    how and where do i declare a global variable?

    You create module _Global And here you write under Option Compare Database Option Explicit Public Const RL2ID = &quot;TIA&quot; Public ReportStartDate As Variant (if you need datatype) Public Const ContractStartDate = #7/1/2002# Public Const TemplateFileName As String = &quot;ExcelFileName -...
  17. TLady

    auto email reports in CSV format

    I was affraid to click Download on this site you, mp9 recommending. I've been annoyed by the message too, if I AM the one sending e-mails why should I be &quot;secured&quot;, right ? Have anyone tried it ? How does it seems ? http://www.dimastr.com/redemption/ TIA
  18. TLady

    What to do after .moveprevious

    Let's forget whole thing ! We need to OPEN Recordset and display Result somewhere, right ? Using reserved words like frm=Me isn't helping at all Then how is Recordset suppose to work with Set frm = Me Set rstClone = frm.RecordsetClone I am simply wanna scream ! WHAT IS frm.RecordsetClone...
  19. TLady

    What to do after .moveprevious

    Doesn't your &quot;Me&quot; suppose to have a control to display your Recordset result ? Me.Recordsetclone seems like form has recordset... Is this suppose to be Hidden recordset :) ???
  20. TLady

    CopyObject: Macro action prompts for password

    Have you closed database on your PC before you tried co-worker's one ? Anyway if it works on your PC - it works ! So, get comfortable and tell your co-worker to reboot and compact and repair and compact again. Luck TIA

Part and Inventory Search

Back
Top