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...

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...

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...

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...

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...

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...

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...

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 =...

Have been searching through the threads but can't find anything that seems to be close. I need to see if there is a way to have Access autogenerate new records on the 1st of each month. It could be done through a button click. I have tables called Client and Fees. They are in a One to...

I am running WindowsXP and Access 2000. I've had OLE server errors come up just within the last week in two different instances. Makes me think it had to have been an update of some kind that messed things up. The errors read: "problem communicating with the OLE Server or ActiveX control"...

I have a form which includes an Application # that cannot be duplicated. I've set it in the table to be indexed with no duplicates. If a duplicate gets entered on the form, however, it won't alert the user until he/she moves to the next record. Is there a way to alert the user immediately...

I have a front end .mde file that is on a network drive and works fine from all computers except one. On this particular computer, the switchboard comes up empty. We've tested with different Access files and with different machines and always the same. This one computer consistently brings up...

I have read only rights to a co-worker's Contacts folder. It is showing in my folder list. I want it to show as an option under Outlook Address Book when I click the "To" button, but it is not. When I right-click her Contacts folder, and go to Properties, there is no "Outlook Address Book"...

I need to edit an employee ID number that was entered into the database incorrectly. Unfortunately, the EmployeeID is the primary key for the table and it is linking to foreign keys in other tables. Is there a way that Access will let me change this without deleting relationships, etc.? I...

I have come upon this problem a few different times in various databases. I'll use hourly rate as an example. I have an employees table which includes their hourly rate of pay, and I have reports written to calculate job cost, that depend on the hourly rate. Now the employee gets a raise and...

I've searched the forums but can't find exactly what I need. In Access 2000 I have an Establishments table and an Inspections table. I need to find the two most recent inspections for each establishment. I've tried the &quot;Top 2&quot; option but it returns only the top two records from the...

Using Exchange 5.5 and Outlook 2000 - there appears to be no way to get reminders from appointments in a Public Folder Calendar. Is there some way to automate having appointments placed in the public folder copy themselves to an individual calendar where reminders can be generated. I don't see...

Does anyone know how to clear an entry out of the &quot;Find a Contact&quot; drop down list in Outlook 2000 once it is in there?