My office installed MS Access 2007 recently. I have designed a contact database and have a simple table. I want to add an attachment. I went through MS...

My database has been split. I used JStreet Access Relinker to set up the linkage. I now want to add a URl (hyperlink) field to the Back End Contacts table so...

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

Hello there! I'm having an issue with access 2000. I'm trying to make one form where I can select from different tables from list boxes, and then have my...

I have 3 tables (Models, Check Items & Parts) Models Table has fields; , , (e.g. 120 records) Check Items table has; , , (e.g 40 records) Parts Table has;...

Hi I am designing a classical music database and am a bit stuck on how to manage the movements of a work. I have a table Work (primary key WorkID and linked...

Re-posting in the correct sub-section. I originally posted in "Queries" where it obviously shouldn't be. I'm not a serial-poster, honestly (:o). I need to...

Hi, I’m using Access via XP Access Pro running in XP Pro with SP3. Please note that this question was posted in both the Database design and Form coding...

Created a subform on a tab. When I change back to form view the fields do not appear. It is a blank box.

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...

I have the following tables and keys and am seeking a way to easily populate Table 2 with values from Table 1. Table 1: PK1, PK2, F1, F2, ... Table 2: ...

I'm completely confused about relationships between tables. Bassically, I have 4 types of transactions made by the same group of people. However, not every...

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.

Every time I try and send a msge with an attachment, it won't work. I get an error 'the operation timed out waiting for a report from the sending...

On 27 June I posted asking for advice on why a query would be running very slowly and yet at the same time, not troubling the CPU greatly. I still don't know...

Can someone help? I'm being asked to create a training database. There are 129 employees and 14 sets of work instructions. One set has 208...

I have a problem with a combo box on a form which is bound to a query. I have used On Got Focus in the combo box to set values based on other fields in the...

Help, I need info on corrective action or cappa templates

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 am trying to repeat data from one record into other records. For example, I have created a table for ticket sales, where the ticket number is the primary...