Search results for query: *

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

wow... thanks PHV that did the trick.. i had a feeling that there was a built-in function for this and the solution will be something simple!!! if only i can make up the lost time spent... thanks again!! -Hosacans

Hi All, I am importing with an excel file that has a date column but as text format. all the values in this field is formatted as "mm/dd/yyyy" ex. "06/15/2007". i am stuck on converting this text string to a proper date in Access. many attempts were made by using a combination of dateserial...

Hi Skip, I am going through the same problem as well, only with a slight difference in the text string. the text dates that i receive all have the same number of digits. i.e. "06/10/2007" i tried using dateserial...

Hi John, Yes this is working great! once you've shown me the way to format these IDs. All the implementations after that went smoothly. THanks so much! and sorry for not updating the results. I've also looked into WinblowsME's way for doing it in Access VBA so i can bypass using excel to...

Thanks fneily, for the directions... the thread you posted is exactly what i am looking for. Now on to study the wisdom of scriverB!