Search results

Perfect, thanks!

I recently upgraded to Access 2003, and converted some databases from Access 97. On my reports, if I enter the function Date(), or use it in any strings, when I run the report, it calls for a parameter called Date(). I also have the same issue with using format. I tried refreshing the...

I used 364 instead of 365 days to ensure they don't enter the wrong year. I tested it, and on certain months, you can enter today's date (month and day), but have the year as last year, and it would accept it. By "garbage" dates, I mean the year was way off. These are time logs for...

Thank you for the advice. I changed the validation rule to: Between Date()-364 and Date() The one suggested earlier does not seem to weed out all the problems. The main purpose of the rule is to keep users from entering the wrong year or garbage dates, which has been a problem with the old...

The Solution Give an inch, take an mile? I figured it out, so here is my inch. The error code for a Validation Rule Violation is #2116. I added the following code to the OnError property of my subform: Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 2116 Then...

I tried all these things, and cannot get it to work. I did discover the error number was wrong. 3022 is for key violations. I cannot get the computer to return a dialog box that gives me the correct error message for the validation rule violation. Is there a way to do away with the...

Waltang, I entered the code, but it is not returning anything. The program is responding the same as before- with my custom message followed by the Access built-in message. Is there another way to force identification of this error code?

I tried your suggestion. I'm still getting the message. Maybe the error number is incorrect. Do you know where I can get a list of the message codes?

I have a subform with a date field on it. For that field, I have set a validation rule. When you enter a date that violates the rule, my custom text comes up just fine. Then I get a message that says "The value in the field or record violates the validation rule for the record of field." I...

Thank You Thank You That code works great. Thanks much!!!

I have a main form and subform that are already linked/synchronized using a combo box. (When you select an attorney's name on the main form combo box, their timelog records are displayed in the subform. One of the fields in the subform is the client's name. The users would like a second combo...

I have a subform that users can filter using the toolbar and shortcut menu filter options. Once the subform is filtered to show just the desired records, is there a way to print those records easily? When I use the built in print feature, even when selecting "print selection" it still prints...

I have a combo box on a logsheet form that is based on a query. The combo box query returns two fields from a Client table. The first field is a concatenated string showing the Client's Name and Case Code. (=[ClientName]&" "&[CaseCode]). The second query output field is the unique identifier...

I'm guessing the way I have it set up, the combo box is limiting what is displayed on the form. In question are two tables, one is a main table for each employee. The other is a detail table showing the activity log for each employee. It is a one-to-many relationship, referential integrity...

I have a subform based on a query where I have placed a combo box that forces users to select a client name from a list. The list is made of open cases and closed cases. The trouble is that the list is getting extremely long, and I wish to limit the combo box choices to just the open cases...

Sure does. I just used If..Then rather than Case..Else. I'm not much of a code writer, and don't use Case..Else much. It took seeing the parallel in the IF..Then for me to figure it out. Thanks for your help.

Ok, I found an answer in an error-trapping post, and it works well. For others for future reference, here is what I did: I added the following code to the command button that opens the pop up form: Private Sub Command13_Click() On Error GoTo Err_Command13_Click Dim stDocName As String...

Ok, it looks like this topic has come up many times before. I used the search engine and found several previous similar questions and responses. I'll try those out. By the way, the search engine in this forum works really well. I have been on other forums where the search engines are...

I'm kind of new to this, so please excuse my apparent lack of sophistication... The error does not come into play when printing. It only happens when you open the pop up form (using my user defined command button that opens the form), then press my user defined "Cancel" button. Would the...

I am using a command button to open a form that gathers data for a report. I have added an OK button and a Cancel button to the pop up form using the built in IsLoaded function in combo with the Close method in a macro that controlls the button. Whenever I press the Cancel Button to close the...