Recent content by Judy

Thanks for the help. It didn't work at first -- I ended up having to requery the form. This is what I did: Dim stDocName As String stDocName = "frm1" DoCmd.OpenForm stDocName Forms![frm1].Requery Forms![frm1].RecordsetClone.FindFirst "[RecordID] = " & Me![RecordID] msgbox "me!RecordID="...

Hopefully I can explain this correctly.... I have a form that shows a current record. When a check box is clicked to true it marks the current record as a historical record, opens another form (acFormAdd) and the user adds a new record. On the second forms close event, I tried a few options to...

Date Issue Thanks Col! That was it. I didn't use 'between', just date()-30. Big DUH for me today. Hope all is well and hope you have a great holiday!

Hi all, I'm trying to pull a query/view from an employee table with all active employees and employees who have terminated within the past 30 days. I've tried entering in the TermDate criteria field 'is null' or 'date() - 30'. I'm also posting this message on the SQL message board since I am...

Works great! Thanks so much!

Can anyone tell me how to determine the state of Lotus Notes. In my Access database, I have a button to generate Lotus Notes e-mail. When the user clicks the button, I would like to determine if the Lotus Notes application is open (and not timed out due to security settings) and if not...

It's been a while since I've posted to the board and I'm happy to be back. I always know where to go when I'm stuck! My problem is common ... how can tables be locked down or hidden? I've searched the board on the subject and there have been many suggestions (Tools, Start-up and etc.) but I...

On June 24 I posted a request and Colin Essex replied to my post by suggesting a way to add an entry to a combo box if not already in the source table. I really like the simplicity of this method, however, I'm getting a run time error that I can't figure out how to fix. Here is my code...

I'm getting the same data type mismatch error as lorenzoaj. I believe this is because the text entered into the combo box is text and the primary key is an auto number field so it looks like it's trying to update the auto number field to the text in the cbo box. The cbo box is based on a 2...

I need to generate a file number which will consist of the date, formatted as yymmdd and a running number of records for the date, for example, 02062501, 02062502, etc. I tried using: Count(DLookup(field, "qry", Date())), on the form's before insert event, but it didn't work. Any ideas...

Yep, that's all I'm trying to do. Am I making this more difficult than it should be? Thanks! Judy

Can someone tell me how a form referenced that is not the form that has the focus? I have a form (first form) with a combo box object where the user selects data to enter from the selection list. The double-click event of the combo box object on the form opens another form (second form)...

Funny, but I answered my own question! Just in case anyone cares, this is the solution I came up with: Dim stDocName As String Dim strMessage As String Dim intRecords As Integer ' Hide query messages and customize referential integrity message ' and confirmation of deleted record...

I have a form on which I added a button to delete a record by running a delete query. Instead of the pre-defined message boxes (you are about to run a query... and you are about to delete 1 record...) I would like to supress those messages and show a message only if deleting the record violates...

It was an excercise in a book I'm studying for VB. The exercise required that I count characters, words and lines in a rich text box. I figured it out using a function for word and line. Thanks!