Recent content by dodyryda

Ah ok thanks , I only had 2 numbers in this range so got it working with 2 parameters as you mentioned but I'll try using the SQL as record source.

I just tried to use your code to inject the range as suggested but when I go to save the query I get an ADO error: Invalid Column name ' & Forms![RPT Pro-Search]!range & '

thanks chaps, tried it as a string but it doesn't work either .Thanks for the suggestion Vilarestal I'll give it a go..

Hi .. maybe someone can help. I need to pass a range of numbers (0 and 1) as a parameter to a query but I can't seem to get it to work. If I pass just a single number 0 or 1 the query returns the expected result. but If I assign the parameter a range using the vba below the query ignores the...

Hi.. I'm trying to create a reconnection routine for my adp project so that if the network drops the adp project will reconnect when the connection / server becomes responsive again.. One issue I have run into with the adp project is that I need to close the connection using the...

I've tried testing the connection with the following code but even though the network connection is disable the adstateOpen is still at 1. Is there another way to test? If CurrentProject.Connection.State = adStateOpen Then

I was hoping someone may be able to help me.. I'm v.new to vba and I'm trying to create a error handler that reconnects the database when it detects the connection has dropped.. I have this working on my main switchboard but having a bit of trouble with a calendar control.. The code is below...

looking at this http://bytes.com/topic/access/answers/206947-setting-currentproject-connection-vba the following code may help... but where do I need to place the sub? Would I need this on both the Ondisconnect event and say the onTimer event so that it retrys connections when it first...

hi all.. I was hoping that someone may be able to point me in the right direction... I have created an adp/sql database & it works a treat. What I get occasionally are the dbnetlib connectionwrite general network error's when for whatever reason the network falls/fails... What I would like to...

sorry for the delay getting back... the reason i need to move them as each tab holds notes for a specific depot. Raher than have seperate projects for each depot i want to allow the user to reorder the tabs so each depot can set 'their' tab to appear first. & remember this location.. .. this...

thanks vbaInet for the insight - rather not have to port my adp to .net though unless absolutely necessary as I'd have to rewrite everything i've already done. Unless there's a relatively simple method to port it across..

thanks vbaInet so no way forward then :-(

hi . I am wondering if it is possible to allow the user to reorder a tab control's pages at run time. Looking at some vb.net code at http://dotnetrix.co.uk/tabcontrol.htm it's possible there just wondering what my options are in access? can anyone make some suggestions..

probably max 8 ever. so not too taxing

look at that! superb thanks.. do you think this method would create unecessary network overhead, or it's ok?