Search results for query: *

TheAceMan1 I have a database that is user active. They Imput thier own data and update thier own tables. I have a field that they want to filter by whatever value they select in a multivalue list box accessed from a form. My problem is that They can only select one, or all of values. I use the...

Dhookom, Thanks for your advice. I will give it a shot. It looks very promising. I will let you know how it goes. B555

I want to use the Multi Select function in the list box for a filter in a query, But as soon as I select Simple or Extended my query comes back blank. If I leave it at None, I can select a value as use it in my filter to run a query. I know I have data in the table I am trying to query against...

I have a pivot table built in Excel that is built from an access DB. I need to find a way to Update the Data tab, but not the Pivot tbl tab. I have logic that deletes all tabs and creates new work sheets, but I can't get it to only update the worksheet I want and leave the other work sheets...

I'm not sure about that, I was working tn 2003 and didn't need to install a driver to use it. It came with my 2003 version I think. All it does is take your string file and save it as a PDF where ever you want to put it.

Do you have to use that format. You could just publish the PDF by using somthing like this: Set objPdfPub = objImpRep.PublishPDF objPdfPub.Publish (strFile) & ".pdf

I have VB that allows me to email a valid email eddress like jsmith@xxxxx.com, But when I enter a DL group it doesn't find it in my address book. Do I need to put some code in that tells it that it is a DL and not a simple Email address? Has anyone ever done this?

I have a form that lets the user pick their selection from valid fields in a database from a qry that runs behind the form (basic Combo Stuff). But I want to allow the user to be able to select Multiple values at the same time by using the Ctrl button. I am working in 2007. I thought it was just...

Thanks for the response, I'm actually going to try Both.I like the idea of th add in. Thanks for the help. I will let you know B

Do you Run all 30 reports at the same time, or do you run them one at a time. Are you using a form or are just writing all code in VB. Do you know how you want to automate,either thru a macro or a scheduler?

You can actually just take the greater date field and subtract from the other lesser date field and times it by 24. (Date1-Date2)*24. Then all you have to do is format the foeld to display as a number. I use this all the time.

This would be in cognos Impromptu, I didn't originally put that in there.

I have two fields that I want to put into one in a date format. I have a number that looks like this 20080404 and string that looks like this 201535. I want to combine the two create a data time field that looks like "4/4/2008 20:15 PM" can anyone help me with this. Thanks

Is there something similar to this for emailing Access tabels or queries?

Thanks, I will try it out. B555

We are currently converting from Lotus Notes to Outlook express for our Email program. I have logic in place that uses Lotus notes to email reports out of Access, But does anyone have logic for outlook express? I will attach my Lotus Notes logic. Also has anyone else ever used any Mapi logic to...

Cognos Impromptu 7.3

What Version of Cognos are you working with? I think you will need to be using 7.3 or higher to get Cognos to work with Excel 2007. I would check out the cognos web site to see what is compatible. http://www.cognos.com

Our client wanted a huge report, one that involved us creating 12 to 14 subquerys. The only way to get that many into a report would be to have it span more than 1 page, But I can't get the overflow reports to go onto page two? Is there a way to do this with Cognos 7.3?

Your best bet would be to go to http://www.cognos.com/products/index.html, they also have an overview of all thier products there. It might help to understand what they can do.