Search results

  1. S

    Opening Website - looking for error

    Hello, This is the code, hopefully might shed some light <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> <link rel="stylesheet" type="text/css" href="CPR.css"> <link...
  2. S

    Auto scroll Scroll to Certain Points on a sub form on button click

    Hi All I have got a Spell check function to check two fields when a button is clicked prior to creating a report, this works perfectly. The issue I have is when it is spell checking a particular box it wont scroll down show the sub form textbox it is checking and just remains at the top of the...
  3. S

    Opening Website - looking for error

    Hello I have tried the below code but getting an error of "Compile Error Expected End With" 'Wait for IE to load With IE Do Until .ReadyState = 4 DoEvents Loop Dim url As String, html As String If InStr(html, "Incorrect Ref") > 0 Then MsgBox "Found it" Else MsgBox "Not found"...
  4. S

    Opening Website - looking for error

    Hello, no it doesn't have to load if it shows incorrect Ref but I was under the impression it would need to find the data?
  5. S

    Opening Website - looking for error

    Hello I tried the above code but nothing seemed to work, no errors either Also the question about the code after a lot of testing it was needed, I am unsure why
  6. S

    Opening Website - looking for error

    Hello all, I have got some VBA code that automatically opens up the correct intranet webpage via reference numbers in other fields, ideally what I want is when a user clicks out of the field it searches the website for the words "Incorrect Ref", if this happens then to do an If statement to...
  7. S

    Error issue

    I think I have finally cracked it!, the sub form was creating a record on load before the main form has even created a ref number, and then conflicting, I had a field set to "NULL" on load which forced a creation of a record weirdly
  8. S

    Error issue

    Not really :/ :D
  9. S

    Error issue

    Hi all I seem to be getting this issue again, but seems to be very intermittent, sometimes showing other times not which is a bit of a pain, If I copy + paste to make a copy of the database seems to work again for a while then appears again, any suggestions on where to look I have looked in...
    • stu_c
    • Thread
    • Replies: 7
    • Forum: Forms
  10. S

    Draw over image

    Morning Buddha Thank you for the below, its defiantly a start, how do you access the webbrowser controls?
  11. S

    Draw over image

    it might work? what are you thinking?
  12. S

    Draw over image

    Hi all this may not be possible but till give it an ask anyway, I have the below image on a form and I would like users to be able to draw over the top of it with a clear button which would clear everything afterwards. It could the the user clicks on it and opens another program to do the edit...
    • stu_c
    • Thread
    • Replies: 6
    • Forum: Forms
  13. S

    Autosave code

    Hi all I have a form that some of the fields require a lot of data, we are having issues whereby users are in one field for several hours and sometimes if a network connection is lost and they haven't clicked out of the field they lose all the information, if there a bit of code I can use to...
  14. S

    Solved Using Default text - 240 character limit

    I have managed to do it using a Dlookup, thanks of the defaultID number
  15. S

    Solved Using Default text - 240 character limit

    how would you do that as a record set?
  16. S

    Solved Using Default text - 240 character limit

    I think maybe it might be better to do a DLookup?
  17. S

    Solved Using Default text - 240 character limit

    Hello Minty I am using a combo box Column 1 is a short Title of the default text Column 2 holds the whole default length (hidden) I am only showing the column 1 in the combo box which users click on which works fine, the issue I have is if the default text is over 240+ characters it wont paste...
  18. S

    Solved Using Default text - 240 character limit

    the first column is the name of the default text for example Delivery text then column 2 is the full data and the drop down list only shows the title, but the issue I have is that it wont paste the whole of the full data
  19. S

    Solved Using Default text - 240 character limit

    if there a way to pull the data from the column Query the dropdown list is linked to rather from the column?
  20. S

    Solved Using Default text - 240 character limit

    Hi Minty, My table where the data is stored in in Long text and all the data is there but in the actual drop down list the column limit is only around 240 which is the issue, even when I go into the Query where the dropdown list looks into all the data is there but not on the dropdown :(
Back
Top Bottom