I have a query that retrieves a bunch of data from a table, including a date field. I have a form that displays the query results. On the form I have...

Is there any way I can require that a field have a non-null value in a form or query? I know how to do this in a table definition by setting the Required...

Hello---I am having trouble with defining decimal places in a form. I have set Properties box/format/decimalplaces to 2 and defined the format as...

I have a form that opens various reports. Have report set for On No Data, However the from shows message "Open report action was canceled. How can I make...

In Access, I've tried a number of times to create a command button on a form that when clicked opens a document in Word but I always get an error message...

I've got a form (frmShiftVariables) where I've got textboxes holding a number of values that I want kept for the duration of the session. The boxes were able...

Hey Everyone, Im creating a form in MS Access, where the user can enter certain values and the results will be returned in another form where they can edit...

hi how do can i stop a procedure? I have tried docmd.quit and close but neither work. I have setup a button in form which when pressed should stop the export...

How do I get a combo box to work in a form to do a search function of a table/query when the info is typed in?

Hi, I am trying to do a simple export to a .txt file from the results of a Query call "ExportDocES". I am doing this from the database window. When I run...

I have a form which has the Popup property set to Yes (one of a few forms that make up a small Access application). On this form there is a list box which...

I have created a simple database to track calls in my office. I am fairly new at databases and using Access 2000. I have a call_logging form I use to input...

The DB is being created in Access 2000 and is a First Aid trainer DB; each trainer has 1-6 roles and each role has many skills. I want to put the list boxes...

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

Using Access 97 - I need to try to get information in a current record, and succeeding records from one table, to update a separate 'summary record' in...

I have an "Audit Trail" database... the form track all previous data values in the "Updates" field. I need some help w/ customizing the VBA code so that NOT...

Hi, I have a form bound to a table 'Customers' with a combo box (cboCustomerName) for the CustomerName field and text boxes for the other fields in each...

Hello, I have a form which details a client's demographic information. i would like to be able to do this by creating a cmd button that would create an...

I am trying to create a parameter query that connects to a form that uses checkboxes as the method for selecting records of individuals based on the sports...

I have a form with tabs to collect product testing information. I need a way to collect additional data if changes to existing data are being made. I can't set...