Search results

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

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:

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

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

Hello, my combo box works fine and it updates the field as expected, however when i choose a value on the list, it brings up the appropriate records on the form but moves the name on the combobox to the next value, but the records still remain for the first value i chose, when i choose the...

Hi, i basically have a combobox that when selected checks all the check boxes that are applicable for that customer. Now the checked boxes i want to export these out in excel. it was working fine previously when the checkboxes were not bound, but now that they are bound its not working.. and am...

Hello, i have bunch of checkboxes that someone can click and export to excel, however it exports to different tabs. how do i make them export to one tab but on different rows? so for example if check box1, 2 and 3 are clicked and only 1 and 3 have values then current it exports checkbox 1 value...

Hello, i have a form with subform where user can see the hours allocated, if they want to add more hours they can then open up another form with different options that they can choose to add additional hours, in this form there is also one memo field (basically description of the hours). What...

Hi, Can someone please help on summing up 2 rows and posting the values in a table? So here i what i have ImpID P1Hrs P2Hrs P3Hrs P4Hrs DBD 34 60 56 16 DBC 21 20 38 6 I want to add so the result is DBD/DBC 55 80 94 22 then post the value above in a main table under P1Tothrs, P2Tothrs...

Hello, i have a question regarding checkboxes, is it possible to load textbox values when a checkbox is clicked? For example i have 2 checkboxes, if chbox1 is clicked i want to run qry1 and load txtbox1, txtbox2, txtbox3, if chkbox 2 is clicked i want to run qry2 and load txtbox1, txtbox2...

Hello, this use to work perfectly until i went from 2007 to 2003... basically few of my users need to use this DB in 2003 but they were getting an error, when i did some research i fixed few things but now i am stuck here.. can someone please assist? error - run time error 3207 can not update...

Hello, can some one please assist on why this formula is not working? I've inheritated this workbook from someone else so really its not making any sense at this point. =IF(ISERROR(VLOOKUP(CONCATENATE(LEFT($C5,FIND(" / ",$C5)-1)...

Hello, can anyone pin point why this line is erroring? "runtime error - 438" Object doesnt support this property or method 'Get file selection from common dialog control With Me.ComDialogBTN .DialogTitle = "Select File" ' this is where its highlighting, if i comment this out then it goes to...

Compile Error: "Cant find project on Library" in MS 2003 but works fine in 2007 Hello everyone, can someone please help me in determining this issue? I have the following piece of code that is erroring in MS 2003 but it works fine in 2007. it highlights the "Set ref =" under the form_open and...

Hello, i have 4 checkboxes and have differnet queries that go along with it that i want to export to Excel. So the way i written the code is as follows, So if chkbox1 is clicked then qry1 is run and exported if chkbox2 is clicked then qry2 is run and exported if chkbox1 and 2 are clicked...

Does anyone know how i can overcome this error? I currently have this query where i am converting the COBOL numbers into actual dollar amounts. What i want to now is sum up the actual dollar amounts (Amount_$ below) but when i do a Sum query it gives an error for "Data Type mismatch" can anyone...

Hello, i am writing an append query where certain fields are written to a table, this is working fine but how do i write an if then statement in the query where i am asking to look for 2 different situations? table with 4 different fields, NameID, RecID, FieldNumber, Amount - tryingt o query...

Hello, is there an easier way to run multiple append queries using VBA? i know that i can put the docmd.openquery "query name" is one option..bt i have about 200 queries that I would like to run.. all the names of the query start with "qryedit..." so is there a way where i can say if the query...

Hello, I am currently exporting multiple queries in excel using transferspreasheet command. This is all working fine however what i want to do now is when i am exporting to excel and formatting excel using excel automation, i want to highlight the blank cells in usedrange to highlight in...