Recent content by Luis_vxd

Hi guys I have been away for a couple of weeks. The application is now delivered to the client. It seemed that the problem was related to the fact that the fields were disabled at Form start-up and for some reason Access couldn't deal with it. The error could be replicated by hiding a field in...

Can't you see the error 2105 in the file that I have uploaded when opening form 'frmClientsExtra' or 'frmClientsNew'? I'm not sure if anybody can replicate the error. Probably not. To my experience, it seems strange and I never came across this error in this particular situation. That is why I...

you mean something like 'me.repaint' after controls enable/disable? However during Form_Load there is no change in the form and is when the 2105 error pops out.

Hi Static You are right. there is no error using a single form... This even bugs me more... Can anybody please elaborate on how Access handles the RowSource in a Single Form and in Split Form? it would help to understand this issue. Thanks

Thank you Minty My main development environment is W7 Off 13, where the issue happened. It has been like this for a couple of years and lots of applications developed without any issue.

Hi Paul I tried to replicate your test and got slightly different results. Without the problematic code I still can see the records and I can go to the new record manually in the datasheet without any error. It seems that when the form is loaded and the Form_Load is ran there are no records...

What could it be? I only use DAO where required. This app has nothing unusual in it... Would it better if I go back to the drawing board and redo the entire app from scratch? This probably will get rid of the conflict? So far I have redone the tables but imported the queries, some forms and...

I am using yet another machine running W7 and Off 2016. I have recreated the page from scratch. As soon as I added an empty On Load event I got an error, this time different: "The expression On Load you entered as the event as the event property setting produced the following error: A problem...

Thank you. I hope you can help.

All '*Client*'forms have the same record source 'tblClients_old'. Except the one you mention which was an early test and is not used in the application.

Hi RuralGuy Thank you for your help. In the many version I have created I have given different names for the tables newly created. In that specific version I renamed it _old thinking of creating a new table from scratch, which eventually happen in a new database. The structure hasn't change...

Hi all I am working on this database for a few days already. Everything went as usual except that 2 days ago I had for the first time the 'run-time error 2105' when loading a form using the following code: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec Me.cmdClose.SetFocus End Sub I...

Hi everyone My name is Luis and I live in South Africa, not South African though. I'm originally from Portugal. I have been doing Access application for quite a while. Usually when I have problems I just search the Internet and very seldom had the need to post something. Not the case now. :-)...