Messages posted by: AgentofDarkness
Forum Index» Profile for AgentofDarkness » Messages posted by AgentofDarkness
Open Mic »Access DB Question »Go to message
Eugene wrote:You should be able to do a join command of the tables.

When I tried to join the tables each row has a fact and a conclusion. I need the rows to have a fact or a conclusion but not both. Also, I need to generate the report so that the Eval Info is printed first, then Facts, then Conclusions. It needs to look more or less like a word document which I have already set up with the 3 subreports and main report.
 
Open Mic »Access DB Question »Go to message
I've been wresteling with this problem all day so I think its time to see if any 2WC IT guys have any ideas on how to solve it. A little background first. I'm creating a DB to track an Evaluation. The evaluation has the following form.

Evaluation Info (Evaluator, Date, Title, etc)

Facts

Conclusions

The info is stored in 3 main tables. Each evaluation can have several facts and conclusions. Each fact/conclusion has an evaluationnumber so it can be tied to the correct evaluation.

The problem I'm having is developing a report. I have a MainReport which contains 3 subreports(SubReportEval, SubReportFact, SubReportConclusion). I can print the main report fine however I need to be able to print multiple MainReports. I need to make a "MasterReport" with several MainReports. Basically I need to join these main reports in the MasterReport in VB. Anybody know how I can complete this? I can produce any MainReport and I can also produce MainReport in succession as long as I close the related queries and reports before making the next MainReport. I just can't figure out how to merge all the MainReports into the MasterReport.

Here is an idea I have though. Say there are x number of MainReports. I can run each MainReport and them export the MainReport to PDF. Then I could combine the MainReports using PDF. However, I need this to be completely automated. In the end all the MainReport.PDFs should be deleted if possible and only MainReport.PDF should remain.

TIA
 
Open Mic »Happy Tuesday »Go to message
I hope it doesn't rain on the way home. Just waxed/polished my car on Sunday.
 
Open Mic »VB Problem »Go to message
PaikyPoo wrote:cool, sounds like you found an answer

Yup, I just finished coding it and it looks like everything works. One of the guys from my group said in 2 weeks they are pushing out a change to the format of report so I will have to go back in and change some of the code
 
Open Mic »VB Problem »Go to message
PaikyPoo wrote:have you tried:

temp = xlSheet("CheckBox10").Value

?

Thanks for the tip. That command doesn't work, but a very similar one does.

temp = xlbook("SheetA").CheckBox10.Value

I should have posted this yesterday
 
Open Mic »VB Problem »Go to message
PaikyPoo wrote:i'm no vb expert but why did you use in your example:

temp = CheckBox10.Value

and in example 2 it changed to:

temp = myCheckBox.Application.Value

what's the significance of .Application?

The reason I used .application is because myCheckBox.value does not exist but for some reason myCheckBox.Application.Value does exist. I'm not a VB expert either, so when it doesn't work I start to guess.
 
Open Mic »VB Problem »Go to message
I'm writing this Macro that automatically generates a report by getting data from 10 Excel Spread Sheets(Workbook A lets say) and putting them in one spread sheet(the report,Workbook B). The 10 spread sheets are in different folders. The spread sheets have check boxes in them and I have to get the state of the check box (true/false) for each spread sheet. The problem I'm having is I cannot get the state of the check box from Workbook B. The way I have the Macro set up, the macro opens each excel file and gets the data from the correct cells and writes it to the report, this part works. I'm trying to do the same thing with the check box. I need to know if the box is checked, if its checked then a variable is incremented and this variable is written to the spread sheet. If I run the following command in Workbook A, I can get the value of the check box.

Sub Test()

Dim temp as boolean

temp = CheckBox10.Value

End Sub


(^This code works, but it is in Workbook A)

I need to do the same thing in Workbook B but I am unsure of what code I should use. Here is what I have tried so far.

Sub Test()

Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim myCheckBox As OLEObject
Dim temp As String

Set xlBook = GetObject("C:\Workbook1.xls")

Set xlSheet = xlBook.Sheets("Worksheet1")

Set myCheckBox = xlSheet.OLEObjects("CheckBox10")

temp = myCheckBox.Application.Value

End Sub

(This code does not give the desired result and is in Workbook B )

This code does not return an error, but temp = "Microsoft Excel". It should be a boolean but I found that if I make it a boolean I get an error. Anyone know how I can get this to work? I tried for like 2 hours + yesterday and I don't want to waste another day guessing.
 
Open Mic »Who's familiar with 7 Treasures in Chinatown??? »Go to message
saQ "C" 1 wrote:

Really? I'd like to know your reasoning for that statement, because I live in Morton Grove.

I was stirring the pot.
 
Open Mic »Who's familiar with 7 Treasures in Chinatown??? »Go to message
Earmuffs wrote:
Ryan wrote:Where the hell is DesPlaines?
Morton Grove > Niles > Des Plaines.

Morton Grove is a shit hole. True Story. Niles FTW.

Where in DP is this place at? I live like 1 min from DP.
 
Open Mic »It is yet another fantastic day in paradise »Go to message
Muddy4dsm wrote:
AgentofDarkness wrote:
The Chairman wrote:Sportbikers are the cheapest motherfockers on the planet.
This engineer at work said engineers were the cheapest people.
fawkin engineers...

I know right.


Wait, I'm an engineering major . I'm not sure if I can dispute the cheapness though. Engineering is all about efficiency and reducing cost.
 
Open Mic »It is yet another fantastic day in paradise »Go to message
The Chairman wrote:Sportbikers are the cheapest motherfockers on the planet.

This engineer at work said engineers were the cheapest people.
 
Open Mic »Can someone inform CLSB that they permabanned me... »Go to message
Odysseys wrote:
SmartDrug wrote:Yeah, good to go now. They Spelled Smartdrug with a lowercase D now which pisses me off.
whoopie fucken do!

your lucky i spelled it right in the 1st place.

Spelling and Capitalization? These people ask too much
 
Open Mic »Fuck My Life: Everyday Life Top Stories... »Go to message
The Chairman wrote:I ordered a chocolate muffin and the intern brings me a bran muffin. FML!

One of the guys at the office told me to bring him coffee (I'm an intern). My peer mentor heard and got mad. I'm still not sure if he was joking.
 
Open Mic »for the white collars »Go to message
dave13 wrote:At the railroad we drink strong coffee. It's for keeping you awake, not for taste.

Me too. I have to add like 4 creamer things and a bunch of sugar to drink coffee but I have 2 cups a day usually otherwise I will start to fall asleep. Starting at 7AM sucks
 
Open Mic »TCO: iphone vs palm pre vs android g1 »Go to message
So for $100 a month all you can do is make phone calls with your iPhone? No internet or texting? Sounds like an uber jip to me. The Pre plan is cheaper and Sprint doesn't ram the internet plan down your throat like AT&T.
 
Open Mic »That lucky little bastard, fucken 8th grader »Go to message
whiteSeatEnvy wrote:
AgentofDarkness wrote:
whiteSeatEnvy wrote:Didn't a teacher up at Niles get caught recently? She's more of a milf then the NJ teach, but I'd still hit it.
Are you talking about the teacher from Maine East in Park Ridge?
Yeah must of been Maine East. Brunette in her late 30s?

Yea, she was my freshman bio teacher. I wouldn't hit that she isn't hot at all.
 
Open Mic »That lucky little bastard, fucken 8th grader »Go to message
whiteSeatEnvy wrote:Didn't a teacher up at Niles get caught recently? She's more of a milf then the NJ teach, but I'd still hit it.

Are you talking about the teacher from Maine East in Park Ridge?
 
Open Mic »mmm...red bull »Go to message
The Chairman wrote:
AgentofDarkness wrote:
Your a Monster man if I recall
No. I tried it once at Safety First because it was free. I was wired until 5am. That was the last time I drank Monster.

I know
 
Open Mic »mmm...red bull »Go to message
The Chairman wrote:Red bull is for the weak.

Your a Monster man if I recall
 
Open Mic »Here you go pot heads »Go to message
The Chairman wrote:
whiteSeatEnvy wrote:Reposting this cause I think we just hit on the real issue:

One side effect of lost revenue from pot sales could be that the cartels make stronger more addictive drugs to regain those lost customers with new ones. You have to be careful what you wish for.
Yup. These cartels aren't going to quit the game. They need that revenue to come in. Very good point.

If they are really making 8.5 Billion from pot sales, taking a 70% hit is really going hurt their operations. Its not like they have $8.5 billion sitting around and the top guys are swimming in that shit. They have overhead and costs as well. I don't think its easy or cheap for them to run a multinational cartel and smuggle drugs into the U.S. and sell them.
 
Forum Index» Profile for AgentofDarkness » Messages posted by AgentofDarkness
Go to:   
Powered by JForum 2.1.8 © JForum Team