Search results

I'm not sure this can be done...Could you post a sample database?

Have you tried this on the afterupdate event on the combo box? me.combobox = me.yourtextfieldhere.

I think this will correct whatever was wrong.

Hey Saliorguy...Did you get this?

At first glance i would say you need some type of quotes... Like ' [forms]![Stamkort].[myselector]' & "*" And you will need an asterisk ("*") if you are using the "LIKE" function otherwise it should be "=" instead of "LIKE". not tested...just a thought. Larry

I use something like this...without a message box though Private Sub cmdEMail_Click() On Error GoTo Err_cmdEMail_Click Dim stDocName As String stDocName = "CriticalCommentInfo_E-mail" 'Put your message box stuff here 'If msgbox = vbyes Then DoCmd.SendObject acReport, stDocName...

Try this one... http://bytes.com/topic/access/answers/448307-stacked-column-charts

apparently the link isnt working...I'll see what else I can find for you.

This may help...I got this after searching "stacked bar charts" in this forum. "The MS Graph engine that powers charts in Access and Excel is extremely flexible, but it often requires some tinkering. Doug Den Hoed shares his techniques for building Gantt charts, and he reveals some tricks to...

Okay...try this out. Hope this helps. :) Have a HAPPY NEW YEAR!!!! Larry

Check out the last thread and video...this may be able to help you. http://www.access-programmers.co.uk/forums/showthread.php?t=185797

See if this is something that can help out. I'll continue to work on a "look up" for you in case you need to add numbers to someone. open the frmUserMaster

Working on a solution for you...I'll get back to you today

Can you post a sample version of your Database?

More of a visual type guy here...could you post a sample DB?

Maybe you could use something like this as another form or incorporate it somehow. I think it may help get toward a good solution. Check out Form1 After update code....it will populate a list box. That would be a good way to tell what numbers people have...

I may be misunderstanding what you are after. is it a performance issue?

Check this thread out...download the database and check out form 3 code on the after update of the combo box. http://www.access-programmers.co.uk/forums/showthread.php?t=182671&highlight=Dlookup

I didn't even see that....DANG IT!!! I should have caught that too... :( Thanks Paul! Larry

Hmmm....I'll try to play around with it a bit later. Gotta finish my real jobs work. :) So If User 1 has a DID....then you want to see all the records that have numbers assigned to them, then go back and assign a TN or DN or both? is that right?