Search:

Type: Posts; User: brucevde

Page 1 of 13 1 2 3 4

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

  1. Re: Stored Procedure: Was it successful

    ExecuteNonQuery is a function whose return value can be captured by

    Dim X As Long = cmd.ExecuteNonQuery

    As stated in MSDN, the return value is



    Based on that info there is no need to...
  2. Replies
    5
    Views
    1,286

    Re: Force Access Update Query to use an Index

    How many records does the table contain? How many bytes does each record use?

    A scan is quicker than indexes on tables whose number of records is considered small.

    Jet 4.0 storage mechanism...
  3. Replies
    2
    Views
    785

    VS 2008 Re: CMS for ASP.NET

    DotNetNuke - http://www.dotnetnuke.com - free
    Insite Creation - http://www.insitecreation.com/ - $80USD
  4. Replies
    6
    Views
    923

    VS 2008 Re: Who is using complex state management

    Cool. I am currently researching the same thing although my efforts are strictly for understanding the concepts. I don't have any projects requiring the use of Profiles.

    Based on the following...
  5. Replies
    2
    Views
    675

    Re: Disabling Highlight Expert??

    Highlighting is based on the value of the column. Its advantage is you can apply multiple Font formats in a single place. Unfortunately you can't turn it off or on conditionally.

    Anyways, to...
  6. Replies
    4
    Views
    5,090

    VS 2010 Re: Listview header template?

    Use the Layout template to define the headers.
  7. Replies
    5
    Views
    1,364

    Re: Count records in table

    Open the table in Access and hit the move last button. It will indicate you are on record # of total records.

    or

    Use the Count aggregate function - Select Count(*) From TableName
    Execute...
  8. Re: passing two parameter in Crystal report

    The double quotes are incorrectly used and in the wrong place.

    Try the following line instead


    CR.SelectionFormula = "{SPINF.GRNO}=" & Me.txtGRNo.Text & " And {SPINF.CMBCAT}=" & Me.cmbCat.Text
  9. Replies
    5
    Views
    929

    VS 2010 Re: Gridview will only select 1st record

    or this

    http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.commandfield%28v=VS.80%29.aspx

    All these methods basically generate/execute the same code at run time.
  10. Replies
    5
    Views
    929

    VS 2010 Re: Gridview will only select 1st record

    Either specify the CommandName argument of the ButtonField to indicate which action you want the GridView to process or handle the processing yourself in the GridView_RowCommand event.
  11. Replies
    4
    Views
    776

    Re: select record from 100 to 300

    See the Row_Number function in Books Online.

    http://msdn.microsoft.com/en-us/library/ms186734(v=SQL.100).aspx



    The following example returns rows with numbers 50 to 60 inclusive in the order...
  12. Replies
    22
    Views
    4,114

    VS 2005 Re: put div into another

    In order to participate in ViewState, dynamic controls need to exist early on in the Page Life Cycle.

    Data in ViewState is applied to all controls during the Load stage. Basically, dynamic...
  13. Replies
    32
    Views
    11,698

    Re: can't resize VB controls manually

    I don't know if this applies to you but sometimes strange things occur in the VB IDE when its menus have been customized.

    If you have done any menu customizations try resetting them
    View menu...
  14. VS 2010 Re: Centering my page with min and max widths

    For "minimum margins", set the margin styles of the body tag.


    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html...
  15. Replies
    21
    Views
    3,032

    Re: VB 6 Data Control Class OSX DLL help.

    VB6 and all its components are pre-installed on XP.

    Most likely the computers do not have the Jet Engine installed. It use to be part of the MDAC installation but was dropped from version 2.7,...
  16. Replies
    3
    Views
    2,446

    Re: Dropping/Creating indexes

    There is no black and white answer. There are several factors in how you should approach this problem/situation for the most efficient process.

    How do you import the data? Bulk Copy? Bulk Insert?...
  17. Replies
    5
    Views
    1,222

    VS 2008 Re: OnKeyPress Not called + JS

    maxLength is a property of the Text Object. Browsers are assuming you want to access that property not call a function.

    Since Javascript is case sensitive, changing the function name to MaxLength...
  18. Re: Retrieve old record and susequently delete them

    The DateDiff function returns the difference upto the requested datepart portion only. Other datepart values are not considered.

    For example in the following cases the return values will be 1...
  19. Replies
    5
    Views
    9,268

    Re: Number of digits in Integer

    TotalDigits = Len(Cstr(Integer variable))
  20. Replies
    6
    Views
    803

    Re: Trouble with Table Design Choices

    First in your world, What is a Permission? What is a Group? What do they define?

    Are Groups simply a convenient place to hold Users?

    Are Permissions used to define low level activities such as...
  21. Replies
    7
    Views
    943

    Re: sum and group by

    Check the help file. There are additional clauses you can use with the Group By statement, which are new in SQL Server 2008.

    In this case the Rollup or Grouping Sets clauses seem to be what you...
  22. Replies
    3
    Views
    713

    Re: Object within a Picturebox

    Specify the Container where you want to add the new control

    Set lne = Me.Controls.Add("VB.Line", "Line", Picture1)
  23. Re: Show data from a certain row based on the max of a field

    How is the report grouped? Why even group the data, nothing in the posted sample suggests a grouping.
  24. Re: update and save content of flexgrid for invoice

    It appears from your original post that a unique row is identified by the FactorId and Good_Id columns.

    If this is true, Good_Id should be part of the Update statement's Where clause not it's Set...
  25. Replies
    8
    Views
    1,536

    Re: search datetime field

    To find dates using Like, without using Convert, make sure the criteria is based on the format mon dd yyyy hh:mi:ss:mmm which is the default (and equivalent to Convert date style 9 or 109)
    ...
  26. Replies
    2
    Views
    514

    Re: Exteacting records on date criteria

    Both the FromDate and ToDate would need to be used in the criteria.

    To find employees on leave within a given date range

    Where FromDate <= EndofDateRange And ToDate >= StartofDateRange
  27. Re: how do i print flexgrid with picture in cell

    You can't.

    The Data Report does not support printing images on a per record basis because the rptImage control does not support data binding.
  28. Replies
    3
    Views
    618

    Re: convert my sql to sql server

    In addition to abhijit's response

    From and To are reserved/keywords and shouldn't be used as column names. If you must use those names surround them within [] (you will need to do that in every...
  29. Re: How to display this problem in MSHFlexgrid?

    Research the SQL Join clauses.

    In this case the SQL would be

    Select STR_ITEMNO,ITEM_NAME,STR_QTY
    From STRUCTURE Inner Join ITEM On Structure.str_ItemNo = Item.Item_No
  30. Re: CSS questions for check boxes and labels

    The idea is the same whether your code contains the ASP.NET CheckBox and a Label, the ASP.Checkbox only or just HTML Input and Span elements.

    As in post #2 - wrap controls/elements within Span...
  31. Re: CSS questions for check boxes and labels

    As far as I know. Inline-block is partially supported by IE6/IE7

    In those versions, inline-block can be used without problems on inline elements such as span but not on block elements such as div...
  32. Re: CSS questions for check boxes and labels

    Is there a reason you are using a Label control for each Checkbox control?

    By setting the Text property of the Checkbox control, ASP.Net generates the Label for you. An added benefit is the user...
  33. Replies
    11
    Views
    2,167

    Re: Runtime error 398

    In standard licensing practices, being able to use CreateObject would require a license key.

    Regardless, the only way I know of to get around this would be to capture the error and process...
  34. Replies
    11
    Views
    2,167

    Re: Runtime error 398

    All UserControls have a UI - Click, Show, Resize events are part of a UI.


    Exactly as it should. The Ambient property is only available after the UserControl is sited on a Form.

    What code are...
  35. Replies
    11
    Views
    2,167

    Re: Runtime error 398

    That is not 100% true. It is possible to instantiate a control without placing it on a Form. It all depends on how the control was written.
    Yes. Just like the Me keyword within the Form's code...
  36. Replies
    18
    Views
    4,018

    Re: ASP.NET Form Design

    A book you might be interested in is "CSS: The missing manual" (OReilly). Having no HTML/CSS experience whatsoever, the book got me up to speed quickly when I first started using ASP.NET.
    ...
  37. Replies
    11
    Views
    2,167

    Re: Runtime error 398

    No. Most likely you are referencing the UserControl in one of its own initialization events or it has properties that can only exist when sited on a Form.

    Post some code.
  38. Re: Acess SQl statement using IsNull and Sum

    The IsNull function simply returns True/False

    Use the NZ function

    Nz (&#171;expr&#187;, &#171;valueifnull&#187;)

    SUM(NZ(SUPPLY_TRANSACTIONS.QuantityOfTransaction,0))
  39. Replies
    18
    Views
    4,435

    VS 2005 Re: gridview top position

    Set the vertical alignment attribute of the TD tag. By default it is middle.

    <td colspan="8" rowspan="4" valign="top"

    The equivalent CSS style is

    vertical-align:top
  40. Replies
    4
    Views
    2,526

    Re: Access to VB datetimepicker

    FCNDateDateTimePicker.Value = ds.Tables("FCN").Rows(inc).Item(1)
Results 1 to 40 of 499
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width