Search results

Thanks, Pat. I seem to be getting a compile error on the Current Event of the Form. The message says "Object Required". I've attached a Word document to show you the code (with changes noted in bold red). If you can spot where I've gone wrong, please let me know. Thanks. -- Robert

The form I am working on allows users to change the name of an existing corporation and record the date of the name change. The form has 2 command buttons. The first button verifies the date and closes the form (as long as the date is valid). The second button allows the user to abort the name...

Thanks, Bob. Thanks, Paul. I'll forgive myself for the quotation mark mistake. But the Msgbox typo is a little embarrassing ! Paul, if I understand you correctly, I should insert my VBA code into the 2 event sub procedures which trigger the pop up calendar. Is that correct? Thanks...

Still having problems unfortunately. If anyone can spot the error in my VBA code below, please advise. I have also uploaded the zip file of my mdb file (created using ACCESS 2003). Private Sub txtSelectDate_BeforeUpdate(Cancel As Integer) ' Define the current maximum date for the...

Thanks, Paul. Just to make sure I'm on the right track - So I should: Create a Before Update sub procedure that calls the DMax function. The syntax for the DMax function/procedure would be: Function DateTest() As Date Dim dteCurrentMax As Date dteCurrentMax =...

I have created 1 Form in the attached mdb file. Before a new record is added (through the form) to the table CorpNames, I would like to check that the date entered on the form comes AFTER the date of the last (previous) name change for the corporation in question. When it does not, a warning...

I have uploaded a small db to illustrate what I am trying to do – track the history of corporate name changes. In the sample db, there are only 2 corps, but they have each undergone several name changes. The “Effective Date” field on the form uses Stephen Lebans’ Month Calendar control...

Since the problem appears to be my use of DatePicker, I should probably post a new thread with that as the subject. Hopefully someone will have an alternative to DatePicker for an ACCESS 2003 db.

Hi, George. I tried Calendar Control, but it has its own set of problems. Unlike DatePicker, it does not provide a visual calendar. Instead it provides dropdown lists. The major problem (see the attached zipped file) is that the control does not appear to offer a "Days" dropdown list...

Hi, Geroge. The only reason I'm using DTPicker is that the person who introduced me to Access used it. I'm certainly open to the idea of using other (similar) controls. I noticed that your link also included comments regarding Calendar Control. Would this control do essentially the same...

Thanks MagicMan. I have changed the CheckBox setting and that does eliminate the error message. However, the formatting of the DatePicker field is not visually pleasing, as the checkbox shows up and the default (current) date appears unhighlighted. Also, tabbing to the DatePicker field...

The zipped file is attached. Hope this helps to clarify the situation. Thanks in advance for any assistance you can offer. -- Robert PS Do you think it would be worthwhile using the FQ2 query to create a new table that simply lists the current names in use (as oppposed to the entire...

Hi, George. I have to run off to a family function right now. In a few hours, I will return and do as you suggested - try to upload the db, as it is relatively small. Thanks. -- Robert

Oddly enough, the VB Code listed for my form does not seem to include anything for the combo box. Don't know why that is. Here is the VB code for the form: Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acNewRec End Sub Private Sub...

After using a combo box on a form, I get the following error message: Can’t set Value to NULL when Checkbox property = FALSE I’d like to get rid of this error message, if possible. I have attached a file showing the contents of the table CorpNames. In spite of the number of records, the...

..........

I've been trying to implement Craig's suggestion, but I've hit a brick wall. I'll try to describe my tables & forms briefly. I have a Corporations table with 3 fields: CorpID (the primary key), Corporation, IncorpDate I have a Corporations form with text boxes for Corporation and the...

Thanks, Craig. I'll try your suggestion and experiment with it.

My database involves corporations and their tax returns. Therefore, one of the tables lists the corporations. Another table lists the various tax returns for each corp over a period of time. Sometimes, corporate names change. In fact, they can change many times over the life of a corp. And...

I have created an input mask for one of the fields on a form. The mask is >"TC"00;0;# meant to show up as TCxx within the field. When the form is opened, the mask is not visible. (Note: The form opens at the end of the existing list of records in order to add a new record). When...