Search results for query: *

I would like to give a big shout out to: dhookm The AceMan1 Randy700 For trying to make this work for me. I know I was not at the best of explaing it. But we got it very close to accomplishing the task, once again guys thanks. Joe

AceMan1, thanks for being so patience with me, I am so new with code I have a hard time understanding, as you can see. When I saw that message pop up I was so never happy, until I realize that I need to at least have them be able to select their name once. If you like I would be more than...

If DCount("FullName", "qryFullName", "name_ID = '" & Me.name_id & "'") > 0 Then Cancel = True MsgBox "cannot save duplicate", vbExclamation, "Duplicate" End If

Randy, I was happy to see the Msg Box pop up. But I need to at least have it to be selected one time, but not twice.

I apologized for not giving you more information. I reconstructed the form to where I have only one subform and one combo box within that subform. I hope with the following information it will make more sense. 1. Main Form called FrmBatch2b Record Source TblTimeCard2 2. Subform Called...

I have several combo boxes (with the same data in each). I do this for several reasons. Here is the bottom line, I have all these combo boxes on one form. I do not any duplicates from the combo boxes. Is this possible.

Ed, if you happen to read this. Is there anyway that I can Incorporate this code, for my above problem Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long Set cn = CurrentProject.Connection ' The user roster is...

I forgot to mention, like to thank Ed Metcalfe for this suggestion to start this thread. New to this forum, can you tell

Main Objective: Create Auto Email with Lotus Notes This is what I have so far; On the report I have a field for User name, and Date (in which I want the report go to the user) What I am looking for is when the user signs into the Database, if the user name and date matches the date sign into...

Ed, thanks for the input. I maybe over step the boundry here. As you can see, my request is a little different and little more complex. If you can give me any insight on just how to make this happen, it would be great. Looking forward to here your responce.

Let me know, how this comes out. I too would like to acconplish this task. All though mine would be a little more complex. I have a report that goes out everyday. I have a date field when the report goes to various user's. I would like to have it when the user logs into the database on...

Thank you ever so much, work like a charm

Sorry first time here. It was suggested that I should put this question in the correct forum and I concur. I have already had a couple of replies and I will paste in. I can't seem to make this work. Please take a look at this and see where I am going wrong. The bottom line answer I need is...