Recent content by Snowflake68

Thats the trouble the user is not in my network, they are outside and use VPN to connect to it. I am going to rethink this whole area now as it seems that I will just have to jump on their PC to refresh the linked tables each time I make a change to the front end (or the backend)

Its because, sometimes I make changes to the design of the tables, new column, or data type change and it doesn't recognise it until I refresh the links

Thanks everyone for your suggestions. I think I am actually trying to achieve the wrong thing here and my original request for help was incorrect. What I actually need to do is error trap to see if a linked table opens successfully. The reason for this is because I send the user the front end...

I still receive the same error message ??

Ive tried your method but am getting this error message It points at the highlighted line below. Are you able to assist me any further please?

Im just testing this on a blank form but I am getting the following error message. Are you able to advise me further please?

How do I do that please?

I have a front end application with a linked that is situated on a mapped network drive that uses a VPN to connect to it. I want to be able to error trap when the mapped drive isn't connected (if the user has forgotten to connect to the VPN). When opening the application it opens a form that...

Thank you thats good to know. I hope that it includes MS Access (as well as VBA)

How do you know this? Is there any information out there that supports this?

I so glad that this might not be the case as I have built numerous applications for my customers and this would have a major impact on them.

Do Microsoft plan to stop supporting VBA in 2027? I have just watched an internal presentation from one of our suppliers of the ERP software we use and it says that VBA will no longer be supported from 2027. Does anyone know if this is true?

It error at this line numDescHeight = txtDescription.Height but I will try your other suggestions to see if any of them work. Thanks

I have a report list has outlined text boxes which are all lined up nicely to also show the total and the VAT etc. The list of items on the report have which auto resize when the item description increases and decrease. Dim numDescHeight As Integer numDescHeight = txtDescription.Height...