Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.83 seconds; generated 2 minute(s) ago.

  1. Replies
    11
    Views
    1,057

    Re: Click event

    that was only to make the appearance of the option button on or off, it would not affect the colour changing

    of course the code as above only works for the mouseup of the specific option button,...
  2. Replies
    11
    Views
    1,057

    Re: Click event

    assuming this is for an option button, it does not toggle, it can only be changed by having another option button in a group (on a single container), to select a different option
    if you only want a...
  3. Re: PrinterDLG User Defined Type Not Defined?

    you need a reference to the printerdlg, which probably is not installed on the new machine, look for missing reference
  4. Replies
    5
    Views
    1,000

    Re: Counting and finding years

    depending if you want a formula or vba
    assuming all the dates are in a single column like column A
    =INT((MAX(A:A)-MIN(A:A))/30)
    of course just calculating for 30 day months only is a bit rough, if...
  5. Replies
    10
    Views
    1,570

    Re: create app for this temp email site

    i would think this would be against the terms of the site
  6. Re: please help data type mismatch select sum

    assuming that the comma is just a decimal or thousands separator not a list of multiple numbers
    you should not store formatted numbers, just numeric as some numeric field type, leave formatting for...
  7. Re: Error no: 484 Problem getting printer information from the system. in VB 6 app

    your attachments are broken
  8. Replies
    16
    Views
    2,275

    Re: PrintCommunication COM error

    you should be able to test quite simply in excel vba


    Dim p As PageSetup
    Set p = Sheets("sheet1").PageSetup
    p.Application.PrintCommunication = Falsethough as print communication is a property...
  9. Replies
    12
    Views
    1,536

    Re: vb6: textbox remove space at end

    probably would work when you leave the textbox, else you need to put code in keypress or some other key event to monitor for spaces as the are typed, remove spaces as typed, then put back if some...
  10. Re: A simple solution to accesing a webpage from vb6

    shellexecute will allow you to open a webpage in the default browser, but not interact with it

    w10 still has internet explorer installed, even though they don't want you to use it any longer,...
  11. Re: A simple solution to accesing a webpage from vb6

    there are many examples in this forum of basic code to access web pages, but as not all web pages are equal, any or none of may work for you
    also any code to access web pages may go of of date as...
  12. Re: LynxGrid : grid autosize columns to form size

    did you try dividing rhe width of the grid by the number of columns and making that the width of each column?
  13. Re: how do i wait till a for statement to finish

    some sort of status bar, then update during the loop
    or change to an egg timer cursor or similar, then change back when loop finishes
  14. Replies
    1
    Views
    645

    Re: Appointment calander

    i am sure it would be possible, back in vb5 i created a datepicker, just using std controls, a command button, labels and picturebox,
    also i had forgotten, but there was a thread here recently...
  15. Re: Fix This: Strictly Find That String Only

    If LCase(Left(i.Name, InStr(i.Name, ".") - 1)) = LCase(n) Then to make code easier and probably more efficient i put "prom" into variable n
    as this is case sensitive I converted both to lcase to...
  16. Re: Is it worth buying vb6 cd is it expensive

    then you need to buy vb6 where ever you can find it, as suggested, it certainly is not available from microsoft
  17. Re: mouse drag not working in vb6 editor

    thank you right on the money, so easy i have been really missing this, no idea how it might have got changed
  18. Re: Check if a barcode scanner is launched

    probably too late by then, most modern bar code scanners just work as a keyboard input, so it may be possible to detect some keyboard input and the active control, change the focus and warn the user...
  19. Replies
    11
    Views
    1,789

    Re: PointsToScreenPixelsX

    i think this one will do what you want with minimum changes

    http://www.cpearson.com/excel/SetParent.aspx
  20. Re: Is it worth buying vb6 cd is it expensive

    you can download and use visualstudio, which includes vb.net, for free, but it is not vb6 which is now obsolete in the real world, only us dinosaurs still using it

    the licencing for vb6 is quite...
  21. Replies
    4
    Views
    731

    Re: how to fix this

    instead of this you would have loop through all the items in the zip file and compare each to list 3, a huge amount of extra processing

    you can use the API to match items in the listbox for exact...
  22. Re: windows dialog pops up file replace / skip

    there is an option 16 for copyhere that will allow to overwrite any existing files without prompt, but as far as i know, nothing to skip existing files
  23. Replies
    7
    Views
    1,182

    Re: I need help to modify this calendar

    this fixes the month headers to as described

    For i = 9 To 12
    .TextMatrix(0, i - 9) = CStr(mvarYear - 1)
    .TextMatrix(1, i - 9) = MonthName(i)
    Next
    ...
  24. Re: mouse drag not working in vb6 editor

    no add ins at all
  25. Re: mouse drag not working in vb6 editor

    not sure when it stopped working correctly, but it has been for a while now
  26. Re: mouse drag not working in vb6 editor

    hard to move the execution point that way though
  27. [RESOLVED] mouse drag not working in vb6 editor

    recently i have found that i can not drag blocks of code when editing or drag the code execution point when stepping through code
    i am not sure if there are any other symptoms

    this is not...
  28. Re: VB6 Program Compiling Errors -Still Waiting on someone to help.

    do not post the executable, only the project and sample data files, i doubt many will email you
  29. Replies
    7
    Views
    1,182

    Re: I need help to modify this calendar

    try like

    for i = 9 to 12
    .TextMatrix(0, 0) = CStr(mvarYear - 1)
    .TextMatrix(1, 0) = MonthName(i)
    next
    For i = 1 To 10
    .TextMatrix(0,...
  30. MsOf365 Re: [Word] MS Word: VBA macro works normally in only debug mode

    you could try replacing sleep with doevents
  31. Replies
    14
    Views
    1,268

    Re: Open document Word with macro (.docm)

    that object library refers to word 2019, whether this is relevant to your problem is unclear
    maybe you can try late binding to see if it changes anything

    change like

    Dim mword As Object, mdoc...
  32. Replies
    14
    Views
    1,268

    Re: Open document Word with macro (.docm)

    can you open the docx or docm files if you do it manually from windows?
  33. Re: How to connect VB6 program with Google Sheet?

    use the google sheets API

    see
    https://ramblings.mcpher.com/integratingappswithotherplatforms/googlesheetsv4apifromvba/
  34. Replies
    14
    Views
    1,268

    Re: Open document Word with macro (.docm)

    it may be that a dialogue asking the user to allow macros is being shown, as it is not visible to be dismissed the document is just hanging waiting for response

    test by reducing the security level...
  35. Replies
    2
    Views
    596

    Re: VB6 chat client over internet

    i am sure there is a chat client server example in codebank vb6
  36. MsOf10 Re: Speed up the copying of data from one worksheet to another

    copy the complete ranges into arrays change all the data in the array and rewrite to cells, will be much faster
  37. Re: Increase number of undos in VBIDE for VBA7.dll

    feed it
  38. Replies
    6
    Views
    853

    Re: Urgent need this done simple code

    you can try like

    Set sh = CreateObject("shell.application")
    Set n = sh.Namespace(Text11.Text & "downloaded\kof95.zip")
    Set nn = sh.Namespace(Text11.Text & "downloaded\")
    dest = nn.self.Path &...
  39. Replies
    7
    Views
    902

    Re: Handling Non-Existent Printer Error

    test for each p in printers then set one that is known can work without error, may need to test if printer is online
  40. Replies
    6
    Views
    853

    Re: Urgent need this done simple code

    that looks like a slow way to do it
    just loop through the files in the zip and use dir (or the shell equivalent) to check if each already exists in the destination, if not then extract, no need to...
Results 1 to 40 of 493
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width