Recent content by srmousse

Same Problem I am having the exact same problem! Have you figured anything out yet?

I need to set the height of a reports detail using vba... how do you do that??? Also, how can I change the print settings, i.e. page boarders, paper size, printer, etc., also using vba... I can't find anything on it. Thanks!!!

Do you have PDF printer installed? if so, you can print to a PDF file and create custom paper size, or even just use a paper size that is larger than you need. Hope this helps!

more info... I'll attach a copy of the DB... Okay, at this point, I have made this work, however I am thinking that there has to be a better way... I have created a query to capture all of the tblBusiness linked to tblBusinessCategory by BusinessID so I end up with this: Query1 busID info...

hmmm. I had is so neatly formatted, the lines connected and everything... I promise! please ask me if you have questions about anything

Complex Report Query (CrossTab) Hey everyone! I need some help here, I am in the final design stages of my database… I am working on creating some reports and I need some help getting the info I need in the right place. Let me summarize the problem, then I will give you a rundown of my table...

more info if you can give me the full code, I can help you with this...

Okay, I have a multi-functional question... I have created a form that will allow for complex querying of my business contacts. I have successfully completed the code used to create the query string. Now I just need to be able export the query results and use them in the following three ways...

Thanks! Thanks, I appreciate the offer!!! I think it will be okay, I have an input mask on that particular field forcing the value to be 4 charicters of numerical value only, so I don't think there will be a chance of it being anything but numerical.

edit directly Apparently I can manipulate the string as a number directly... hmm... that is interesting, but is it safe?

I am trying to convert a string absolutely contains a number at all times to a double for use of comparison and numerical calculation, VBA doesn't seem to support the System.Convert.ToDouble() method... I have searched and searched and can't find a way to do this... any help would be VERY...

This is a little complex, I will try to explain as best I can... I have several tables, storing businesses, business types, and categories... now, each business has between 3-7 categories, the categories are determined by the business type. here is how my tables are setup: tblBusiness -BusID...

more clarity I just wanted to clarify my posting... the primary function that I am looking for help with is how to dynamicly generate the dates so I don't have to manually enter them... and hopefully don't have to manually store them

I am trying to create a task list calendar... I have a Publish date and want to dynamically create a list of tasks leading up to that date. For example: Sample product is due to publish on August 15th 2005 I want to dynamically create several task corresponding to Sample Product. the tasks...

I have a handful of misc. data that is unique an really doesn't fit anywhere... I need it to be easily updateable, as it will and needs to change from time to time, What should I do with it? Some of the data is a "Common Footer" that prints on ALL reports and DOES change periodically. I...