Search results for query: *

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

should mention I'm using Outlook 2003 with Exchange 2003 (obvz) Want the best answers? See FAQ181-2886 www.redapples.v21hosting.co.uk

I have some resources such as rooms and equipment (laptops, projectors and the like) which all have mailboxes and can be scheduled in. This is fine and dandy. I have read much about being able to get these resources to accept meeting requests automatically again fine and dandy. However I have...

Well could you not use this select query to aid your deletion? I assume you would have it saved? In which case your delete query could reference the primary key of the table against the primary keys in the select query could it not? That is: the only output field you need in your select query...

sorry about that- Air code - code done on the fly and not tested Dimensioned variables - Dim Myvar as variant e.g. so for about you would need to have dim rs as new ADODB.Recordset Dim cnn as ADODB.Connection Set cnn = CurrentProject.Connection ADO - ActiveX Data Objects the reason you got...

Have you tried opening a recordset of that table and then using the recordset.find method? This could be caught by using e.g. (air code assumes dimensioned variables for recordset and connection and using ADO) rs.open "TItemXRef", conn,3,3 rs.find "ItemNumber = '" &...