Dear All, In northwind database that comes with access 2003, how can I make a form for purchase / received inventory just like customer order, form for this...

Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it...

I have two different ODBC tables and as a result of a make table query I'm trying to change the Data Type on both tables to read "text". One table already...

I am using Access 2003 I have a table of nearly 10,000 records which I have transferred from Excel to Access. The table consists of contact names, company...

Office 2007, just upgraded from 2000 ( OMGOODNESS!! What a flippin' NIGHTMARE!!) I am simply trying to import a tab delimited text file into an existing...

This is a simple question. Yesterday I needed help with adding date, time and user to a textbox. Today I am wondering if there is a way to make the info skip...

It sounds like both Employee and Training are one to many with Completed Training However since you might want to tracj scheduled training (not yet complete)...

Here is my challenge. My work has a wretched almost unsearchable "database". I am trying to cobble together my own relational database from that...

I'd like to create a table that has two/three fields. 1) a description of what the linked file is and 2) the hyperlink to the file. I'll have one more field...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...

Existing I have the following table structure (in Excel) and now want to have better control by using ACCESS. SC no Buyer PC no Supplier...

I am setting up a job number database for my company. As of now the "database" is kept in a binder. It will soon be housed on our server. Yay! The most...

I'm creating a database of text fields. I expect some data to exceed 255 characters. What is the maximum field size of a text field? Can I increase the text...

Every now and then, some or all of the database objects that i have assigned to "custom groups" get unassigned and appear in the "unasgined objects" group....

I have been reading all about the evils of lookups in tables, however could someone please explain how you avoid using them - is the answer to have many tiny...

I want to add a child table to my table and using one of the primary key of the table. For example: MyTable is PKey1 PKey2 PKey3

I am a self-taught novice (the worst kind!) so am hoping I can get a nice simple answer to my question. First the history: I want to re-build a database...

I have created a couple of Dbs which the table structure seemed to simply fall into place, it was just logical in my head. That said, I am working on a new...

I have a table which holds the ID, DivisionID, Division term (ex: 2007-2009, 2009-2011), followed 10 fields (type = number) for the 10 officer positions. I...

I have posted a query on the subject but i don't remember the exact date. How to find our my query and know whether it is answered or not.