I have a query which searches the database on surname and the results appear in datasheet view. I would like the results to appear in a form instead in the...

i need create more than 5 rows conditional formattings,who can help me ? i know the access only support 5 conditional formatting ,but I need more. I can use...

I have a field that I would like to hide . I would like the field to only be seen if the text entered into field is BT. This way when the user puts in the...

A have a Password Form where the user select their name (from a table) and then input their password (from the same table) to open a form. In the form that...

I'm using a switchboard (customized w/ about 12 buttons per form) and instead of opening a report, I want to run some vba to open the report (setting it...

I am sure this is a basic question but being a beginner I have not found the right solution. I have a Journalist database with one form based on tblJournalist...

How can I delete a table and the criteria is based on the value of another table using query? Thanks.

Hi all, Below are some of the properties for my Combo box. Control Source: =! Row Source Type: Table/Query Row Source: tbl The problem is while running the...

Hi, is ther anyway i can use coed to display the total number of records in the table? many thanks in advance

I'm using Acess 2003. (new user). I have a data base of 200,000 names and addresses. I do a filter to get a subset of names so I can print labels JUST for that...

In a form i use: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.fielddate) Or IsNull(Me.field1) = True Then MsgBox "The fields are required",...

I posted this on the fromscoding board, but thought i'd put it here too.... I have code that works already, with the exception of a date range. In...

I have a form and subform based on 3 tables built using Form Wizard. The main form displays the 1st table info (50+ entries) and the subform info from the 2...

i have forms in Access that when i change to pivot vhart view i see the charts my only problem is trying to copy and paste the charts in pivot view into word...

Hi all I have Access202. I am trying to put a calendar control on a form. I have a table with name SystemDate only a field and only one record,...

I recently split a database into front-end and back-end but now when I drag an new field onto a form, I get only the field (without the label). Has anyone ever...

I have a data entry subform that has more fields horizontally than can appear on the screen. When I'm in the subform, I can tab through the fields and...

I am designing an access database to record statistical data on counselling sessions to be used by novice users. I want them to enter data in a form which has...

I am running WIN XP Pro and Office 2003 Pro I have I have a table with patients info. I created a query to create Name such as Joe J. Doe from the table's...

I have a multi-user access form used to collect data about projects worked on in our department. Since some projects are completed montly, we'd like to...