Search:

Type: Posts; User: Static

Page 1 of 13 1 2 3 4

Search: Search took 4.51 seconds.

  1. Replies
    0
    Views
    890

    Add-In - disable button on wkbk load

    I cant seem to figure this one out.
    I have and add-in a created.. I need to check the workbook name on open and disable/enable certain buttons
    Problem is when you open the workbook - the add-in...
  2. Replies
    3
    Views
    656

    VS 2013 Re: Web update not working?

    its the click once, yes... I dont think it skipped it but I will re-publish and see if that works. Thanks Shaggy! (cant you tell I am way out of practice? lol)
  3. Replies
    3
    Views
    656

    VS 2013 Web update not working?

    I think I broke something... I have a POS system I made for my wife. had it set up so that when she opened it, it checked for an update online. I made some changes and uploaded the update... when she...
  4. Thread: ProperCase

    by Static
    Replies
    4
    Views
    804

    VS 2013 ProperCase

    Question... I am using the ProperCase to auto fix names entered...
    txt.Text = StrConv(txt.Text, VbStrConv.ProperCase)

    but, on occasion there are names that have multiple capitals like JoAnne or...
  5. Replies
    2
    Views
    3,718

    Compare date to a list of dates?

    wondering if there is an easy way to do this..

    I have a list of dates (like 3 or 4) as strings.. I need to check if currDate is == to any of them

    If (currDate=="02/13/2016" ||...
  6. Replies
    5
    Views
    812

    MsOf13 Re: Excel Advice 440K rows

    its not big... xls file is like 4 mb so the text will be less.... I wonder If I can push the compare list out as a CSV to make it smaller before even loading.

    Thanks!
  7. Replies
    5
    Views
    812

    MsOf13 Excel Advice 440K rows

    I need to create a VBA script that will scan the current xls sheet (XLSA) (one column in up to for sheets) and compare it to a second xls (XLSB) to check if the ID has bee used before. Easy enough,...
  8. Replies
    2
    Views
    853

    MsOf13 Re: MSACCESS - Cant Delete Object while open

    Each user has a local copy that they can create queries etc... I cant replace the entire DB or they will lose everything. Each copy pulls from shared base DB ... the main data tables will import, and...
  9. Replies
    2
    Views
    853

    MsOf13 MSACCESS - Cant Delete Object while open

    I have been trying to close a form, then delete it.. but it seems to not want to close

    The object is to import an updated version of the form...
    So I have an Update Button which calls another...
  10. Re: PHP cURL and DOMDocument - reading the page

    ahhhh well that makes sense! so since its only updated after I (the client) receive it on my browser... PHP isnt seeing it.

    well shoot. I will check out that phantom JS. Thanks!!
  11. [RESOLVED] PHP cURL and DOMDocument - reading the page

    ok, I am stumped... I am trying to grb info from a page.

    the HTML source shows this

    <span class='status' ng-hide='campaign.updating_worth &gt; 0'>
    {{ contestantEntries() }}
    </span>

    but the...
  12. Replies
    1
    Views
    1,212

    Oracle SQL - get previous weekday

    SELECT
    INVOICE.APINVOICE,
    UIS_HISTORY.MODIFIED_BY_
    to_date(to_char(UIS_HISTORY.DATE_OF_CHANGE, 'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
    FROM
    INVOICE,
    UIS_HISTORY
    WHERE
    (...
  13. Re: SQL slow to connect after sitting for a bit

    yeah digging around last night seem to point to that....

    Anyone have any ideas about that?
  14. SQL slow to connect after sitting for a bit

    I have the vb.net program and the MS SQL Server on the same machine (its a POS program)
    If the POS sits for a little while, 10, 20 minutes.. the first sale to go through takes a good 20 seconds to...
  15. Re: How did I create a RDLC report? lol

    ... after 3 hours of looking... I post this..


    and I found it lol...
    MS SQL Server Report Builder 2012
  16. [RESOLVED] How did I create a RDLC report? lol

    ok dont laugh!!!
    Well over a year ago.. I created a whole POS system for my wife... well now she decided to start using it :) lol
    There is an issue on the rdlc file that is here work order sheet....
  17. Replies
    9
    Views
    17,701

    Re: JSON Not letting me post a URL?

    :blush::rolleyes:


    well... I suppose that might work.... Im going to go drink now. lol
  18. Replies
    9
    Views
    17,701

    Re: JSON Not letting me post a URL?

    I am not running it in a debugger :D , but the JS is stopping right at the point it needs to send the data to the php file...
    I will try encoding it...if you remove one / it works. http:/blah.blah ...
  19. Replies
    9
    Views
    17,701

    Re: JSON Not letting me post a URL?

    no lol

    the VALUE of var user_fb=$('#fb_name').val(); will be a URL
    so it breaks it as it tries to pass the url through json to the php... its like I need to escape the /'s but cant seem to make...
  20. Replies
    9
    Views
    17,701

    [RESOLVED] JSON Not letting me post a URL?

    How do you all a URL to pass thru json?

    http:// is breaking it... im guessing its the // because if I remove one it works...


    $('#save_social').click(function() {
    ...
  21. Replies
    5
    Views
    1,417

    Re: preg_match

    lol those were cool :) looong gone now im sure.

    I found the answer!

    after using this:
    https://www.functions-online.com/preg_match.html

    to try over and over...
  22. Replies
    5
    Views
    1,417

    Re: preg_match

    lol Hey dclamp!!! .. nice avatar lol
  23. Replies
    5
    Views
    1,417

    [RESOLVED] preg_match

    I have never been good with regular expressions...


    function getTitle($Url){
    $str = file_get_contents($Url);
    if(strlen($str)>0){
    $str = preg_replace('/\s+/', ' ', $str);
    ...
  24. Replies
    3
    Views
    1,213

    Re: php / mysql date

    sorry.. yes
  25. Replies
    3
    Views
    1,213

    Re: php / mysql date

    .... sigh.. yep.. stupid.

    forgot the ' 's around the date in the query
  26. Replies
    3
    Views
    1,213

    [RESOLVED] php / mysql date

    if(strtotime($c_end) !== false) {
    $c_enddate=date('Y-m-d',strtotime($c_end));
    }else{
    $c_end='DEFAULT';
    }

    $query="INSERT INTO contests VALUES(DEFAULT,'" . $c_title . "','" . getUrl($c_url)...
  27. MsOf13 MS Access VBA to Outlook - This SHOULD work?

    Its very strange...
    I had 2 subfolders of Skipped created (Unknown and Duplicates) and was trying to set a variable to the "Unknown" folder.
    it keeps erroring saying an object could not be found....
  28. Replies
    5
    Views
    1,221

    Re: Move Cursor then click?

    perfection... thank you.


    (still seems so much to click when you can move it so easily!)
  29. Replies
    5
    Views
    1,221

    [RESOLVED] Move Cursor then click?

    maybe im missing something but all the code i find seems EXTREMELY complex to just click the left mouse button?

    I move it..

    Windows.Forms.Cursor.Position = New Point(907, 649)

    Now.. click...
  30. Re: Listview - highlighting two or more instances of an item then show mutual strings

    This is going off memory (bit rusty) and not knowing the objects...

    essentially, you need to check each sub items for the text as well...


    For chkCell = 0 to Listview1.Items.count -1
    ...
  31. MsOf13 Re: Excel HYPERLINK formula using function

    ok.. well im stumped. It works today (using the PathCheck function)

    ?????

    I guess... thanks? lol
  32. MsOf13 [RESOLVED] Excel HYPERLINK formula using function

    Trying to make this work..

    In col E i have the folder name.. in Col D i want the Hyperlink.

    so i am using the formula =HYPERLINK(thePath(D5,-1))

    this code should also put a TRUE or FALSE in...
  33. Re: Extract two lines from Outlook email body - can only extract the first line VBA 2

    essentially you want go put in in column L correct?

    assuming there is never a 3rd fault...


    Should be


    If InStr(1, vText(i), "Fault :") > 0 Then
    vItem = Split(vText(i), Chr(58))
  34. Replies
    8
    Views
    976

    Re: Problem with filtered rows

    you're welcome!
  35. Replies
    8
    Views
    976

    Re: Problem with filtered rows

    you could also use a Vlookup()

    easy...
    in ColB in sheet 2 (or whatever col you want...)

    paste this in

    =VLOOKUP($A:$A,Sheet1!$A:$A,1,FALSE)
  36. MsOf13 Re: Access INSERT 1000's of rows from Email - best method?

    HEY!!!! Yeah it has been a while :) Things are good here.. how about with you??

    Yes.. Access hooks to one email inbox, grabs each email, splits by vbcrlf, then loops through and does an insert...
  37. MsOf13 Access INSERT 1000's of rows from Email - best method?

    Hi!

    I have a daily email... it has anywhere from 500 to 3000+ lines that need to be scanned into a table (they are huge file names)

    currently doing in a simple loop.. I split the email body by...
  38. VS 2012 (Express) Unable to satisfy all prerequisites for App

    Creating a simple contact tracking app for a friend... Whipped it up and sent it to him. When he runs the Setup.exe he gets the error

    "Unable to satisfy all prerequisites for Gulfstream. Setup...
  39. Replies
    7
    Views
    1,290

    VS 2012 Re: FTP huge file list...

    :P ok, i shuffled stuff around and THAT doevents stayed... there are a few of them. (not seen).. sheesh! lol
  40. Replies
    7
    Views
    1,290

    VS 2012 Re: FTP huge file list...

    i would have ZERO clue how to due that... never tried it
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width