Search results for query: *

The form has six tabs, each of which is full of text boxes and controls and is almost the full 22" capriciously allowed by Bill's people. Oh but it works so well, EXCEPT that each time the form is opened, the six tab tops - lovely gray arent they? - are behind the header no matter what I...

Now the client says the app has to be converted back to Access '97 from 2000. So I did that and then started entering data, which is a LOT in this app. And I got the above-captioned error before I got too far. Is there a workaround for '97? He wants '97. It works fine in 2000. He wants it...

My attempts to use Flash and gifs in Access went nowhere. Anyone have a simple method for making command buttons act like rollovers, i.e. change color on mouse over? If this was UltraDev, I'd be cooking. Thanks so much Tim Slape

Thanks Terry, but all I needed was a global variable that picked up the key field data on it's first entry, just didn't know where to put it. Do now...

This app uses a Word merge for it's reports, but since it will be runtime, it has to merge with a txt file (no .mdb to look for in runtime). So I need to write code to export the query to a Word Merge .txt file (the option which creates the .ini) when the report command is clicked. the...

The key field ("BusinessName")is entered/appears on the first form, and is needed throughout the app, but I don't want to keep first form open. I've tried declaring it as Global, but don't know how so it doesn't work. Is that the right approach? This is what works now, but it...

Yeah, that's the problem - considerable use of headers and footers. Thanks though! Tim Slape

I don't know much of anything, and I certainly don't know how to use the content of a list box in a form as the criteria in a Query. I'm sure it's just a matter of syntax and punctuation, but my efforts have failed. The Query is used by a Word merge to create reports. Thanx in advance...

Yeah, I have one of those... I don't know anything else to try, sorry.

I assume you have already tried changing the margins in File->Page Setup?

Thanks again, Joe. I think I'll let the user select pront preview mode themselves, from within Word. Tim Slape

Joe, Amazing what a good night's sleep and some help from an expert can accomplish! The .Printout method did the trick whether Visible was True or False. It just quietly merges and starts printing. Thanks a million! Now, if I can figure out how to pull the merged doc up in PrintPreview from...

Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Documents.Open FileName:="C:\Smart\AdStratAll.doc" oApp.Visible = True Works great for opening the merged doc, but what is the command code to print it? The client wants to be able to print the doc from a...

Okay, thanks Joe... So then, if a report can only be 22 inches long, can I daisy chain 15 reports so they will all print after one button click? Tim

You're kidding? Bring back dBASE IV!!!

I am not a programmer, so don't laugh. I have to create a report that matches a Word doc with about 30 pages, 250 data fields. It really needs to be all in one, click one button and get the entire report printed. It is going to be compiled, so can't use Word merge or bookmark trick. So what...

Thanks Dustin, I'm encourage by your success with Flash within Access, now if I can figure out this OLE error. When running through the Flash Corporate Solutions Demo on the Macromedia site, you get the impression Flash will incorporate entire apps, data entry and all. Admittedly, I am new to...

I'm looking for a way to dress up a data-intense Access application, and wonder if there is a cookbook for embedding Access forms and tables in Flash? I see Macromedia Flash on the tool object list, but it doesn't do much, something about OLE not being registered. Do these two apps play...