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.

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

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

I'm making a query that has the fields Actual Hours, Estimated hours, and other fields related to those two. The Actual hours field contains how many hours someone has worked on a project, the Estimated is how long it should take. What I want to do from this query is trigger a report when...

Hello. I have a relational database and I need to place a date modified field in my DAP (Data Access Page). I linked my forms and tables with the information that will be updated and used the BeforeUpdate code. This works. When I update info. in the Tables, it records the date and time. When I...