Recent content by Ratter

I am using the upsizing wizard to convert a Access 2003 db to SQL Server. I have finally worked out how to create an application which doesn't require a SQL server logon (an exercise in extreme frustration:confused:) but if I want to add a linked table or refresh a link I cannot do so without...

Looks to me like you need the InStr function to find a string in a string and then use If Then Else. Partial matches are hard to use with Case

Thanks for that but it didn't work - I just get a login failure. I'm still confused as to what is happening because surely if it returns success when connecting, I don't understand why it tries to connect again when you actually try to access a table by running a query. What I really want to...

I have upsized an Access application to a SQL server back end and I cannot login using VBA code. I have produced a really simple test set up with just one attached table and I am using this code directly from my autoexec Dim cn As New ADODB.Connection Set cn = New ADODB.Connection Dim...

Thanks for that Linq. I do remember about that now - one of Access's many curiosities.

Thanks, that looks good and the slider is pretty self-explanatory but my slider (5.0 or 6.0) doesn't have an OnChanged event only an OnUpdated one which doesn't seem to fire when you move the slider. Not sure what I'm doing wrong

Does anyone know how to use a scrollbar control on an Access 2003 form? I have tried using an MSForms scrollbar but can't find any documentation or examples. All I want to do is to set the min and max values for it and detect where it is between those values