Search results

Append Great suggestion. Why didn't I think of that! :)

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

Error on Execute Update Statement Thanks for the suggestion, but I have to store this as text becaue I am first importing the values as text from a spreadsheet and I get an error if I try to input in to the table with a numeric value. Is there an easier way to add the value to the table/query...

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 & "'")...

Date Compare Issue 2006 & 2007 I changed the format of the date fields to DATE in the table and in the code and then I remembered why I stored them as text: I am doing a compare in an insert statement and I get a data type missmatch message when using a date format: ****************...

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.

form resizer Jamie Czernik developed a module that works pretty good. See below link (it is freeware): http://www.jamiessoftware.tk/ http://www.dirfile.com/publisher/jamie-czernik.html One suggestion is that it works best if you have a moderate screen resolution. If you are changing...

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

Kick out users I struggled with this for a long time and then I found Tony Lebans front end loader (http://www.granite.ab.ca/access/autofe.htm). Basically this is a tool that will allow you distribute the database on a network drive (in whole or split) but the users run it on their own pc and...

report pointing to query Are all the fields in the report pointing to the same query? If they are, you can go to design view of the report and open the report property box (not the section property box). Go to the Data or All tab and put your query in the Record Source field. If you need to...

report font You can select multiple objects on your report (text boxes, labels, etc) by going to design view, left clicking and dragging your mouse across any or all objects or by clicking on each object with the shift button down. With the properties box open, you can change any properties...

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