Search results

SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] WHERE Contacts.[DInteg] = 'Yes' AS Expr1 FROM Contacts ORDER BY Contacts.[First Name]; Take the "AS Expr1" out...see if that helps. Since that is in the "WHERE" clause I don't think you need it there. The other alternative...

Do you need the UserName to drop off after the numbers have been assigned? OR will One user have many phone numbers?

What do you mean by this? When you select a user, you want the combo boxes to show what numbers this user has? (is that correct) yep, you should be able to run select query and show who has what. Glad I got you pointed in the right direction! :) let me know if I can help out more... Larry

Could you post a sample DB?

Could you post a sample DB? I'll make sure it works then send it back.

Could you post a sample DB?

Could you post a sample DB? Can you not just set the rowsource for something like: Select FirstName, LastName From Contacts WHERE Dinteg = 'Yes' or is it based on text boxes on the form? Larry

you could try something like me.[your subform name here].refresh in the Onclick event of the button you press

You could use the DLookup() function....DLookup(expr, domain, [criteria]) I haven't tried this but... Private Sub Text16_LostFocus() me.Yourtextboxnamehere = DLookup(expr, domain, [criteria]) End Sub if that don't work, I hope it helps point you in the right direction. Let me know Larry

Not sure what you were after but take a look at this. I added a table (tblPhoneLog) Took out the UserId from the DID, DN, TN tables Fixed the combo boxes (check the record source for the NOT IN() SQL code) Look at the after update event on the UserName combo box. The new form...

I got this code from Bob Larson (smart guy who helps a lot!) This may work for you if you tweak it a little Private Sub cmbLookupTitle_NotInList(NewData As String, Response As Integer) If MsgBox("This is not in the list. Do you wish to add it?", vbQuestion + vbYesNo, "Add " & NewData &...

Not my DB, but I did get it off here. Can't remember off hand who's it is, but the logic certainly helped me.

OOPs! then it probably won't him at all since he is in 2007. I am waaaaay behind the times...but I dont' like 2007. :) (probably because I am not used to it)

Check this out...it's in Access 2003 but it will help with the logic.

So you got it working now? cool...

Try copy and pasting the "manual SQL" into the QBE and see if it works.

After you create the query in the QBE frame, you can select to view the SQL code. That will show you the "written" code.

Off the cuff... Private Sub LockRecord_DblClick(Cancel As Integer) If Me.LockRecord.Value = "Yes" Then Me.LockRecord.Value = "" END IF IF Me.LockRecord.Value = "" Then Me.LockRecord.Value = "Yes" ENd IF DoCmd.Requery End Sub Try that. I didnt' see and "END IF" after your statement...

could you post a sample DB?

I found this in the Sample Database section Database Documentor: http://www.access-programmers.co.uk/forums/showthread.php?t=173624 Not sure it would work or not since you are oracle.