Search:

Type: Posts; User: RobCrombie

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    5
    Views
    962

    Re: Access Database INSERT INTO

    Declare a variable sSQL
    Build your 'query' into that.
    Then do a Debug.Print prior to executing the Insert.
    And post it here.
    You will probably see the error before posting it here.
    You may be...
  2. Re: Pgm cannot see the new server

    Thanks guys,
    There were a few problems in my code, caused by the changes he had made to the server name, and there were access rights problems (he had not set the same rights in the new server, as...
  3. [RESOLVED] Pgm cannot see the new server

    Hi,
    My question relates to the 'address' that can be used to find a central databse that is stored on a server.
    I have never owned a server, so I am very ignorant in that area.
    I have a vb6...
  4. Re: Excel Automation Set a Fixed Row

    Both questions are now resolved
    Thank you for quick and informed response.

    Rob
  5. [RESOLVED] Excel Automation Set a Fixed Row

    I am automating Excel from a VB6 program.
    I am writing the Column Headers into Row1
    I have managed to color them Grey (Would be nice if I could color the whole line, instead of the 10 Columns I...
  6. Replies
    1
    Views
    898

    Embed Image in the HTML

    Safe way to use a background image in an email

    I am attempting to create an 'email merge'.
    (There are not many Google hits on that expression)
    User would like the email to be HTML (not plain...
  7. Replies
    1
    Views
    480

    Re: Embed Image in an email

    Hi,

    I suspect that this is in the wrong thread ?

    Is there a way that it can be moved to -
    Other Languages
    XML, HTML, Javascript, Web and CSS

    Or can I just post it there, and Delete this ?
  8. Replies
    1
    Views
    480

    Embed Image in an email

    I HAVE 'MOVED' THIS TO THE 'OTHER LANGUAGES FORUM

    (Don't know how to Move properly, so i have posted it there, and added a 'fall back' request -'How to safely use background image from attachment'...
  9. Replies
    5
    Views
    66,803

    Re: Analog Clock Control

    It would be nice if it was a VB6 User Control (Nothing has to be registered).

    From my quick look, it -
    - does not appear to be UC
    - requires registering the DLL
    - Only for VB.NET

    Ah, such...
  10. Replies
    4
    Views
    532

    Re: Erase a file

    ididntdoit
    I tried creating 'your' IP thingy, but the site kept saying my signature was taken.
    I instead copied the source from this web page.
    Did you know that you can insert the HTML into an...
  11. Replies
    2
    Views
    484

    Re: Multiple values in a single MEMO field

    I was just updating my original post (see Edit on the end of post 1)


    I will check out your suggestion

    Any thoughts on how I can do the LT and GT with my number fields ?

    Thanks for...
  12. Replies
    2
    Views
    484

    Multiple values in a single MEMO field

    I have an existing application (DB has production data).
    I have a need to add more fields, and wonder if I could avoid the hassle of getting the DB's sent to me.(There are DBs for each state, with...
  13. Replies
    12
    Views
    901

    Re: want to print

    I think it was unkind of MS, not to have provided more examples(etc), to make printing easier in pure VB. I guess they were providing openings for 3rd party providers to 'fill the gap'.
    I have tried...
  14. Replies
    12
    Views
    901

    Re: want to print

    With my approach (and Hacks), no changes need to be done to the printing code.
    The generic code just 'reads' what is now on the form, and can print it.

    I have a form that is full of tightly...
  15. Replies
    12
    Views
    901

    Re: want to print

    Does your print out fit on a single page of paper ?
    If it does then -

    It is possible to print something like that with pure VB code (No OCXs, no DLLs, no distribution/Installation problems)
    ...
  16. Replies
    16
    Views
    1,203

    Re: Putting Remarks

    Ctrl G to show or hide it
    If you break your program (still running, but paused), you can show the contents of variables with
    ? NameOfVaraible
    and press enter

    There is a lot more that can be...
  17. Replies
    16
    Views
    1,203

    Re: Putting Remarks

    There is a command to Comment and UnComment a block of code.
    You highlight the multiple lines, and click Comment Block.
    If you right click the Toolbar and choose customise you can add two button to...
  18. Re: Same Form in Different Projects in A Group

    I have never used Project groups, as I like to keep things simple.

    Are you saying it all compiles into a single exe ?
    If so why not have it all in a single project ?

    Regarding your specific...
  19. Re: ocx stops my project when compiled

    Can you not capture the screen another (free) way ?
  20. Re: Same Form in Different Projects in A Group

    Why do you need to use Project group ?
  21. Replies
    2
    Views
    416

    Re: Help Shelling A Program...

    OOPs
  22. Replies
    5
    Views
    559

    Re: Data Environment issues

    I agree.
    I doubt that any experienced programmer, would be using any of the following -
    - Data Environment
    - Data Control
    - Bound Controls
  23. Replies
    24
    Views
    1,048

    Re: Project Won't Write an EXE

    That's a good thought.
    I have an approach that avoida that problem.
    I have been using it for so long, that I forgot that others could still have those problems.
    Every time I wish to run my...
  24. Replies
    24
    Views
    1,048

    Re: Project Won't Write an EXE

    In the IDE the last thing I see in the process is the message (Status)
    'Writing the exe'
    Do you get that message ?

    To help narrow down the problem -
    Can you go to your most recent copy...
  25. Re: [RESOLVED] How can I set command button focus to none?

    If you mean the real Control (not my txtTakeFocus), the programmer can add code to it's GotFocus event to set focus to txtTakeFocus
  26. Re: [RESOLVED] How can I set command button focus to none?

    I agree.
    It will depend on the programmer's needs, on different Forms.
    On some you may not wish any control getting focus.
    On others you could set the TabStop for txtTakeFocus to False, which...
  27. Re: [RESOLVED] How can I set command button focus to none?

    Ensure that the button's TabStop is False.
    Have a small textbox called txtTakeFocus
    Position it off screen minus 900 (either in the IDE or on form_Load)
    Then depending on your needs, you can...
  28. Replies
    44
    Views
    1,952

    Re: MSAcess AutoNumber

    If my memory serves me correctly, I recall that in 'Data Modelling', the Primary Key is not really meant to represent meaningful real data.
    There will be cases where it can be displayed and referred...
  29. Replies
    2
    Views
    593

    Re: Faster Activex Grid Control

    Try setting Redraw to false (or Visible to false), whilst drawing/loading the grid, and see if that helps.

    If it doesn't, do a search in this group for SGrid
    (Actually it is for SGrid 2), but do...
  30. Replies
    3
    Views
    1,755

    Re: [RESOLVED] can't declare chr(34) const

    If you have a similar need later -
    What I do is declare it as a string, and in the startup code
    (eg Main in a bas file if you use them, or in the Form_Load of the first form),
    just set the...
  31. Replies
    10
    Views
    987

    Re: Dynamic Checkboxes

    place a break on that line, and each time it gets to it, hold the mouse over skey.
    My guess is that in one of the 'reads' it is returning "" and you cannot CInt that.
    It is better to return the...
  32. Replies
    10
    Views
    987

    Re: Dynamic Checkboxes

    I nearly had an example for you, however I am having trouble providing events for each checkbox.
    That example was creating controls 'out of thin air'

    The other approach is to just add to an...
  33. Replies
    7
    Views
    774

    Re: Express, learning, which one?

    I noticed last night in one of Rod Stephens VBHelper newsletters, that it has a 12 month expiry.

    I don't intend to use VB.NET but I have a couple of times tried to work out how it could be Free ...
  34. Replies
    14
    Views
    2,149

    Re: Advanced Printing with Native VB Code

    PS
    It is 3:30 AM in Australia, so don't think I am ignoring any responses during the next 8 hours.
  35. Replies
    14
    Views
    2,149

    Re: Advanced Printing with Native VB Code

    Let me whet your appetite(s)
    This is a snapshot of HiRes running.
    The Form is on the left, showing a variety of controls.
    On the right is the print of that Form
    It has printed onto the preview...
  36. Replies
    14
    Views
    2,149

    Re: Advanced Printing with Native VB Code

    I found that other example -
    http://www.xtremevbtalk.com/showthread.php?t=217998
    It illustrates how the VB code can 'scan' (interpret) other controls on the form you wish to print.
    That example...
  37. Replies
    14
    Views
    2,149

    Re: Advanced Printing with Native VB Code

    I had tried in the past to get something going on this site for native VB printing, but no luck.
    Do all of the pages only require single page prints ? (They don't flow on to another page because a...
  38. Re: [RESOLVED] how to remove focus from other forms

    If you show Form2 vbModal, then no other form in your project can be interacted with, until you unload Form2

    Form2.Show vbModal
    'When Form2 is unloaded, code execution will return to here
    ...
  39. Re: Write Text to Desktop (to screen actually), and erase

    I did find that in my search, but I thought there was a more text related post.
    I am old (100/2 + 15), so I could be imagining things.

    I have just provided the solution into the thread you...
  40. Replies
    16
    Views
    1,560

    Re: Draw line on windows

    Hi,

    I am not sure this is the thread that I was trying to remember in my post -
    http://www.vbforums.com/showthread.php?p=2910573#post2910573

    But I will post a link to my text solution -...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width