Recent content by Summer123

all set i resolved the issue, u're right though VLOOKUP only takes the first value. I took another route where i concatentated the text and then posted that value. all set. thanks again!

First of all thank you for your quick response. Can you tell me a little bit more on what you mean by dynamic ranges and simple filter?

hello, can someone please tell me how i can display the 2 values chosen by using vlookup, currently i have it so that if you put an X in column at the footer it shows the values listed under column B and C,. But if more then one x is placed in column A then only the first value is shown, what i...

first of all thank you for assisting me on this! yes I've tried the following project list - main form project detail - subform text119 is the control source [Forms]![Project List]![project detail].[Form]![Text119].Requery also just tried me.text119.requery - that didnt work either, though...

the name is something else, but i pasted incorrectly...though in the code i have it correct. yes the form has macro but i'm trying to just requery the form using VBA ... should i not mix the 2 then? also i dont know anything about MACROS either

just tried that and that didnt work.... i inherited this db so not sure how to do this but i do see a macro on the form on the "On Load" event and it has things that i dont understand. also when i close out of the form and go back in the memo field is update with the selection i have made...

how do you requery a control on a form pulled from subform? this should be easy but i'm going crazy here... i've tried but it doesnt work Private Sub Form_AfterUpdate() [Forms]![Project_Details]![subform].[Form]![Text119].Requery End Sub please help?:banghead:

Does anyone know how to requery a memo field in the following function? i've tried controlname.requery but thats hasnt worked for me successfully. please advise. Public Function fncTaskComments(ProjectID As Long) As String On Error GoTo fncTaskComments_Error Dim rst As DAO.Recordset...

hi PNGBill, how would we modify your function to requery the field on the first tab once something is picked? i've tried controlname.requery but that hastn worked. please help.

any help on this would be great...

hi PNGBill, were you able to look into this? sorry to bug you. thank you

thank you all for replying. my main goal was to hide only the modules i created.. this way the user can still get in and create queries but cant touch the code that i have created to run these multiple queries.. does that make sense? i tried MDE but it doesnt let you create new queries.. you...

Hi, is there a way to hide modules only in VBA window? i have usear who are smart enough to unhide the "module" option in navigation window... how do i go in VBA and only hide the modules? i still want to them to see the forms and the VBA behind the forms.. but not the module.. is there a way to...

here is the updated db

hi PNGBill, Thanks for your help earlier.. in this same thread i have another question... your code worked fine but instead of the comma can it be so that each line is its own and its separated out instead of by comma's by a new line? i tried to remove the comma and it didnt work then i tried...