I've got a design problem (at least I think it is) that I'm hoping someone can give me some guidance on. Say I've got a database I'm using to tracking some...

Hi, I'm doing research on "getting ideas" for a Balanced Scorecard. Does anyone know if there is an Access "tool" out there that might do some of the stuff a...

O.K. I have two tables LOT and SUBLOT. I want to sum all of the 'QtyDispersed' records over several sublots to subtract from the LOT 'OriginalQty'. However,...

I am setting up a billing database that will connect to an invoice table and an inventory table. What I would like is the ability to add / modify and invoice...

I trying to know the name of database user entered new record in table orders. ( FIELDS: OrderID,User,Date,ordertext) When I use =CurrentUser() as control...

I have a relationship database. I need to add fields for entering Remarks on a form where entries are made for "Remarks", "Date Remarks Entered" and "Assigned...

I have created a custom menubar and have added about 7 menus to the bar. Under each menu I have several commands. The file menu that I have created looses the...

Hello, I have several buttons on a main for which allow users to view information in subforms. If the main form record has information in it then the data...

I've updated the formatting properties in one of my tables to always display uppercase letters. Is there an easy way to automatically update those fields in...

I have created a contacts DB that separate tables for individuals, organisations and categories. The individual's form displays their contact information, plus...

What is the simplest way to require that two form controls have non-empty values for new records? I can't do this in the table, because the data is being...

In Access 2002 I have a form with a text box for entry of a parameter value and two subforms that have their recordsource set to queries with the parameter...

In a text box I want a large single page contract style text to always be the default when the user starts a new record. This text is usually modified. I...

Hi I built a form with a sub-form who took its records in a table. That table have relations with others, with cascading deletions. The deletion of a record in...

Hi guys, I have been trying to figure out the best practices for clearing a form that already has the record ID autokey entered (want to keep this) I found...

I hope someone can help!! Using Access 2002 in an XP Prof environment I can build a form in design view and when clicking to "view" the entire form is blank -...

One of my forms uses an unbound subform. I use the Form_Current event of the form to set the RecordSource of the subform (thus binding the subform to a query)....

I have 3 different forms ( frmclaimTechnical, frmclaimMedical,frmClaimLegal). Each of them has subform (ordersChronology) in datasheet wiew. The link between...

Hi, I'm writing a database that is used for military vehicle installation. I use a combo box to display the different types of vehicles, and once I select...

I have a form with a subform based on the query. To add items to subform new form is opened where data is added from the list box. On closing of new...