Recent content by gbat

Thanks - I just checked and it is in fact set to 'Shared' However I have just got round the problem by using the Timer property on frmDummy , setting it to 5 and then calling the open on frmMaintainListMembers. Probably not very elegant but it works!

Is that a property setting somewhere?

Hi All I have a form based on a table called tblListMaster and I want to allow users to open up another form showing all the members of one of the entries in that table so I have added a button called 'Show List Members'. The list members form which I then want to bring up is also based on...

Peter Not sure what version of Access you are using - I am using Access 2000 and it won't let me run a query against a table with a column name that includes the '&' symbol, Access seems to interpret that as a parameter. I would personally avoid using anything but standard alpha-numeric...

Digby Not quite sure what you mean - but have you tried using the 'and' operator in your if statement if user = admin and textbox = Password then DoCmd.OpenForm frmOne else DoCmd.OpenForm frmTwo end if

For anyone who's interested Still haven't worked out what the actual problem was (I suspect it might me be a setting on the remote SQL Server) but I have managed to get round it using the following code I found elsewhere - basically the original returned recordset is streamed out as xml and...

Hi I have a problem using an ADOBD.recordset to query data held in SQL Server -when I connect to a SQL server database hosted locally on one of my company's servers I have no problem but the test database I need to use for our UAT is hosted on a remote server at one of our software suppliers...

I had previously downloaded the VB & C# Express editions but discovered that when I wanted to install the Visual Web Developer software I had to uninstall the two Express editions. I could be wrong but I don't think you can have it all!