Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fileman1

    Screen Resolution

    Thanks. I asked for my form to be retested, even though the user insisted it worked. If only after all the generations of Access these things were taken care of now. Guess if it's dodgy I will have to make different versions of the forms. Trouble is I cannot get the resolutions they have on my...
  2. fileman1

    Screen Resolution

    Sorry, I did. However I send a form to somebody who moved the form from one screen to another, clicking the button it gave the two resolutions wherever the form was sent to of two screens. They were able to email me back the two resolutions?
  3. fileman1

    Screen Resolution

    Many thanks. I found some code that identified the resolution of whichever screen was viewing a form. I am putting a command button on the form to identify the screen/resolution and then use appropriate Movesize values for my form. This is the basis of my my code: Private Declare Function...
  4. fileman1

    Screen Resolution

    Thanks both. The code in the link works for Access 2010 okay. I am still playing around trying to get a compromise form size/position for someone using a Laptop connected to monitor. I thought I was getting near, but putting controls on the form seems to affect form size, does not always seem to...
  5. fileman1

    Screen Resolution

    Many thanks, I will try it out tomorrow and come back on how I did.
  6. fileman1

    Screen Resolution

    I did a test form for the user to try and get a compromise screen size for a form (laptop and screen) but they came back with coordinates for each screen. Is there a way to make a blank base form to hide all Access bits ie ribbon etc, that would be compatable between screens when a user slid...
  7. fileman1

    Screen Resolution

    I am having problems not being able to optimise a database for a user having a laptop with a connected larger monitor. When they slide the application from one screen to the other they have problems. I am trying to make a blank form that will have command buttons on to set...
  8. fileman1

    ACCDE Form opening

    Thanks. I will try it on another PC at the weekend, someones coming over. I just tried playing with the database, and I keep having the MS Notice that it's sorry and needs to close. No information as to why, but decompiling it each time seems to fix it. So flakey, many other things keep...
  9. fileman1

    ACCDE Form opening

    Still unhappy the way an ACCDE opens. I have tried making ACCDR but the databases still open up so clumsy. When the applications open, ACCESS 2010 central panel logo shows up momentarily, then I think the ribbon (even though I had turned the turning ribbon off), then lined images of a form, and...
  10. fileman1

    Command Buttons look better in XP than Windows 7

    Thanks for the link, useful workround suggestion. Thanks for coming back.
  11. fileman1

    SQL Change

    Thankyou PHV, yes that's correct. Now the part A.* makes sense as being * all fields in A. Regards
  12. fileman1

    SQL Change

    Oh Dear, egg on face. It was all there, just had not enough columns set in list box. Now works fine
  13. fileman1

    SQL Change

    I am trying to modify this SQL for a different database, the function being the same for grouping on Keywords, but wanting different data for the list that it's the rows source. The Query: MySql = "SELECT A.* FROM MAIN A INNER JOIN " _ & "(SELECT M.ID1 FROM MAIN M INNER JOIN KEYWORD...
  14. fileman1

    Command Buttons look better in XP than Windows 7

    Thankyou. I am using Access 2010. I have unchecked "Using Themes" and that's when the command buttons go ugly grey and bland rectangles or square depending on stretched use. The application in XP does not use Themes, and they look good. Sometimes I think we go backwards when we go forwards.
  15. fileman1

    Command Buttons look better in XP than Windows 7

    I have an application made on Windows XP. My command buttons don't use themes and they look good. However the application on Windows 7 looks awful, the buttons are boring grey rectangles. Why should an operating system affect an Access applications looks. Is there a way to get them to look the...
  16. fileman1

    Unwanted flashing of time display label

    I have a label in my form header, it displays the date and time. I removed the seconds part hoping to kill unwanted flashing of the label as each event happens. I have tried different foreground/background colors but still has an annoying eye distracting flash. Is there a way to cure what...
  17. fileman1

    ACCESS ecountered problems must close, sorry

    Thank you Mr Gates, I am having a fun day again while you have all the money in the bank. I decided to use my Access 2010 on my Windows 7 partition. My application opened, worked okay, but when I closed it a message came up saying it could not find the database I was closing to delete? and...
  18. fileman1

    ACCESS ecountered problems must close, sorry

    I am finding it so risky opening up any application I have to modify it or add to it, as I keep getting the message, Sorry, Access has encountered a problem and must be shut down. No helpful suggestion from Microsoft as to what it might be in it's message, just Sorry Any ideas Thanks
  19. fileman1

    SQL Query not working

    Many many thanks PHV, yes that does exactly what I wanted. Perfect
  20. fileman1

    SQL Query not working

    It's the end of the day of too much stress, Table 2, ID2 is Primary Key.

Part and Inventory Search

Back
Top