Recent content by redapples

Actully should have read the whole post. There is a calendar control but you would need to add additional functionality to the form to get the rest of what your after. Want the best answers? See FAQ181-2886

There is. Check out the More Controls icon on your form design tool kit. Want the best answers? See FAQ181-2886

Well something must happen even if it is not what you expect. Please can you tell us what does happen. As I said your code worked for me. I tried this on a union query also. Have you tried ADO? Want the best answers? See FAQ181-2886

Your code work on a query for me. How did it fail for you? What error occured? Want the best answers? See FAQ181-2886

have a look at this - http://www.di-mgt.com.au/classes.html I too have common classes I use a lot particularly for ADO manipulation. They do work well for unbound forms. Want the best answers? See FAQ181-2886

This is tricky, I do know that the Kill function fails in 2003 I have changed a database that used this and now use a connection to the file instead of deleting then creating a fresh one. Though this is an access file so would not help you. It was one of my customers who upgraded not I so it...

Be careful with this as the 2003 Access sandbox does not allow the kill statement. Want the best answers? See FAQ181-2886

Hmm yes I see the point, I put up the question as I was thinking from a point where I had been using some .Net front ends and also because I had been trying to be more OOPs in my use of Access using class modules where ever possible. My needs are such that I mix the tools I use dependant on the...

Which is better? I tend to bind my forms but there is an argument I suppose for creating an object or type to store information and add it using a transaction once I'm done. Anyone got any thoughts or comments? Want the best answers? See FAQ181-2886

anyone? Replying in part to keep it current. Want the best answers? See FAQ181-2886

anyone got any code they'd like to share? I'm looking to find out whether the trend of incedent of abuse or self harm can be compared across a sample. The dates of these intervention vary from person to person but i record the week they took place in. So I can get a consitent sample to...

try this Me.RecordsetClone.findfirst "[MachineType]='" & Me![Combo72] & "'" Want the best answers? See FAQ181-2886 www.redapples.v21hosting.co.uk

There are many ways to skin that particular cat, perhaps if you explained what you intend to do with the results a more directed response could be delivered. While you cant pass variables to a query as you would a stored procedure you can mimic this pass if you have a function which collects...

Just a note, this is not a bug. The date format used is the American format. Hey, they wrote it they can use whatever they like. It could be worse, what's French for "If... Then... Else" or "Do Until... Loop" at least English speakers (mostly) like me only have things like dates to worry us...

never mind found it. Delegates in Options, though this is a well hidden feature. Want the best answers? See FAQ181-2886 www.redapples.v21hosting.co.uk