Search results for query: *

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...

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?

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...

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...

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

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...

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...

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...

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...

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

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

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

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...

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.

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...

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...

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...

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

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

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