Search results

Thank you that removed the error code however the form is no longer populating the data that should show up on the form .....hope that makes sense. thanks !

Ok I figured it out. I had to go into the design view and then view code and not go the Alt F11 route. However this is what I see that is close to what you described...which one should I select? Thanks for your help! Microsoft Activex Data objects multi dimensiaonal 2.8 Library Microsoft...

Thank you. When i hit Alt F11 and went to tools, References is blacked out and I am unable to select it. ???

Good morning, I am trying to convert from Access 2007 to 2010 and I am getting this error "Compile Error User-defined type not defined. Please help Thanks! Private Sub cmdAppend_Click() Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection 'set up the recordset Dim myRSQuotes As...

that did it! i figured it out thx so much

Thx, I don't know how to append properly then because I tried that. And yes some of the data will duplicate

Hello, I have mulitple dbs that are exactly the same in design that I need to combine into one db. The problem that I am having is that the primary keys are autonumbers and I get errors when trying to copy and paste the data into the tables. Is there an easy way to combine/merge all the tables...

i could never open the file but i solved the problem by adding a parameter to the query. thank u for all ur help

its right above your last post. Thanks

here it is

I have attached the error message. I still could not open:confused:

I cant get the file to open ......it says the file may be corrupt. Also I am aware of the missing references because I deleted some other things so that I could shrink the db to post on this forum so its ok. thank u

I have attached a sample db and also a sample desired report. The report that filters the discipline in the main report is frmComparisionSheetSummaries......The only way that I have been able to achieve the desired report is by entering a criteria in subdiscipline in qryComparisionSheet...

yes i have to filter the sub report because if it is not filtered all the sub totals show and it only needs to show the one discipline/sub totals. the sub report does not filter when the main report filters

That is why i thought it would be best to have a code that would set the criteria in the query with the combo box initially ........because when the criteria is set in the query it gives the the information that I need in the sub report and the main report.

yes the filtering by discipline achieves everything that I need because I need a report broken down by discipline/each work item except for in the sub report. In the sub report I need the grand total of the discipline for each sub not broken down by work item number.

in the report I do need the work item number totals to also show but a seperate sub grand total in the footer of the report because I need to know the total per work item number and also the grand total per sub name/discipline

ok it only lets me group by sub name if i take out the work item number in the query otherwise I have the problem of it totaling by work item and not sub name...

oh thats because I needed the sub report to show the grand totals of the subcontractors per discipine. I could not figure out how to have the report show the information grouped by work item show the grand total of each sub. So I created a subreport to show the grand total and put it into the...

Can i use the AND function in the code ?