Search:

Type: Posts; User: sparbag

Page 1 of 10 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: issue converting datetime to varchar breaks table indexes!

    Hello sapator,



    declare @mydate varchar(10)
    , @realdate datetime
    , @strDate varchar(8)
    , @wrongdate varchar

    set @realdate = getdate()
  2. Replies
    5
    Views
    2,061

    Re: max date in filed

    Hello Luca,

    You are going to have to create an index on the DATE1 field. As far as I can read, this can only be achieved using code rather than the utilities that Access provides.

    From other...
  3. Replies
    4
    Views
    901

    Re: Select Statement

    Hello Chapran,

    Please investigate CHARINDEX and PATINDEX as a possible solution to what appears to be an overly complex solution.

    search for the value in the string and its starting location in...
  4. Replies
    1
    Views
    2,006

    Re: Call Oracle Procedure from Excel VBA

    Hello John,

    From my perspective everything is good up to the point you are adding the parameters.
    I mostly work wit SQL Server when using access but most of the code is identical.
    The...
  5. Re: [Excel] VBA Entirerow.hidden not working correctly on others Computers

    Hello,

    Two things to note.

    1. the screen updating and other criteria to speed up your code will not work. The reason for this code not working is due to the calling sub losing focus, resetting...
  6. Thread: Quit MS Excel

    by sparbag
    Replies
    21
    Views
    9,952

    VS 2013 Re: Quit MS Excel

    Hello Pratik



    xlApp.Quit


    The Excel application Quit command 'should' close the application running in the background. It is good practice to test whether there are Excel application...
  7. Replies
    3
    Views
    964

    Re: vb.net 2010 cant display asp page

    Hello Richard,

    Line 18 is the beginning of the membership section of your config file. I do have a config file that includes the same section but mine appears as below



    <membership>
    ...
  8. Replies
    13
    Views
    1,549

    Re: Problem with logon form

    Hello Steve,

    I get the impression that you are completely confused by the entire process.

    Personally I haven't used OLEDB for asp.net since VS 2010 and that was in C#.
    Secondly I tend to write...
  9. VS 2013 Re: Try/Catch exception variable warning as unused when used

    Hello Cory,

    Please post the offending code and if possible, highlight to us what aspect of the try catch is returning the warning.

    Kind regards

    Steve
  10. Replies
    13
    Views
    1,549

    Re: Problem with logon form

    Hello Steve,

    Apologies for the delay.



    Dim strEmailValue As String = strEmail.Text
    Dim passwordValue As String = password.Text
    Dim MSAccess As String =...
  11. Replies
    13
    Views
    1,549

    Re: Problem with logon form

    My mistake it was.
    your code has overcome the issue by using the full hierarchy rather than the importing the hierarchy and shortening the directives in the using statement.



    Using conn As...
  12. Re: Search for a sting in text files Merge those text files

    Hello Xcaliber,

    Looking at my VBA scripts from Excel I suspect that when you set colFiles it is only picking a single file. That is all it can do.

    If you change your code to


    For Each...
  13. Replies
    13
    Views
    1,549

    Re: Problem with logon form

    Hello Steve,

    It is great to see you using the Configuration manager and the web.config file.

    Unfortunately you are missing a directive to access the functionality.

    Add


    Imports...
  14. Re: How to create a install exe file to deploy app to web server? (windows 2012)?

    As far as I am aware you would Build the web site {Shift + F6} then copy everything to the folder on the web server where the pages would be visible.
    That is how we have our web sites available to...
  15. Replies
    13
    Views
    1,549

    Re: Problem with logon form

    Hello Steve,

    I do not think the JavaScript is causing your issue.

    As I walked through your code it became very apparent that the two variables being sent to the database, in your query, are...
  16. Replies
    7
    Views
    1,036

    VS 2010 Re: Can this be done?

    Hello George,

    I think a function such as below, with tweaking, may suit your needs.
    written straight into the text box and not tested.



    Function fnConvertIntoNewString(ByVal variableOne As...
  17. Re: import table from ms access 2007 to sql server 2012 using vb.net

    Hello Frangine,




    a global variable as a filter for the file dialog


    Public Const FILTER_MDB As String = "Microsoft Access Databases|*.mdb"
  18. Re: How To: Pass user input from form -> To SQL Proc -> Report Viewer displays the Ro

    Hello,

    Below should do most of what you require. You may need a small amount of amendments as this was written in notepad. Did not compile well in Notepad so couldn't test.



    cmd.Connection =...
  19. Re: Mutually exclusive checkbox columns in datagridview

    Hello Tammy,

    From a logic perspective I would create four separate Boolean variables to hold the state of each checkbox. As the user selects a row the Booleans will have to be set to mimic the...
  20. Re: Mutually exclusive checkbox columns in datagridview

    Hello Tammy,

    I noticed that you had received no responses so decided to read why.

    Whenever I read the 'mutually exclusive' in the fields of a database I tend to focus on the database design.
    ...
  21. Replies
    2
    Views
    962

    Re: Help with query database (giving errors)

    Hello,

    From an SQL perspective I would believe that your error is being caused by the fact that all customer records are being identified with each of their child records in the [SpecInfo] table....
  22. Replies
    1
    Views
    487

    Re: Filtering OLAP Pivot Tables

    Hello DurrantBun,

    Please bear with my answer as I have had to read what you are trying to achieve several times but I am still assessing the terminology in regards to filters and row labels.
    ...
  23. Replies
    9
    Views
    1,404

    Re: Compile error on compiling array copy sub

    Hello ,

    From what I can gather, and this is an assumption based on the code, the type has never been initialised into any array. There has never been an index offered to hold a single record of...
  24. Replies
    1
    Views
    752

    Re: How to export a listbox content to Excel

    I have written .NET to transfer data from a list into Excel by way of holding the list as a list of(list of aclass). This was by far the most efficient method that I believed would complete the task....
  25. Replies
    2
    Views
    997

    Re: How to move the ith element in a list?

    Hello,

    I was in a similar situation some months ago whilst attempting to get an application, built by an absent other, to work within similar parameters


    Private Sub arrDeleteElement(Of...
  26. Replies
    3
    Views
    3,423

    Re: I got into a mess with Excel

    Hello,

    I can see that you have misinterpreted or misunderstood the object model of Excel. In your code you are referencing a non existent worksheet object 'ws'.


    private void...
  27. VS 2012 Re: Multiple connections before execute a command string!

    Hello Cachado,

    If you are going to use multiple connections I would also make use of the app.config file and add all of the connections into this file. This will centralise the connections and...
  28. VS 2012 Re: Multiple connections before execute a command string!

    Hello Chachado,

    It is quite simple. Firstly I would advise that you use well distinguishing variable names to uniquely identify your separate connections


    Dim cnSQL As New SQLConnection
    Dim...
  29. Thread: sql error

    by sparbag
    Replies
    6
    Views
    752

    Re: sql error

    SELECT * FROM Login WHERE Username='" & UsernameTextBox.Text & "' & AND Password='" & PasswordTextBox.Text & "'

    if the table where the username and password are stored.
    Even for a school project...
  30. Replies
    6
    Views
    971

    Re: Need help in excel VBA

    If the values down column B are all unique then the formula method will work. If the values down column B are not unique then the formula method will not work.

    The contents of C5 and C8 will be...
  31. Replies
    6
    Views
    971

    Re: Need help in excel VBA

    Hello,

    I am not certain that you would need VBa to get the solution, unless I have misunderstood the requirements
    in column D starting at row2 place the formula


    =IFERROR(VLOOKUP($A2, $B:$C,...
  32. Re: Need help with an unhandled COM Exception in a new VB.NET program

    Hello,

    The COM exception is due to an unrecognised object ("Excel.Sheet")
    Please try


    objExcel = CreateObject("Excel.Application")


    This will give you access to the Excel Application...
  33. Re: SQL Server 2014 has installed with Servername\MachineName instance

    Hello all,

    I have resolved the issue. I could not change the server\machine name setup in SQL Server 2014 and began looking laterally at the issue.
    It is not an unusual occurrence for the SQL...
  34. [RESOLVED] SQL Server 2014 has installed with Servername\MachineName instance

    Hello all,

    I believe I am responsible for this error as my other developer machine is OK.
    The install of 2014 sql server appears as :


    SQLSERVER\DEVELOPER


    I am using c# to connect to the...
  35. Replies
    2
    Views
    680

    Re: Searching folder in VBA

    Below is code that I have used succesfully in both Word and Excel VBA. This code has been available on the Internet for so long I forget.


    Sub ListFilesInFolder(SourceFolderName As String,...
  36. Replies
    1
    Views
    470

    Re: Reorganizing a loop

    Hello,

    Very little to change from my perspective.
    If statements are logic gates: if (condition) the use my goto
    Change the condition so that it meets required criteria and continues the code....
  37. Thread: Excel function

    by sparbag
    Replies
    2
    Views
    646

    Re: Excel function

    Hello Kris,

    I sincereley hope the solution is not as simple as the solution I would use if I was facing the same issue.


    =Countif(E5:AH5, "S")+Countif(E5:AH5, "A")



    Kind regards
  38. Replies
    3
    Views
    1,774

    MsOf10 Re: Sheets(i).Protect Question

    Hello very strange usernamed individual,

    There will be a time when you will have to start looking at the tools that arrive with Excel can be very useful to you. One such tool is being able to set...
  39. Re: Anyone Please Help! Syntax error in UPDATE statement error

    & " WHERE instead of & "WHERE"

    Give that a go and post back if there are any other issues.

    Kind regards

    Steve
  40. Re: Hide Sheets for read only but visible for password

    Hello Vargs,

    For point 1. I have been in this situation. I overcame this by creating the first sheet as a set of instructions in how the user could set macro's. Also supply a user guide explaining...
Results 1 to 40 of 378
Page 1 of 10 1 2 3 4



Click Here to Expand Forum to Full Width