Search results

Some of my users are experiencing an issue with the TransferSpreadsheet function. I have a form that they use to import a spreadsheet into an existing table. The header of the spreadsheet doesn't always match the names in the table, but the columns are always in the right order. The total...

I have been searching for an answer to this, but no luck. Has anyone ever seen the below error when loading an Access 2003 database? "[database name] has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to...

I am getting the error "Too Few Parameters. Expected 1." when running the following Execute: ' Add Offer Numbers to tblWIP Set dbOfferNumberAdd = CurrentDb dbOfferNumberAdd.Execute ("UPDATE qryWIP SET [OfferNumber] = '" & strOfferNumberAdd & "' WHERE [OfferDescription] = '" & strOffer & "'")...

I don't know if anyone else has had this problem when changing from one year to the next, but I haven't found any postings regarding date compare issues. I have a two-fold problem: 1. I have a combo box that lists available dates from a table in Descending order so the most recent date is on...

Does anyone know how complicated would it be too allow the user to key in the first couple letters of the last name in the combo box & have the combo box prompt names that begin with those letters? I thought I did this before, but I can't figure out how. I would appreciate any advice.

I would like to create a series of help fields for various text boxes on a form to free up space that is currently displayed in several labels. Does anyone have an example that will allow me to create several help field icons on a form. Clicking on each individual icon will display a help...

I have an odd situation that I can't seem to figure out. I have Access reports that are broken up into several sections including a header and a footer. I use a force new page before one of the section breaks to create a duplicate copy with certain fields different in the copy to distinguish...