Search results

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

There are between 7 and 36 businesses per business type... there is only one business type per business. There are 3-8 categories per business type (which translates to 3-8 categories per business), all businesses within a business type use the same categories. Some of the categories are...

I am working on a complex database to store Business information as well as specific into about that Business... here is the tricky part... The individual companies are sorted by Business type (i.e. Computer Software Companies, Child Care Providers, Commercial Building Contractors, etc.) and...