Recent content by Evenflow

Hello. Is there a way to sort by format? For example I have a spreadsheet with around 5,000 lines...some of which are highlighted in red. Is there a way to sort the highlighted lines to the top or bottom of the sheet? Thanks.

Yeah, it's A3. I gave up and checked in on it on the Internet. Our printers have A1-A5, and others like this. I didn't know if 11x17 was standerdized to one of these or not. I say it's A3, but "Legal" was what I went with. I assume this is a metric system difference here in the U.S.

Hey, I need to print a report on 11x17 paper. I cant seem to find in the page setup where I could change it to this. Is there a manual way to change it to 11x17. I've checked all the network printers around here under the page setup and none give me the option for 11x17, but I know you can print...

It was creating a new sheet, but not actually selecting the sheet to place the information.

I just got it bat. I replaced: Set objSht = objWkb.Worksheets.Add objSht.Name = conSHT_NAME End If Err.Clear On Error GoTo 0 objSht.Range(conRANGE).CopyFromRecordset rs With Set objSht = objWkb.Worksheets(conSHT_NAME) If Not Err.Number = 0 Then Set objSht = objWkb.Worksheets.Add...

When the code runs...it opens a new excel workbook and goes to sheet1 of the workbook. It isn't pulling the data from the query. Not knowing enough about VBA, I've pretty much just winged my way though this. If you're talking about the Const conRANGE = ?, I don't know what I should add there.

Yes, the query does return data.

Hello. Let me start off by saying I know very little about VBA, but I'm learning something new every day and I'm having fun with it. Now, I'm trying to Automate our database a little and get some queries to export to excel, the code below is what I have so far. I know this code will only do 1...

Hello, I have the following criteria for my Query >=0.8*[Projects]![EstimatedHours]. This tells me when we've used 80% of our actual hours. How would I go about the criteria line if I wanted it to return above >= 50% hour use, but below 80%? Thanks

Hello. I've searched around the board and help files and couldn't find a straight answer for this. I have 7 or 8 different queries. Is there a way to export Query 1 to Sheet 1 of my excel workbook, then Query 2 to sheet 2 of the workbook, and so on? Thanks.

Hello. I have a field in my query called Status. The Status field in my Table has a drop down arrow where you select the status, like "Complete" "In progress" etc. In my query, what do I add to the criteria line to display only the ones complete or in progress? I get an error when I try normal...

Hello. I have a query with the fields estimated hours and actual hours. I need to know if we have reached 80% of our estimated hours, so I use >=0.8*[Table]![EstimatedHours]. This will show me if we've used 80% of our actual hours. Is there a way to maybe add a calculated field to show the true...

Hello. In my report I have a field called ActionRequired, it's either yes or no. How would I set it up to, let's say, if action is required (Yes), then maybe highlight the row in a color, or I could add a text box named Review, and in that field have it say Action is Required. How could I get...

I'm trying to get a field in my Data Access Page to display the last time a field was updated, I figured I would have to do this in HTML, after a lot of dead ends elsewhere. Here is the code: <SCRIPT language=vbscript event=BeforeUpdate(dscEventInfo) for=MSODSC> <!-- Dim DateModified...

I've searched the site and haven't really come up with an answer for this. I have a Report that I want e-mailed to two people every 10 days. If someone could give me a direction to start in, it would be appreciated.