Hello! I have a Query, with condition, to write one choosed parameter. When the "Enter Parameter Value" is open, is possible to have opened in simultaneous...

I have two questions: 1) When I create a new form using the wizard and select all the fields in one table, then select another table from the drop-down &...

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

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 3 different forms ( frmclaimTechnical, frmclaimMedical,frmClaimLegal). Each of them has subform (ordersChronology) in datasheet wiew. The link between...

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

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

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

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

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

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

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

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

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

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

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