Recent content by B555

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