Search:

Type: Posts; User: Gruff

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds.

  1. Thread: GridView data

    by Gruff
    Replies
    2
    Views
    4,613

    Re: GridView data

    Jumping in here JM.

    In your Select query use a calculation. I believe mySQL has a number of date & time functions.
    The following will return a new column called difference that contains the...
  2. Re: ideas about access Database structure

    Just my opinion, but I would use one main table for storing the main user data with several fields that denote parent child relationships. Perhaps a field that holds the user id of the parent.
    ...
  3. Replies
    14
    Views
    2,037

    Re: Is Moores Law dead

    How's that old engineering joke go...

    Optimist: That glass is half full.
    Pessimist: That glass is half empty.
    Engineer: That glass is twice as big as it needs to be.
  4. Replies
    12
    Views
    1,911

    VS 2012 Re: Set GridView CellBGColor based on Column Value

    Yep,
    Pretty much what I was doing in Post#3 (Minus the dbnull check.)
  5. Re: Copy selected data from one List box to another

    You could very well be right, though the last time I used it was version 2000.
    I don't have that version on hand so....
    In any case I think access has always been the odd duck of the Office VBA...
  6. Re: Copy selected data from one List box to another

    Well that was a couple of painful hours I will not ever get back!

    Access VBA has changed a lot since I played around with it years ago. I had to unlearn a buttload of VBA code.
    First there are...
  7. Re: Copy selected data from one List box to another

    What version of Access are you using? I only have Office Pro 2010 to test with.
    Is Office installed as 64 bit or as 32 bit.
    (Typically it defaults to 32 bit installation even when installed on a...
  8. Replies
    12
    Views
    1,911

    VS 2012 Re: Set GridView CellBGColor based on Column Value

    You are mis-using the try-catch statement.
    Never use one if you do not have code to put in the catch segment.
    The main reason being you can hide other errors you might need to know about.
    This can...
  9. Re: Copy selected data from one List box to another

    Hope you do not mind westconn1. :)

    First I would ask how you are populating List63.
    Is it being driven from a field in the database, or are you filling it from code?

    If it is driven from a...
  10. Replies
    9
    Views
    1,322

    VS 2013 Re: ComboBox fill issue

    Kind of an import part to omit when trying to trouble shoot. ;)
  11. Re: U.S.Post Office a modern sleek efficient service?

    I come from a family with three generations of postal workers. My old man put in 30 years. He'd roll over in his grave if he saw what it has become.
  12. Replies
    9
    Views
    1,322

    VS 2013 Re: ComboBox fill issue

    It would be nice if you told us what you expect your code to do and what is doing when you run it.
  13. Replies
    12
    Views
    1,911

    VS 2012 Re: Set GridView CellBGColor based on Column Value

    Yes, The cell formatting event fires for every cell one at a time.
    You do not write a loop inside it.


    Public Class Form1
    Private Sub DataGridView1_CellFormatting(sender As Object, e As...
  14. Re: merge file with other info like project/workspace file

    Wasn't there a Microsoft product that did this sort of thing?
    I'm thinking 1990 something.
  15. VS 2010 Re: [RESOLVED] VS 2008 Ex to VS 2010 Pro Upgrade Issue

    ??? I don't think I've ever tried to make a class that inherits from a form.
    Usually I create all my forms and dialogs at design-time in the form graphics deisnger and create instances of them at...
  16. U.S.Post Office a modern sleek efficient service?

    Lately I have had dealings with the USPO and I cannot believe how backward, in-efficient and non-customer oriented they are. Oh! Did I leave out inflexible?

    There was a time when they were the...
  17. Replies
    14
    Views
    2,037

    Re: Is Moores Law dead

    Never cared for moore himself either. *Grin*

    I've always worked with higher end hardware or people who use higher end hardware.
    Bottom necks anywhere can limit what passes for perceived speed,...
  18. VS 2010 Re: VS 2008 Ex to VS 2010 Pro Upgrade Issue

    Normally warnings do not stop you from compiling or running,
    but they will keep popping up until you resolve them.

    Open your project. Select Quick Find from your edit menu.
    In the find dialog...
  19. VS 2010 Re: VS 2008 Ex to VS 2010 Pro Upgrade Issue

    Are they errors or warnings? There is a difference.
    What does it actually say? Pretty hard for us to guess. :)
  20. Re: how to group dates from ms access database as week of month using excel vba

    Weeks do not fit neatly into months. You get days left over.
    Also What do you consider the first day of a week? Sunday? Monday? ...
    By your definition does week one start Jan 1 regardless of...
  21. Replies
    22
    Views
    2,275

    Re: How to save indexed controls?

    Offhand I would say your Patient_ID is an integer value field.
    Your trying to push text into that field.

    Try converting your text to a number and see if that works.
    RS!patient_id =...
  22. Re: how to add progress indicator while performing the sql statement

    As Tyson says there is no good way to determine the count or how long a query will take due to server load or the content of the database. Most people use a marquee progress bar to show something is...
  23. Replies
    14
    Views
    4,307

    Re: Recordset field syntax in ADO

    I do not know if it makes a difference but you are not taking advantage of your table name aliasing.
    The only time you need a table name prefix is to clear up ambiguity if there is duplicate field...
  24. Replies
    11
    Views
    2,901

    VS 2013 Re: Searching in text file

    mcsmba1,

    All you have done in VB.NET 2013 so far is read a text file. That is easy.

    As I said before VB.NET does not have any built in tools to read an Excel workbook file.

    As far as I know...
  25. Thread: Post Race!

    by Gruff
    Replies
    68,909
    Views
    18,140,451

    Re: Post Race!

    Nice. Good to see you give it the old college try.
  26. Replies
    11
    Views
    2,901

    VS 2013 Re: Searching in text file

    The following is rough, but shows the Excel solution thought process.

    It assumes Column A contains the Excel number data and that the first row is 1 and that row data is in column B.


    ...
  27. Thread: Post Race!

    by Gruff
    Replies
    68,909
    Views
    18,140,451

    Re: Post Race!

    Frats? I didn't know they were a college town.

    ---

    I always got a kick out of George Carlin and his observations on humanity.

    "When two people are in an elevator and one of them rafts......
  28. Re: Why would you want to create a user control that's transparent?

    Realized I didn't map the listboxeditorcore listbox control events to the usercontrol.

    Updated the zip attachment in the previous post to include listbox specific events.
  29. Thread: Post Race!

    by Gruff
    Replies
    68,909
    Views
    18,140,451

    Re: Post Race!

    Probably there is a certain air about the place.
  30. Replies
    11
    Views
    2,901

    VS 2013 Re: Searching in text file

    Right. You can do it much simpler in Excel VBA than in VB 2013.
    You would write your program as a global excel program that works on any excel workbook you load. You would use Excels VBA forms to...
  31. Re: Why would you want to create a user control that's transparent?

    Finally found some time and re-thought the entire listboxeditor control.

    I basically re-designed the control from being a single derived control to a UserControl that is constructed from.
    1)...
  32. Thread: Post Race!

    by Gruff
    Replies
    68,909
    Views
    18,140,451

    Re: Post Race!

    So sad.

    Last time I called someone Toots HR wrote me up.
  33. Replies
    9
    Views
    3,291

    Re: Embed MS Office to VB Form without OLE

    As you are being very very non-specific I do not think I can help you.
    From what you have said I do not even see where MS word comes into the solution.
  34. Replies
    30
    Views
    11,362

    Re: How do I create a TypeLib for UDTs in VB6?

    Here is a small proof of concept for writing UDTs from a class.
    The file IO would be better if encapsulated in the custom collection class.
    It is just a silly test so go easy on the code comments....
  35. Replies
    30
    Views
    11,362

    Re: How do I create a TypeLib for UDTs in VB6?

    I believe my app which I cannot locate converted UDT code into get/let property lists not public variables.
    This saved one heck of a lot of typing and made the conversion a lot less painful.

    I...
  36. Replies
    9
    Views
    3,291

    Re: Embed MS Office to VB Form without OLE

    I have no clue as to what your last paragraph means.

    What kind of automatic system message? What is the source?
    Are we talking email HTML format or something else?
    If this is email what is the...
  37. Replies
    11
    Views
    2,901

    VS 2013 Re: Searching in text file

    personally i would write the entire thing in Excel VBA.
    You have all the tools to do the job in VBA and it would be a lot easier than trying to automate Excel from VB.NET 2013.

    Create a form in...
  38. Replies
    30
    Views
    11,362

    Re: How do I create a TypeLib for UDTs in VB6?

    Somewhere in the attic is a dusty box with a floppy that has a small program written in VB6.
    It converts UDT definitions to class properties and loads them onto the windows clipboard for pasting.
    ...
  39. Replies
    9
    Views
    3,291

    Re: Embed MS Office to VB Form without OLE

    If your trying to make a help interface for a program I would suggest converting the word document into a rich text document and using the RichTextBox control to display it.

    Another option is to...
  40. Thread: Post Race!

    by Gruff
    Replies
    68,909
    Views
    18,140,451

    Re: Post Race!

    "My favorite part of 'gator? That would be da snout."
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width