Recent content by Gaupo

I have a Db in access which I build reports in excel all works well. I have recently come up with the need to color code records based on priority (e.g 1,2, or 3). I am having trouble building the code color code the excel sheet as it builds. I have been able to allow for color coding using...

I is being recognized as a link and it will pull up on occasion the Adobe reader but not the file it self. It will pull up and display Word document. I know the links are good "I have cut and paste them into the address bar and they go to the file with no problem".

I am using hyperlinks on a form to connect to documents (.pdf) on a network. I can not get the links to work, I do know the links are good. Is this a problem with Microsoft security and is there a way around it. Any help would be very much appreciated

All the same fields are on each of the Tabs, the only difference between each of the Tabs is Criteriaused in the combo box to select it's contents. I know this is very hard to understand through email and I am not very good at giving you a good perspective. But again I only want what the...

Your last statement is what I am looking for, but the form is pulling data from one query which I use different expressions on. The data still shows for all line items on each Tab, but using the combo box and choosing a selected item does bring that item up. I am having difficulty getting my...

I have a form with three tabs all pulling from one query off the main form. I have a combo on each of the tabs that list a different type of publication based on filtering. The problem is on each of the tabs I can see all data from the table. How can I filter out data other than what is...

Thanks for the help, I have been away. Sorry it took so long to reply with a thank you.....

Correct! And it will pull the correct info on each of the TABS but it also shows data for all by scrolling.

I have a form with three tabs all pulling from one query off the main form. I have a combo on each of the tabs that list a different type of publication based on filtering. The problem is on each of the tabs I can see all data from the table. How can I filter out data other than what is...

This is how I call the first mod. Option Compare Database Option Explicit Private Const conQuery = "Q_Track_Open_E" Private Const conSheetName = "Open Tasks" Public Sub ExcelWorkBook() Dim rst As ADODB.Recordset 'Call GetFormatInfo ' Excel object variables Dim xlApp As...

I did try using the suggestions from the URL above, but it was the same result. The code I am using brings excel up and pulls the data fine but the formatting part does not work on the second try. Here is a copy of the code that will not work on 2nd try. Sub PageSet() With...

I have created an access DB which builds a report in Excel the item works as it should until I try and run it a second time. On the second attempt it will bring up access and put in all fields but none of the formatting will take place. If I restart the DB it will work correctly the first...

I currently have a postfix system setup as a relay in the DMZ of my network. Mail is also being relayed to it from a partner source. I am using a recipient lookup table, so any message coming in that does not match this table will be bounced. I need to have the bounce messages not go out they...