Hello, I have worked with this problem for a couple of days and still cannot figure it out. I hope someone can help. I have a form that can be opened either...

I hope someone can help me please! I set up a report from two tables - "Staff Table" contains details of all staff within the company. "Courses Table"...

Hi there I am about ready to send the Access Database to a friend who's asked me to create a database for him. Since I don't know how his network is set up,...

I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with...

Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to...

I am just starting to build a table, i have a RefNo which must always be 10 numbers long, so I have set the field as numeric. Some of these RefNo's begin...

Thought I would give it one more try. How do I run a calculation that uses a field from 2 different tables? Table A - field, current Table 2 - field,...

That's because SQL Server uses single quotes, not doubles. Graham R Seach Microsoft Access MCP, MVP Sydney, Australia "HM" wrote in...

Is there a way, in a new Access 2007 database, to start the numbers of an Autonumber field at a number other than 1? It would be very convenient for us to...

We have an Access 2007 database in which we are happy with all of the settings, etc. Is there a way to create a new database with these same settings? ...

I'm looking for database to manage my stamps collection. I'm using Access 2003.

i have this DCOUNT formula on a text box which counts number of training sessions in my record. The text box is in my main form. =DCount("","Training...

Hi I need to print a record for an individual student. I have created a report that contains the same information as my form. I want to create a button on...

I have written a query to display a list of customers in my database (MS Access) When I ran the query the DBMS displays no records. I know there should be...

Hi I have several years experience with Excel VBA I'm hoping someone can give me a kick start with access VBA example code for the following simplified...

In setting up a application where clients master info is to be entered, would/should I have one frmDataEntry and another frmViewClientData, since the...

Newbie question: exactly which characters may be used in names of a) tables, forms, reports,...? b) mdb file names? TQ Becky

I am using the education template and I am trying to find out what a combo box is. I need a field on a table that can be added to. I have a student that...

If at all practical, stay away from hard coding report names and titles into labels on your form or into the field names of the underlying table. Businesses...

Does anyone know how to fix this problem? I am viewing records in the form view and I select a record that I want to delete. I click on the "Delete Record"...