I'm building an application that will need to track Invoices (Receivables) and Payments, and rather than reinvent a widely-used wheel from scratch, I'm looking...

Hello, I have an Access '97 database with a bad table that crashes Access everytime I try to do anything to it. Well, now I just want to delete the table but...

Is there a way to get an append query to take all paste errors encountered during its operation and move them to a table of user(my) specification, rather than...

I have a large database (approx 900,000 records) with 95 fields. When the database was originally created there was no Header Record, so all the fields are...

Iam creating a mulitiuser Database where all the users are entering Data. I am not able to get the inforamtion entered to be saved on a common table.\ For...

Greetings from Canada. This may sound like a stupid question. Is it possible to enforce referential integrity between tables stored in two separate Access MDB...

I have a 3-tier One-To-Many table structure. tblOrganization: OrganizationID (Autonumber) Organization (Text) tblBranch: BranchID...

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

Hi all I want to be able to link tables in Access 2000 using the on load event of my frmLink. The databases I want to link are on our network on a shared...

Hello, Is there a function in Microsoft Access 2000 that can automatically email reports based apon dates in the table. I created a database that tracks...

I am new at creating an Access 2000 database from scratch. I am trying to make 3 fields be entered in in caps only. I have looked at many of the postings and...

In order to facilitate the export of data to Excel, I will be creating tables, appending data to these tables, exporting to Excel and then killing the tables. ...

I am using a textbox, but there is a limit of 255 for the field size. The question I have is there anything I can do to make the field size unlimited or at...

I have a table that has 10 characters in a "part" field. There could only be 7 or 6 (variable) characters that are actual, usable data. I have a form where a...

Hello all Is it possible to print out the relationships window. I'm using A2K, and the printer icon on the relationships window is grayed out and there is no...

I am a new use to Access...I created a table with several fields and several sub tables based on those fields. When I add records to my original table, how is...

I have a design problem that has me stuck. I'm modifying a system. It currently supports internal clients who are retrieved from a userdirectory table. This...

I have a Combo Box based on a look up table for a percentage field. The percentage field has been set up as follows: Field Name: Percent Data Type: ...

I am using Duane Hookum's At Your Survey Report. I was wondering if anyone out there has used this program and figured out a way to generate a "statistics w/...

I am using Duane Hookom's At Your Survey software to set up a survey for my church. I have finally succeeded in deleting the sample surveys included with the...