Search results for query: *

I use the calendar control on a date range form that enables my users to enter date parameters for running reports. It has worked fine for years. Now suddenly it is throwing me an error (Method ‘Value’ of object ‘_CustomControl’ failed) on my machine only. It seems to be working on other...

Thanks....both solutions worked. I had already thought about the fact that sometime a closed record will probably need to be changed. Maybe I will change the trigger to a checkbox of some kind. One other little glitch. It is working perfectly for the main form itself, but I have a couple of...

I have a database for Pretrial Bail Release Supervision. Once the case is closed, a [CaseClosedDate] will be entered in the form. As soon as that field is no longer empty, I would like the record to become read-only. They have other cases (records), however, that need to remain unlocked. I...

Perfect! How easy was that! Thanks again for your time!

I have an access database on a laptop that goes out into the field where records are entered. One of the tables is actually a replication of a table out of a different database to save duplicate data entry. When the laptop comes back to the office, they hook to the network and click a command...

I have a Fees Form (Fees1) with a Payment subform including two calculations in the form footer: TotalAmountPaid=Sum([AMOUNTPAID]) Balance=IIf(IsNull([TotalAmountPaid]),[Forms]![frmclient]![fees1]!feeamount, [Forms]![frmclient]![fees1]!feeamount-[TotalAmountPaid]) It works fine most of the...

That was easy! Thanks! Don't know why I didn't try that to begin with!

I can't seem to get Access to give me a delete confirmation message when I choose to delete through my form. If I go to the table and delete, I get the message. I don't have any code to turn warnings off and I have the Confirm Record Changes checked in my Options on both the front end and the...

Thank you.....it worked perfectly!

I've searched the database and found a few suggestions but none of them seem to work. I want to set the default value for a textbox on a form to be equal to the user's network logon name. We are using WindowsXP Pro on the local machines, Windows 2003 on the server, and Access 2000. I tried...

Yesterday morning we seemed to have a power glitch and it caused the "file is not an Access database or needs to be repaired" message to show up for my back end file. (Using Access 2000 on a network with the front end MDE and the back end MDB both on the network - about 9 users) Ran the repair...

Thanks PHV! That suggestion worked like a charm! Merry Christmas and Happy New Year! Have a Star!

The And is functioning correctly, I just tested it. The part that it is not liking is subtracting the two parameter values. Any other ideas?

Seasons Greetings All!- I need to pull the number of days in any given month from a date range. The start of the date range is a field called [hookupdate] and the end of the date range is a field called [enddate]. I need to be able to tell how many days in that range fall within any given...

Wow! What a trained eye! I didn't realize that underscore was doubled. Thanks a bunch!

I am trying to produce a message box if a user enters, through a form, a duplicate Social Security # in the Client table. (Named "tbl Client" I know spaces aren't good....I inherited this thing!) I want the message box to pop up on the Before Update event of the SSNum control rather than...

Thank you!!!

I'm using the following piece of code and getting a compile error. If Me.[LatestNeg]![latestnegtest] < Me.LatestPos![latestpostest] Then Me.BaselineNeg.Value = "" ElseIf IsNull(Me.BaselineNeg) And Me.LatestNeg!latestnegtest > Me.LatestPos![latestpostest] Then Me.BaselineNeg =...

I got it to work! Still being haunted by my predecessor's spaces in object names. Thanks a million for your time! Beverlee

Same error!