I am a new access user. I need to insert a hyperlink into a table. I am trying to find the correct spot to do this in design view, on the properties sheet....

Hello, Is there a 'best practice' when it comes to creating forms based on many different tables? Generally I try to use as few subforms as possible, using...

hi, im not sure if this the right category to ask but can anyone help me to accomplish, i have a table with a column name i set the format to combo box the...

I have two separate tables in Access that are both relevent to my Excel spreadsheet. Using a unique ID, I would like to match records from one table to...

Hello, Bad design, I know, but a customer wants to take what is currently field1, field2, field3, etc. and use this data in a drop down box. The table is a...

I have a question on normalizing tables that has come up several times. As an example: If I have ten pieces of equipment with ten guages and I want to record...

It's time I re-worked the Parts/Ordering/Book-In tables, as I've outgrown my original, I'm interested to hear opinions on how the table structures should be...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

hi, i just want to know how and where to write the DMax function? i have this table TblInvoice InvoiceID InvoiceNumber InvoiceDate

How do I set it up so that there is no referential integrity in a rtelationship of mine, but the related records in the 'many' table, will still delete if I...

I built a small database to track HOA information that included lot number, address info, plat numbers, maps, books, pages, dates etc. that had about 25-30...

Trying to design a database to record tenants, Date paid, Receipt Number, 7 income catagories (Rents, Damage Deposits, Credit Checks, Late Fees, Credit Bureau...

Try this test open any simple form and close again ,eventually MSAccess will bring up message not enough memory. eg try Northwind database opening categories...

i have created a table with all the necessary fields which I then created two forms, both including different data, apart from four fields which I want on both...

The help as well as the Microsoft website for MS ACCESS lists the syntax: CREATE TABLE... Yet, any attempt to use the "TEMPORARY" keyword leads to a syntax...

I am creating a multi-function database containing the following tables (key=agency): 1.AGENCY Headquarters Contact Info 2.with multiple SITES for each...

Hi all, Wonder how a table design for a menu system that can support unlimited amount of categories and subcategories would look like. That is a category can...

I have a table called Servers with a Primary key of Server_ID; a table called Modems with a primary key of Modem_ID, and a table called Server_HDD with...

I am currently in the process of designing a database whic is going to be used to record sales, I need some advice on the following. a) each user (Sales...

I need to have a table with 1.3 million records ( only one field table ). Can Access 97 holds that much of records? Thanks. - sl -- Thanks.