Hi there, I've created an online form where people (or rather school classes and youth groups) can register for an event we're organizing. They can indicate...

I have a parts table and a inventory table, I would like to be able to update the inventory table with the new part number when a new part number is added to...

hi there, i need major help for a new system i have to create. basically, my new system is a school booking system that allows teachers to book out laptops,...

i have chage the strat up properties in my data base(allow full menus, allow default shortcut menus,use access special key, allow built in toolbars, allow...

I'm using Office 2003 and Windows XP. It seems to me that data entry should be clearly separated from data edit, or editing records. I have done this by...

How do I keep the order of entries in a table in the order they were entered

We are building multiple databases for different purposes in the company and we are splitting each one of them with a front end and a back end. The front...

Can you tell me how I can creat a database of all the products that I sell linked to the image of the product and the respective price. for example: when in a...

when I link a .dbf file in ms access2000, I recieve a message "the microsoft jet database engine connot open the file '*****.dbf'. It is already...

I have four tables designed and three of them (CommodityTbl, PurchaseOrderTBL and TransactionTBL) show relationships and queries can be run without a...

In the query design toolbar I have Field, Table Sort, Show, Criteria and or opitions. I am missing the "Total" opition for grouping. Any suggestions....

I have created a database for products that i sell. I would like the Primary key to be a combination of the Category Id for that product and a...

i wonder where is "Table Wizard" in access 2007

I have several tables in my database with ID number as a common fiels for the customers. How can I make access fill in customer first and last...

Hello, Access newbie seeking expert advice. I have listed the fields I currently have in one table and would like to obtain advice on how to split out the...

I am completely new to Excel and have created a spreadsheet which background should have no fill. Unfortunately, part of the spreadsheet has a gray tone and...

Hello folks. I'm relatively new to MS Access and I'm having a Dickens of a time figuring out whether materialized views are supported in MS Access, or even...

I am setting up a database at work to record when 6 monthly questionnaires have been sent out. Is it possible to set up a reminder system that flags up when...

Is there a way to set\change the Format Property of a filed in table by SQL statement?

I have a need to have a parent table for ALL projects. The projects fall into four kinds (WRD-Municipal-Minnesota-Local). Each kind has its own set of...