Recent content by MLUCKHAM

Yep, thanks guys, just thought there may have been a way of updating the column direct. I opted for the following code: - Private Sub Command6_Click() Dim n As Long, newRowSource As String Dim c As Long n = List0.ListIndex c = 1 newRowSource = "" For i = 0 To...

It is a value list...

It is a List Box

I want to change a column from a combo box in VBA Code. Is there a quick way of doing this or have I got to remove the row and add it back again? I can access a column from a row that is selected via: - List0.Column(1, List0.ListIndex).Value However, this is readonly...

OK, I have recorded a video of me running my test database on the users machine. Have a look if you are bored! The other really weird bit of info is that if the user logs onto another machine she gets the same behavior. So, as an experiment I asked a different user to log onto her machine and...

I think it has got focus. The issue is that after it has loaded, if you then try to put the focus on the lower window (which according to Microsoft Form.Modal Property - https://msdn.microsoft.com/en-us/library/office/ff821033.aspx - says "When you open a modal window, other windows in...

OK - thank for checking. Luckily it seems a rare one, but 2 machines in 300 is not rare enough for me! The odd thing is the behavior I am seeing is "sort of modal". On the user machine I can click on frm1, it looks like it has focus (e.g. brought to the top), but you cannot click on the...

Thanks for checking. Yep, I have Windows 10 and Modal means Modal for my machine. I am waiting to here back from the other user, but I wonder if he is using Windows 8.1 as well... I change the test DB to open the second form as a dialogue and still it allows me to bring the first form to the...

Help! I have some serious odd behavior on a couple of PC's. I have DB that uses Access 2010 runtime. The DB uses modal / pop-up forms. This system is installed on about 300 PC's running a range of OS - Windows 7, 8.1 and 10. On two computers so far we have a strange issue. When a form is...

Found it!!! DoCmd.RunCommand acCmdAppMaximize

Hi Does anyone know if there is a way of making sure that the underlying base Access Window is maximised? I have the short cut set to start maximised, but some users are being clever and changing the window size. The problem is that many of the operations within access (such as Form Centre)...

That is not my experience. When I was working on this component I had a fresh Windows 7 machine with Office 2010 installed (but no Access). I installed Access Runtime. When I tried the DB without the office reference the spell check did not load. With the reference it does load. In fact if you...

To be honest my post was not to discuss the mechanism. I have had to do the leg work and I know how the spell checker is called. My post was about the early and late binding options for the office object model. By all means do the same analysis, but take my word for it, in Access runtime you...

The spell checker is referenced through the office object model as I used it now, however with full blown Access the proofing tools are referenced within the Access environment. but as I am using early binding I have to reference a specific object. I am using an accdb file through Access...

This is a Access system that I have developed. It is part of a larger product which is sold to clients. I release the system using Access 2010 runtime. This allows me to distribute the system without the end user having to have purchased Office professional and have Access installed. Some of my...