Search results

Marc, Something to try: change your validation rule to the following... ALike "1/1/%" Or ALike "7/1/%" ...and see if it tests OK (it worked for me in a quick mock-up in A2K). More info: http://www.eggheadcafe.com/conversation.aspx?messageid=31982891&threadid=31982891...

Best response on a Sunday a little less than six years later: You're welcome. Regards, Tim

Extra opportunity? Not sure it does...same opportunity is how I read it from this blurb (excerpted from page linked to below)... "Working with an Access project is very similar to working with an Access database...Once you connect to an SQL Server database, you can view, create, modify, and...

I may be wrong but I don't think an ADP necessarily prevents a user from fiddling with the tables unless the developer locks down the front-end. http://office.microsoft.com/en-us/access/HP052731031033.aspx Access's security model, in my opinion, has always been complicated and clunky in...

Rule 2 makes good sense. Of course an exception handler is required... Catch exception As Rule 2 If Highest(Payee) = pono1 Then ' Do nothing. Else Enforce End if

While many people warn against storing values you can calculate at any time, it's actually not uncommon to store, as you go, calculations in Accounting-Bookkeeping applications to get away from the performance issues you are experiencing. I recommend a slight re-design and the storage of...

Didn't you just have a birthday a few months ago? Time accelerates. Enjoy the day as it buzzes by... Tim

You can use ADO to add a new record. It's a bit more flexible because it will also allow you to get the autonumber that Access creates for the new record (one day this may come in handy). ' Save the new record. Dim rs As New ADODB.Recordset With rs .Locktype = adLockPessimistic...

I don't think it matters...it's just the Watercooler...

Thanks and congratulations, RG. (Interestingly, your post count has risen above your elevation...)

That sounds plausible. Of course this should only be done in the privacy of your own home.

FYI... If I set a break point and click the search button the following line of code stops my compiler dead in its tracks...perhaps because I am running this in Access 2000. Set Me.LBconnections.Recordset = Nothing Error Message: Method or data member not found. Regards, Tim

Which perhaps should be re-named the Head on the Stick Award Thingy...

And I had thought it was your way...just added a little bit more code to help the OP who may also want to look at the SQL Count function -- depending on what he wants to do...

Adding to JAL's comment... Consider creating a procedure to handle this. Roughly... Private Sub Blah ' Call the procedure MakeTempCustomerTable "CustomerUniqueName" End Sub Private Sub MakeTempCustomerTable(tableName As String) Dim my_sql As String my_sql = _ "CREATE TABLE " &...

I presume I have one lost in the queue: Arrays, collections, and the cinema. Regards, Tim

Can one name have many drawings? If so (and maybe even if not) you may want to consider working with a linked subform... Search help for subform... More... http://articles.techrepublic.com.com/5100-10878_11-5058240.html http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/subforms.pdf...

You're welcome. All's well that ends well...

Are you sure this line is correct? Forms!frmPlay_Input!SubFormations.Form!FID.SetFocu s Note the space between the last 2 characters... Regards, Tim

I think you're looking for Docmd.TransferDatabase. See help and here... Docmd.TransferDatabase Regards, Tim