Recent content by roosn

  1. R

    loading forms quicker

    I have a Form with tab box of 6 pages, the default page apart, each of the other 5 pages has a listbox, and the SQL for each listbox is a bit heavy and can take the page a while to load i have the code so that once i have opened a page, go to a different page, and go back in that page, the...
  2. R

    Highlight items in list box by VBA/sql query

    i have a form with 6 multiselect 'simple listboxes, which i use to query about 120,000 records so when i make my selections on a listbox, the textbox below records the selected ID's as for example 6,9,12, i then create the query in SQL and the records output works quite well within 2 - 3 of...
  3. R

    multiple list boxes height value on a form

    Hi on a form i have 4 list boxes in a line side by side, beneath these list boxes is one button, and beneath the button is 4 list boxes side by side what i would like to do is have the button top value just below the largest height from the list boxes above, which is driven by the listcount...
  4. R

    string value instead of a query

    Thank you for the advice, its been taken
  5. R

    string value instead of a query

    1st, i have tried to search, but i am not sure how to title the search i know what i want to do, but dont know the full correct access terminology hence please bear with me i have a table of 120,000 records. each record is applicable to at least 1 part, therefore i placed a FK in this table...
  6. R

    viewing a pdf in web browser control

    thanks jdraw i caught this page earlier and tried the various text described and there he comments that the web browser control can't be assigned on an unbound form, which i think i am proving the now
  7. R

    viewing a pdf in web browser control

    Hi Minty Adobe Acrobat X Pro Hi jdraw there is no .Navigate control on the 2013 version i came across this earlier when i was googling thanks guys for the replies i'm using access 2013 64-bit, it could be that i need to use the 32 bit version
  8. R

    viewing a pdf in web browser control

    Hi jdraw thank you for that reply its interesting because again, the actual pdf file opens, and the web browser itself shows a blank page, albeit with the text "Navigation to the webpage was cancelled"
  9. R

    viewing a pdf in web browser control

    Hi i have an access 2013 unbound form, for which the aim was to record certain information from a pdf file. so rather than load the fields with information copied and pasted from a pdf, i would like to show a pdf in a web browser, the file location controlled by a location on a txtbox...
  10. R

    Question Starting out again with access and sql server

    hi I am trying to resurrect the use of data i previously used with good effect that was stored on sql server from 6 years ago, using access 2013. in the sql server database i have a list of approx 100,000 document references, each document may have more than one revision, so i have another...
  11. R

    passing listbox rowsource to another form's listbox

    thanks, thats very helpful today however, it leads me to another problem when i save and close the popup form, can i reload the formatting of the active form, which would normally occur when that form loads i have the list box heights set to the listcount etc
  12. R

    passing listbox rowsource to another form's listbox

    hi, i have a few questions on using a popup form 1. on my main form, i have a listbox, i would like to edit the values of the listbox. to do this, i have a popup form with 2 listboxes, one to have the values of the listbox on the main form, and the other listbox with option values for the 1st...
  13. R

    storing a file location and opening the file from a form

    thank you for your replies i've tried my 2009 post, the links there won't open with access 2013, i've tried searching "Access 2013 common dialog", but to no avail other than being aware of the "PtrSafe" edit to the declaration. i've tried...
  14. R

    storing a file location and opening the file from a form

    Hi a few years ago, i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text i made the mistake of not copying the files for...
  15. R

    Connect to SQL server.

    Hi On 3 different machines, 2 x W7 and 1 x W8.1. i cant register a server using SSL Server 2008 SP3 thru the management studio. i am reformatting and reloading w7 on one and still no go. can anyone please advise a link that literally takes me by the hand, as i cant work out why this is the case...
Top Bottom