Search results

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.

Hello. I dont know if this is possible, but I thought I'd ask. I have a DB that has 6 replicas. Is it possible to set up a time for like an Auto Synchronization. For example, I wanted it to sync at 7:00 p.m.? I searched around and couldn't find anything on this. Thanks.

Hello, our database is stored on a network, with 8 or so people having access to it. My problem is, I want everyone to have to enter a username and pw. Right now, if I open the db on my comp, it prompts me for my UN and PW, it doesn't for everyone else. I have set up UN's and PW's for everyone...

Hello. I'm writing a query to show if it is past 7 days of a certain date. The field in my table is SentDate. Lets say a package was sent on 2/1/05. If it is past 7 days from that date, I need the query to show this. I come up with =Now()>"[Tablename]"!"[FieldName]", I know all this shows is if...

Hello. I have a database I store on a network. I had to make 3 replicas because of people writing to the Date Access Page at the same time caused a conflict. Anyway, all 3 replicas and the master have their own DATA ACCESS PAGES. At the end of the day when I try to Synchronize all the databases...

Thanks Neileg. That worked for the most part. A little more modification and I should be on the right road. Doc Man, I think you read a little much into my question, or most likely I wasn't as clear as I should have been. I know Access queries wont trigger anything physical on its own. I just...