dcsimg

Search:

Type: Posts; User: stephena

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    1,047

    MsOf13 Re: [EXCEL VBA] Break links

    When you right click and edit the hyperlink in the new spreadsheet the Cell reference changes to A1 and you get the error previsouly mentioned.

    I wondered if there was a way to setup the...
  2. Replies
    7
    Views
    1,047

    MsOf13 [EXCEL VBA] Break links

    Hi

    I have a bit of VBA that copies a sheet from the active spreadsheet to a new spreadsheet and saves it locally for the user - this all works fine!

    However when you open the new spreadsheet...
  3. VS 2015 [RESOLVED] Opening file in specific application

    Hi,

    I am building an application to allow me to search select tracks from a specific folder and play them using a specific application.



    Private Sub...
  4. Replies
    1
    Views
    814

    Resizing OLEObject in word

    Hi,

    I use the following to paste a visio docuemt into an MS Word page:



    objselection.InlineShapes.AddOLEObject _
    filename:=visiofilename, _
    LinkToFile:=False, _
    DisplayAsIcon:=False
  5. VBA Copying from Excel to Word (minus the table)

    Hi,

    I have a range in Excel i wish to copy to the clipboard it has formatting in terms of Font Size, Color etc and i would ideally like to keep that however when the user pastes into Word using...
  6. Re: VBA Delete all Visio sheets except Active Sheet

    I altered the above code after taking some advise onboard about looping through the pages and came up with this:



    Set objdoc = AppVisio.Documents.Open(seedsdd)
    For i = 1 To...
  7. Re: VBA Delete all Visio sheets except Active Sheet

    And here is my current code as promised:



    Set objdoc = AppVisio.Documents.Open(seedsdd)
    For Each vsoPage In objdoc.Pages
    If Not (vsoPage = bh) Then
    vsoPage.Delete (True)
    End If
    Next
  8. VBA Delete all Visio sheets except Active Sheet

    Hi All,

    I am having trouble deleting all the pages (not shapes) in my Visio document except the active one, there are 6 in total and it seems to ignore a couple of sheets for reasons unbeknown to...
  9. Replies
    7
    Views
    2,678

    Re: VBA to open file from HTTPS location

    I believe my issue is down to the fact the file location is behind our company Single Sign On authentication. But i cannot find a way to bypass this currently
  10. Replies
    7
    Views
    2,678

    Re: VBA to open file from HTTPS location

    Tried this...


    Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As...
  11. Replies
    7
    Views
    2,678

    Re: VBA to open file from HTTPS location

    Thanks, at this stage I am not attempting to write anything to the document just download it from the HTTPS location to the local machine.
  12. Replies
    7
    Views
    2,678

    VBA to open file from HTTPS location

    I "borrowed" this from a post online which appears to address the issue i have opening files from our internal https site:



    Private Sub CommandButton21_Click()
    Dim FileNum As Long
    Dim...
  13. Re: Excel VBA to Open Visio template Search and replace string

    As is often the case through persistence I managed to answer my own question eventually so for anyone ese that stumbles across this post in the future with the same problem here is how i did it...
    ...
  14. Excel VBA to Open Visio template Search and replace string

    Hi I want to open a Visio document template from within my Excel spreadsheet and search and replace set values with values from my Excel spreadsheet.

    For Example Cell M33 contains the Customer...
  15. VS 2005 Re: Lightbox - If Image is not visible set "data-lightbox="

    58 views 0 replies means i probably didn't explain this very well : )

    Matters not a good nights sleep and several coffees and i cracked it in all of 5 minutes tonight.


    ...
  16. VS 2005 [RESOLVED] Lightbox - If Image is not visible set "data-lightbox="

    Hi All,

    It's been a while and therefore I am a little rusty.... :eek2:

    I'm using lightbox (http://lokeshdhakar.com/projects/lightbox2/) to display a 6 images in a ASP.NET repeater looks great...
  17. Re: MySQL - Return 4 Random and 1 specific record

    Managed to resolve this after several hours of head scratching so for the benefit of anyone trying the same thing here is the amended query:



    SELECT CONCAT( nok1fname, ' ', nok1sname ) AS NOK...
  18. MySQL - Return 4 Random and 1 specific record

    SELECT CONCAT( nok1fname, ' ', nok1sname ) AS NOK
    FROM customers
    WHERE id =12127
    UNION ALL (

    SELECT CONCAT( nok1fname, ' ', nok1sname ) AS NOK
    FROM customers
    WHERE id !=12127
    )
    ORDER BY...
  19. Re: Access UPDATE Error 3464 Data type mismatch in criteria expression

    Working thanks to Technognome's suggestion

    Thanks all for advice.
  20. Re: Access UPDATE Error 3464 Data type mismatch in criteria expression

    Thanks Steve,

    Tried that but same error here is the revised code:



    MYSQL = "UPDATE CUSTOMERPO_CHECKLIST SET AcknowEmailDate='#" & Now & "#', AcknowEmail=True, AcknowEmail_CB='" &...
  21. [RESOLVED] Access UPDATE Error 3464 Data type mismatch in criteria expression

    MYSQL = "UPDATE CUSTOMERPO_CHECKLIST SET DelivConfEmailDate='" & Now & "', DelivConfEmail=True, DelivConfEmail_CB='" & Environ("username") & "' WHERE ORDERID='" & ORDERID & "';"
    DoCmd.RunSQL MYSQL
    ...
  22. MsOf10 Re: Access VBA sql Update - Too few parameters. Expected 1

    In case you wanted more...



    newstklvl = Form.Label44.Caption + Form.Text53.Value
    Dim dbs As Database
    Dim qdf As QueryDef
    Dim strSQL As String
    Set dbs = CurrentDb()
    dbs.Execute "UPDATE...
  23. MsOf10 Access VBA sql Update - Too few parameters. Expected 1

    Hi,

    Here is my update SQL:

    "UPDATE PRODUCT SET ORDER_STATUS='" & Form.Combo37.Value & "', PRODUCT_STOCK_QTY='" & newstklvl & "' WHERE ID='" & Form.Text51.Value & "';"

    Which comes out when I...
  24. Replies
    7
    Views
    1,081

    VS 2005 Re: Databinding Repeater controls

    Thanks Gep13 i spotted that mistake and set i=1 when i declared i.

    My textbox control looks correct when i preview and view source:


    <input...
  25. Replies
    7
    Views
    1,081

    VS 2005 Re: Databinding Repeater controls

    Ok im going to narrow this down to the bit that us truly causing the issue in the hope i explain myself better.

    Here is the code i currently have in the repeater:



    Protected Sub...
  26. Replies
    7
    Views
    1,081

    VS 2005 Re: Databinding Repeater controls

    I'll try my best...

    Table containing multiple questions (could be 1 could be 30) as below:

    ID Question
    1 Is this even a question?

    ASP.Net form listing each of the above 1-30...
  27. Replies
    7
    Views
    1,081

    VS 2005 Databinding Repeater controls

    Its been a while but i am well and truly stuck and in need of some assistance... :wave:

    I have a SQL table containing a list of questions which admin users can add new questions too as and when...
  28. Re: Generated XML not closing nodes as required

    The worry being I have been told in no uncertain terms the XML output must be exact as its for a configuration file on a telephone handset... I guess I will send them what I have and hope it is good...
  29. Generated XML not closing nodes as required

    I have built a form that generates XML in a very strict and particular format and inserts values from the form... The issue I am having is that the generated XML creates the nodes like this:

    <call...
  30. VS 2005 Upload script not working on server but fine locally

    If FileUpload1.HasFile Then
    Dim filepath As String = FileUpload1.PostedFile.FileName
    Dim pat As String = "\\(?:.+)\\(.+)\.(.+)"
    Dim r As Regex = New Regex(pat)...
  31. VS 2005 Re: Programatically check if Validation has failed

    Thanks Gary,

    I have added the following code to my 'Add button' event where the validation is checked:



    If Page.IsValid = False Then
    Label1.text="One or more fields...
  32. VS 2005 Programatically check if Validation has failed

    I have a web form with about 20 fields all validated, rather than use the validation summary control.

    I would like a one line alert at the foot of the form that says something along the lines of...
  33. Replies
    4
    Views
    1,892

    VS 2010 Loop through controls and change value

    I want to reset programatically the values of all the labes on my form for example label1.text=1, label2.text=2 etc etc (there are 90 in total)

    I came up with:


    Dim i As Integer = 0
    ...
  34. VS 2008 Re: Am i going mad? Procedure or function has too many arguments

    I am going mad, i had...


    CustomerManagementConnection.InsertParameters.Add("wip_id", wip_id)


    ...in my code behind so effectivly i had two insert parameters with the same name, i wish the...
  35. VS 2008 [RESOLVED] Am i going mad? Procedure or function has too many arguments

    Stored Procedure


    ALTER PROCEDURE [dbo].[cm_customermanagement_i]
    -- Add the parameters for the stored procedure here
    @wip_id int,
    @company_name varchar(500),
    @street varchar(500), ...
  36. Excel VBA cell range validation set max length

    With Range("B9:B1008").Validation
    .Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertInformation, Minimum:="1", Maximum:="10"
    .ErrorTitle = "Error"
    .ErrorMessage = "You must enter a number...
  37. Replies
    0
    Views
    339

    VS 2005 Get Max Len of each column in dataset

    I have the follwoin to count the number of completed rows in an excel spreadsheet:


    Dim objDataAdapter3 As New OleDbDataAdapter()
    objDataAdapter3.SelectCommand = cmdExcel3
    ...
  38. Replies
    1
    Views
    343

    MsOf03 Sales form in Email Template

    I have a requiremnet for a simple form to be sent out to customers to ensure they always provide the correct information.

    If its an 'Install' one set of criteria will be displayed and if its a...
  39. Replies
    13
    Views
    1,659

    VS 2005 Passing Textbox Values to SQL (not Null)

    SELECT one, two, three, four FROM tblFixedLine_onenet_callLog WHERE (one LIKE '%' + ISNULL(@one,'') + '%') AND (two LIKE '%' + ISNULL(@two, '') + '%') AND (three LIKE '%' + ISNULL(@three, '') + '%')...
  40. VS 2005 Re: Setting Parameter Value and Executing Stored Procedure

    Dim ID As Integer
    ID = DataGridView1.CurrentRow.Cells(0).Value
    TextBox1.Text = ID
    Dim connectionString As String = "Data Source=AUKPIDAW.DC-DUBLIN.DE;Initial...
Results 1 to 40 of 245
Page 1 of 7 1 2 3 4



Featured


Click Here to Expand Forum to Full Width