Recent content by Hosacans

I've checked several FAQs and threads on this topic in the VB6 forum... from what i gathered, calling a MS Access Macro is NOT possible without MS Access installed in the client computer- without referencing any Access Object library in VB... the macro i set up in MS Access does several text...

thanks for the tips. Hosackies

Hi all, I'm trying to make an .exe using VB 6.0 to call an MS Access macro. I found the following code on the web. Set your project references to MS Access x.x object type library and try running this code: Public Sub RunAccessMacro(strDB As String, strMacro As String)...

It's running on Windows XP, office 2000

HI All, I recently started working with the Access Runtime tool in Office Developer 2000. I've successfully packaged a database and also deployed it to a machine that doesnt have Access installed. however, when i run setup for this package in that machine, i get an installation error that reads...

I finally figure out how the reports were shrinking. It had nothing to do with access, but rather the scale functionality in adobe acrobat. it's simply that the sub reports were formatted with 11x18 paper, then acrobat scales it down to letter size... thus when i see page setup... access is...

i guess what i am trying to say is that Access have some kind of control or report properties that will fit/shrink a larger subreport to the main report without having to readjust the sizes of all the contents in the sub report. This will save me a lot of time to manually readjust everything i...

bump.. any help?

Hi All, I have 3 sub reports each with different widths, and one of the sub reports is too wide for a letter size layout, even with margins set to zero. Normally i would adjust the content of the subreport to fit the main report. But in this case, i cant find any more space to give, and the...

Hi All, I have another question on report formatting, I have 3 sub reports each with different widths, and one of the sub reports is too wide for a letter size layout, even with margins set to zero. Normally i would adjust the content of the subreport to fit the main report. But in this case, i...

Thanks Skip, That worked wonderfully. Hosacans

Skip, This is putting it through an infinite loop and deletes all the data. Please advise. Thanks Hosackies

Hi All, I have a spreadsheet with multiple columns that contains the same header. I want to write a macro that will delete the entire column with that header. here's what i have so far N(1) = "Pen %" N(2) = "LY R Sls " N(3) = "LY U Sls " N(4) = "Chg %" N(5) = "TY U EOH...

Thanks this is a great tool!! -Hosacans

HI All, the database that i am using is getting to big due to the ole objects. I searched in the Access VBA forum and found that there's a way to display images on reports using a link. I am going to try converting my database to that but first i want to extract all the images i've stored on my...