User Profile

Collapse

Profile Sidebar

Collapse
panteraboy
panteraboy
Last Activity: Jul 16 '08, 03:40 PM
Joined: Apr 8 '08
Location: Ireland
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • panteraboy
    started a topic mshtml.dll error removal

    mshtml.dll error removal

    Hi again there. I was wondering how to remove a mshtml.dll error occuring in a vista machine. Im still adjusting to navigating vista but that isint the main problem. I tried running registry booster 2 which seemed to pick up the active X errors and remove them. Of course when i rebooted the error came up again.
    [code]
    C:\windows\syst em32\mshtml.dll is either not designed to run on windows or it contains an error......

    ...
    See more | Go to post

  • panteraboy
    replied to Thanks Everyone!
    Thanks missinglink business doin pleasure as always lol.
    Kind Regards Paul
    See more | Go to post

    Leave a comment:


  • panteraboy
    replied to Thanks Everyone!
    Hi missinglinq, good to here from ya again. That would work fine if it was just one form that led to the current form but I can arive at my current form from a no of different forms. So I need a way of finding the previously opened forms name and close it or keep looking though the libraries till i find a method lol . Thanks anyway
    Regards Paul
    See more | Go to post

    Leave a comment:


  • panteraboy
    started a topic Thanks Everyone!

    Thanks Everyone!

    Hi there again byters. I would just just like to extent my gratitute to every one who helped me construct my first database in the real world lol. I found this site my guiding light amongst all the darkness. Just one more wee question though .When i a user clicks on a button to go to another form. I use a close method followed by the docmd.openform" relevant form". This causes a tempory flicker and i was wondering how to close the previous...
    See more | Go to post

  • panteraboy
    replied to Maximise Windows Question
    Sorry there my bad
    Regards Paul
    See more | Go to post

    Leave a comment:


  • panteraboy
    started a topic Maximise Windows Question

    Maximise Windows Question

    Hi again there folks, I was wondering if its possible to maximise the window of the form through vba or access itself. I wish all my form windows to open fully and i was wondering does access provide a provision for this.
    Regards
    Paul
    See more | Go to post

  • panteraboy
    replied to No events fired Question
    Thats what i thought too Stewart. Im just following orders (If that what they be lol". I have my database nearly finished using access 2003 only to find out from my superiors that it is to run on 2007. I Opened it up today only to find over half the functionality doesnt work. How is that for a headache. Is there a big difference in the syntax of vba for 2007 as opposed to 2003.
    Regards
    Paul

    Ps Il be telling my boss...
    See more | Go to post
    Last edited by panteraboy; May 23 '08, 03:59 PM. Reason: spelt stewart wrong

    Leave a comment:


  • panteraboy
    started a topic No events fired Question

    No events fired Question

    Hi Folks, I was wondering is it possible to return to the user to the opening form if no events are fired for 2 mins. i.e the user is finished so i want the opening screen on when the next user comes in. I know a little about the TimerInterval and getTime methods. but i was wondering how do you tell if nothing has happened for a specific time on a form. Is it possible to do this. Any pointers would be appreciated.

    Regards Paul...
    See more | Go to post
    Last edited by panteraboy; May 23 '08, 03:04 PM. Reason: unfinished

  • panteraboy
    replied to Row Source of ComboBox Question
    I took your advice NeoPa on using the dummy format. It took me a while to get my head around what you were saying but it works just fine. entered all as the model name and used the following

    Code:
    Dim model As String
    Set db = CurrentDb
    Set qdf = db.QueryDefs("Admin_query")
     model = "='" & Me.CboFind.Value & "' "
     If (Me.CboFind.Value = "All") Then
    ...
    See more | Go to post

    Leave a comment:


  • panteraboy
    replied to Opening Word Doc in Read Only Mode?
    Hi Fish sorry for bothering you again but I have 1 Final problem. Im creating a touchscreen database for computer products that were selling. I have a small specification screen of the desired model. On this screen there is a button that when clicked opens the models full specification in a word document in read only mode (thanks for the help lol). On this screen is a an image which when clicked on returns the user back to access and closes the word...
    See more | Go to post

    Leave a comment:


  • panteraboy
    replied to Opening Word Doc in Read Only Mode?
    Helpful as always fish. Cheers again.
    Regards
    Paul
    See more | Go to post

    Leave a comment:


  • panteraboy
    started a topic Opening Word Doc in Read Only Mode?

    Opening Word Doc in Read Only Mode?

    Hi folks, Does anyone know if its possible to program the vba code so that the Word Doc i open is in Read Only mode.
    Regards
    Paul
    See more | Go to post

  • Cheers Fish. I will have some fun now mes thinks lol
    Regards
    Paul
    See more | Go to post

    Leave a comment:


  • panteraboy
    started a topic Can you print word docs directly using vba?

    Can you print word docs directly using vba?

    Hi again there folks. Ive created vba code to open a word document when a button is clicked in my form. I was wondering if there exist a facility to print this word document and close it directly through programming in vba. Any pointers or suggestions would be greatly appreciated
    Regards
    Paul
    See more | Go to post

  • panteraboy
    replied to Connecting a form with queries..
    Hi Neosam,

    Click on the command button icon from the menu. This will bring up a wizard.
    Under Categories Click Miscellaneous and under actions click Run Query. Select your stored query from the next screen an hey presto!

    Is this what you were after
    Regards
    Panteraboy
    See more | Go to post

    Leave a comment:


  • panteraboy
    replied to Row Source of ComboBox Question
    Dead on NeoPa was worth asking.
    regards panteraboy
    See more | Go to post

    Leave a comment:


  • panteraboy
    started a topic Row Source of ComboBox Question

    Row Source of ComboBox Question

    Hi fellow byters, I was wondering is it possible to combine a value list definition and an SQL query in the same line of the row Source of a combo box. The Value List does the trick for now but if a new operating system type is entered into the database i wish for the combo box to pick it up instead of adding it each time into a value list. The SQL works fine as well but i Wish to add the All Clause

    Value List version
    Code:
    
    
    ...
    See more | Go to post
    Last edited by panteraboy; May 15 '08, 12:45 PM. Reason: Unfinished

  • panteraboy
    replied to Comparison operator Syntax
    Im such an eejit lol. All it took was a between clause

    [CODE]
    Dim make As String
    Dim computertype As String
    Dim bluetooth As String
    Dim harddrive As Integer
    Dim h_min As Integer


    Set db = CurrentDb
    Set qdf = db.QueryDefs("A dmin_query")

    If (Me.CboOS.Value = "All") Then
    operatingsystem = " Like '*' "
    Else...
    See more | Go to post

    Leave a comment:


  • panteraboy
    replied to Comparison operator Syntax
    see the problem now I was that busy looking at my SQL code I didnt see the flaws in the assignment of the values to hard drives. Thanks for all the help again though.
    Regards Panteraboy
    See more | Go to post

    Leave a comment:


  • panteraboy
    replied to Comparison operator Syntax
    Im not used to debugging Do you mean debug.print strSQL. then Ctrl +g to the immediate window after running the program. Is there any way to do this without running the main program. I can see that the ORDER BY Clause needs a space in front of it in order to work, but i dont understand why it doent filter properly then in the hard drive .

    Sorry for the Annoyance
    Paul
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...