Getting Started

Access 2003 List of Tables & Fields
Does anyone know where I can get a spreadsheet that shows all the Sample Tables and the fields for each table? I could not find anything online help or MS website. I need to show the list of all available items to a computer illierate small business owner (auto repair) and he can understand it better if I hav... 23 Feb 2007 05:47

Expression to give total number of days between two dates
I am trying to write an expression that would give the total number of days between an "OfferSentDate" and "DateAccepted" for a metrics query. I simply don't remember how (if I ever did) to do this and help hasn't been much help! Suggestions would be very welcome. ... 23 Feb 2007 10:52

Another Newby Asking About an Excel Import
Greetings, We've been using Excel spreadsheets as a sort of electronic e-log for a few years. WE maintain five seperate files and combined we have about 60,000 rows (records). The five files were designed similarly. Basically, we have the operators log in with the word "sign-in" on a specific field which we us... 24 Feb 2007 07:25

howto vlookup onemore same value
howto vlookup onemore same value give more information about formula and excmble ... 22 Feb 2007 19:37

How do I access freedownloads to convert doc files to Windows XP?
I have Windows XP and someone has sent me a file that has .doc but I can not look at attachment, HELP? ... 22 Feb 2007 19:37

OnTimer function
I have a field that calculates a date that is 10 earlier than a due date for a report. I was wondering what an expression would look like that would alert the user with a dialog box or something that says "hey your report is due." The idea is when they open the form any time during the 10 days they will be ... 22 Feb 2007 19:37

dBase file
Hi As with most people who pose questions here, I am new to Access and require help to set up a new Database. I currently have a Database running in Approach with 1300+ records. This is perfectly serviceable but I wish to convert it to Access. Good News... I have managed to open my data as a db file in Acce... 22 Feb 2007 14:30

Convert Execl Spreadsheet to Access
Hi, I am really new to using MS Access so would appreciate any suggestions. have a purchase order spreadsheet in Excel with the following column headings Date, Name of User, PO Number, Org Code, Product, Cost, Comments I would like to convert this into Acess 2003 without having to retype all of it. Right now... 22 Feb 2007 14:30

Number of items on hand
I am trying to create a database (MS Access 2003) for work at a print shop. Here's what I want to do. Start with an initial inventory of paper types. paperA 1000 sheets, paperB 2000 sheets, etc. As each job is run, paper stock will be decreased. job101 paperA 100 sheets, job 102 paperB 50 sheets, job103 paperA... 22 Feb 2007 09:12

Access Message
I have a form linked to a table. If the user edits a record a field 'reasonsforedit' must be completed with a least 12 characters, before selecting the command button to save, print report & email report. All seems to work okay it gives the required message to complete data but it is then followed by an access... 22 Feb 2007 19:37