Getting Started

Using Access and Excel
We are using a program written in excel. It accepts input and then calculates and produces a report. When it completes the information is deleted and the next data is input. My question is this: I would like to keep all the information that has been input in a database. Can this be done, how to go about this an... 18 Feb 2007 07:44

Range Query
I have a three column database; Option #, Option Price and Shares Outstanding. I want to create a query that will summerize the number of options outstanding by 5 price ranges; $.50 to $1.50, $1.51 to $2.50, etc. As a newbe I can create 5 separate queries to accomplish this but there must be an easier way. ... 17 Feb 2007 19:03

database help
i am building a website that requires a database and im wanting to know what software would be the best choice(s) for me? the database needs to consist of an accounts page, login, a page where they member can post some info, and the ability for someone to search the posted info i have basic access skills, a... 19 Feb 2007 02:59

Transfer data with a table
Hi, I have designed a db for home finances. Simple Spend/Recieve/Bills/Loans etc. I use two main tables: tblTransactionsParent and tblTransactions. The Parent table records the AccountID, date and misc notes while the Transactions table has the detail: spendamount, recieveamount, payee, category etc. (I use 2 ... 20 Feb 2007 01:36

Learning and Teaching Idea
Not sure if this will fly at all but thought I'd give this a shot. I'm teaching myself Access and just picked up a workshop registration project that will be a great learning experience. It addresses some basic relational database concepts which I'm struggling with but I thought it might also be a learning oppo... 18 Feb 2007 11:53

Excel & Access integration
Is it possible to set up a database switchboard so that I can generate an Excel file from a template, using a form to populate certain fields in the Excel document? I'm setting up a contact manangement database for a group and need to set up a form that the group leader can use to automatically generate the Exce... 20 Feb 2007 02:07

Need a report to be filtered to results of Search form
I've created a search form, based on code from Allen Browne's website, which returns a set of records based on criteria entered (or left blank) in five or six different fields. What is the best way to filter a report to print out the records selected by the search form (which I would obviously open from a com... 18 Feb 2007 11:22

Show N/A like default in combo box
Is it possible when opening an order entry form, to to show 'N/A" as a default in the combo boxes? I didn't see that option in the properties box. Thanks Ron ... 17 Feb 2007 14:21

Enter customer #, auto fill customer info?
Is there such a thing in MS Access 2003, that you have a form created, and you have a field called "Customer Number", the primary key in the Customer table, where when you fill that in, it automatically fills in the remainder of the customers information such as telephone and e-mail so long you have it somewher... 15 Feb 2007 17:45

Trouble Creating Tables
I'm trying to design a Access database from a Spreadsheet. An example of it is below. It's frozen at Column B and at Row 2. It can go on indefinite9As Far as Excel will go) in both directions, depending upon how much data is found. Column A contains the Company # for the Train Sets and the MCZ02, etc. beginnin... 23 Feb 2007 16:09