Search results for query: *

Duane, Your suggestion is elegant in it's simplicity, and works exceedingly well. Thanks again for your quick response.

I have an access 2002 database with one report which has a background picture. If I embed the picture, the database takes up 59 Mb. If I link the picture the database is only 3.4 Mb and the picture is 384Kb. The picture is a gif file, and is a picture of a form. I keep the picture in the...

I may have to use OLE to "read the workbook" first, as the looping through the spreadsheet seems to bomb out when I try to import a months worksheet that does not exist yet. Other than that, it does seem to append to the same table just fine. Thanks for your advice. ibgary

I have an Excel spreadsheet that may have up to 12 worksheets in it, depending on the month of the year. I would like to import all available sheets into Access 2002. Using DoCmd.TransferSpreadsheet , , "GMImports", "I:\PSUProgs\Data\Aparts\PartsBucket\reports.xls", True will give me...

I have an array [results], that may be up to 25 cells long. I want to save the values in the cells to a new record in a table [ManyWords]. The problem is when I hard code saving the values (word0 = results(0), word1 = results(1), etc) I get a "script out of range" message as the...

I have a form in Access 95 which contains text boxes and combo boxes. After saving, and adding a new record, I would like to carry some of the values over for the next record. Using; Const cquote = """" Me.Text10.DefaultValue = cquote & Me!Text10.Value & cquote works...