Search results

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...

here is a sample database

so how do i do it on a query? i know i can add by building it but here's what the issue is i want to add hours for customer one... so here is an example tblcommonhrs name hr1 hr2 hr3 Customer1 20 30 10 Customer1 10 20 10 Customer3 40 20 20 i want to add customer1 hours only so the result is...

Hi, I have a textbox on a form that i am pulling off of a table. the table stores the infor as listed below customer ordernumber order description Jeff 123...

Need help on reports, basically i have a form where i get info from multiple tables. On the main form itself i have 3 calculated fields for hours where i add all the hours i choose (from a subform) onto the main form. my issue is i can create a query to come up with all the fields for my...

nope i can understand and thank you for looking into it! really appreciate it!