Search results for query: *

There is also a TransferSpreadsheet Action (VB) which allows you to imiport spreadsheet data with defined columns in to a specified table. I have used it sucessfully. Look in Access help and explains it well.

After developing a db in access 2000 we are contemplating distribution, which will require the license. It looks like Visual Studio Tools for the Microsoft Office System has as part of it Access 2003 Developer Extensions which will do the job. Am I looking for trouble by going to Access 2003...

I am trying to print a report based on the current (or selected) record on a form, actually a subform within a main form. I tried using a query as the basis for the report with the where condition equaling the form control, i.e., WHERE...

Do I use API to browse a drive and select a file for the Access 2000 DoCmd.TransferSpreadsheet acImport function? If so, how ? Anyone have a code sample ? Thanks

I have sucessfully done exactly that, one main with 3 sub reports. I added each subreport using the toolbox subform/subreport option.

When I use DoCmd.Maximize on any of the form events, open. load, activate the form will inially appear in its un-maxamized state then convert to its maximized state which is very unpleasing to the eye. Any way around this? I tried opening the form as hidden, then maximize, then unhide but this...