Search:

Type: Posts; User: Smartacus

Page 1 of 5 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: SQL 2008 - Query MAX on integer column and date specific

    I had a suggestion to use the following but I am getting the same results. It is returning three records, two with the same date.


    WITH X AS
    (
    SELECT ednum
    , BackgroundID AS BID...
  2. Replies
    3
    Views
    681

    Re: SELECT non NULL records, then sort them

    SELECT * FROM TestTable WHERE XX IS NOT NULL ORDER BY XX
  3. SQL 2008 - Query MAX on integer column and date specific

    I am working on a report query where I need only the highest most recent row using a date range, as well as patientid, and Type_Name for filters . The int column 'ednum' can have many rows on any...
  4. VS 2013 Re: How to Display a SQQL Database field on a Message BOX

    What do you get when you query "SELECT * FROM UPC_Table WHERE UPCNumber=" and number? What type is UPCNumber?
  5. VS 2013 Re: How to Display a SQQL Database field on a Message BOX

    Danny, What are you seeing in your debug.print? Any Errors? If not try changing TextBox1.Text to TextBox1.Value as well as TextBox2.Text to TextBox2.Value
  6. VS 2012 Image Map - VB.net Space Availability Application

    I am in design consideration to create an application where the user in setup can drag objects on a form that would represent the floor layout of a building. Each of these objects (rooms) would be...
  7. Re: [UPDATE] Custom TabControl incl Designer, Tab-specific ContextMenus and Tab-Dragg

    How do I get the "X" icon on the tab for closing? I saw a graphic sample of your control and was immediately interested. I am using another design and not pleased with appearance.
  8. VS 2012 Tabpage form resizing - has this been simplified?

    I have a classic mdi main form in Explorer style with a split container. Panel ! has a treeview and Panel 2 has a tab control. Clicking on a treeview node opens a winform in a tabpage.

    I can load...
  9. VS 2010 Re: [RESOLVED] Help with Data Grid data to include calulated age

    sorry that was just a stupid question asked before finishing my coffee.
  10. VS 2010 [RESOLVED] Help with Data Grid data to include calulated age

    I'm needing some help here getting the information I need for the column rows of my data grid. All are read only.

    VS 2012 & MySQL DB

    This works but I need to calculate the age from DOB for a...
  11. Replies
    2
    Views
    7,498

    Re: Kaspersky 2014 Theme

    love the checkbox. When i add it to a form though its black. Any idea where I have gone wrong (VB 2012)
  12. VS 2012 Re: VB 2012 - Position of toolstrip textbox to load dialog form underneath like dropd

    no master, it is all of you in this forum that I seek my knowledge from. Thanks for the help Gruff!
  13. Replies
    7
    Views
    2,548

    VS 2012 Re: Toolstrip - Center Text Box

    Thats actually what I had already done with a label on each side. I am working with the width on resize now.

    tsLeftSpacer=Space(lx) etc.
    tsRightSpacer=Space(rx) etc.
  14. Replies
    7
    Views
    2,548

    VS 2012 Toolstrip - Center Text Box

    I need to center a textbox on a toolstrip at runtime since the toolstrip properties for it is not there


    tbFilter.? = (ToolStrip2.Width / 2) - (tbFilter.Width / 2)

    Anyone having trouble with...
  15. VS 2012 Re: Cannot see anything in my Form1 but can see the code

    would it be that your background is set to black and likely your transparent color is also set to black?
  16. Re: VB.NET 2010 - check for how many numbers at end of string

    I did an RS232 project a few years ago and it may help to show the entire return as there may be some additional indicators or patterns that would better identify the value your looking to count. In...
  17. VS 2012 Re: Tabpage - Add or insert tabpage with order determined

    I have checked my tags and they are numbered starting at 0, I removed the first default tab so the menu click now creates the first tab index. Still not loading in order I want. HELP!!
  18. VS 2012 Re: VB 2012 - Position of toolstrip textbox to load dialog form underneath like dropd

    I would normally do that but this is a clientid lookup form disguised as a dropdown that i will re-use in other forms. It will maybe have three rows at most in a two column datagrid (320,120). It...
  19. VS 2012 Re: VB 2012 - Position of toolstrip textbox to load dialog form underneath like dropd

    oooh bad spelling. my keyboard kept freezing and caused omissions.

    That did it! I added a few pixels to drop it down a bit and its just what I wanted. Appears I was trying to take the long way...
  20. VS 2012 VB 2012 - Position of toolstrip textbox to load dialog form underneath like dropdown

    Can you get a position text box that is in a toolstrip and load a small for below it to act as a drop downbox?



    Private _owningControl As Control

    Public Sub New()

    ' This call is...
  21. Replies
    23
    Views
    2,836

    Re: is it even possible?

    I have no problem spending some time for him to understand the logic but not doing his homework. I have my own work to pay for home.
  22. Re: Which is the best way of setting Label printing parameters?

    I did a project a few years ago on vb.2005 with Intermec's. I found it more efficient to design the label format in the IPL (Intermec Programming Language) and store the label template in the flash...
  23. Re: Which is the best way of setting Label printing parameters?

    What types of labels are you planning? Production type labels w/ barcodes?
  24. Re: Which is the best way of setting Label printing parameters?

    I can't read let me look
  25. Re: Which is the best way of setting Label printing parameters?

    What is the model of your label printer? It may be easier to send a format to the printers memory then print. I have experienced this with Intermec and may be faster also with Zebra
  26. Re: Button Click works for everything except this:

    Did you copy the button event from other button code and rename it with changes needed? Go to the button events click and make sure its associated.
  27. VS 2012 Re: Tabpage - Add or insert tabpage with order determined

    I am assuming that this is where I am getting it wrong. But I have switched things around and still not inserting before other tabs if tag value is less than the ones on right.



    'Insert this...
  28. Replies
    6
    Views
    1,042

    Re: Concatenation's, is this possible?

    Would you please mark this as resolved?
  29. Replies
    23
    Views
    2,836

    Re: is it even possible?

    I just read Gruff's post. I fully agree.

    You mentioned you now have 20 forms to track the reserved PCs, do not think this way when programming, you will not need a dedicated form for each. That...
  30. Replies
    23
    Views
    2,836

    Re: is it even possible?

    My question for the OP is when would the database know when the 1 computer that was "Reserved" be back into service?

    I would have your Asset Table with the necessary columns for PC id numbers,...
  31. Replies
    5
    Views
    1,423

    VS 2010 Re: DataBound Masked Textbox

    Try this in a plain text box. It stores value as 123456789 but loads it back in with the SSN mask. Check out the SSA website for specs on SSN if you are interested in some validation of the SSN for...
  32. VS 2012 Re: Tabpage - Add or insert tabpage with order determined

    I do not have something right here.

    I am getting the behavior I expected with create a tabpage and adding form to it, and even my function to check for existing tabpage is working and not adding...
  33. VS 2012 Re: Tabpage - Add or insert tabpage with order determined

    Function(tp) CInt(tp.Tag) > CInt(tabToInsert.Tag)

    Do I need to enter the tag property as a string "1"?
  34. VS 2012 Tabpage - Add or insert tabpage with order determined

    I have a main page (VB.Net 2012 4.0) which I have a treeview on the left that opens forms into a tab control page on the right. This all works fine except I would like to be able to determine the tab...
  35. Re: Help with T-SQL Corelated Query

    do I need a (select CompName from tblEmployers) in my FROM?
  36. Re: Help with T-SQL Corelated Query

    yes tblemployers exists
  37. [RESOLVED] Help with T-SQL Corelated Query

    This (I think) used to work before a DB redesign and the tables were recreated via script. I thought it may be a clustered index missing but I do not see it. I need some help in my overlook.

    The...
  38. MsOf07 Re: [Access 2007] VBA procedure for parsing XML database connection

    well that is what I ended up doing. I created a class for the xml import values then document60 and then to a collection to build the string. Just finishing up the last select case and my strings are...
  39. MsOf07 Re: [Access 2007] VBA procedure for parsing XML database connection

    Well I have a working model going at least parsing part of what I want in the middle section. Thanks to MarkT for putting stuff out there for us to plagiarize.

    I am going to need to read the file...
  40. Re: Unrecognized Type but intellisense has the type listed

    have you double checked your references? Does Intellisence popup after typing "Excel." ?


    BTW I like your footer. I like having only a Lab and Siamese crowding the hall in the morning to consider...
Results 1 to 40 of 196
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width