I have a query which I need a bit of help with. I have written the query as follows:- Coloumn 1 Field: Expr1:!! Total: Group By Coloumn 2 Field: CL Code

Hi all If a user chooses an Activity of 'Toil' on my form I want a pop-up form to open displaying all available Toil Days for that user. The toil days are...

I am working with Access 2002. I have a database with a button on the Switchboard that opens a Word mail merge using an Access query for the data. It is...

Could I post something about Microsoft Windows 7?

Hello, Access 2007 mdb file Using DAO in VBA module of a form to query data from SQL Server and make a local table. I would like to display the data on a...

I want a few controls/text boxes to be visible only if the text box LOCATION consists the entry Branch. Following piece of code results into be working upon...

I have a form that has a button to run an "event Procedure" to preview a report, and to email the report as a pdf attachment. The codes I use are as...

Hi all I have a form based on a query called , it lists all Itineraries on the system. On this form you can filter records by specifying a Start and End...

Hello, I'm using MS Access 2007. I've made a form with a field for a number. This is needed to create an array. So I have an array from 1 to the number I put...

I'm working on an accident tracking database. Users input accident details on a form, which automatically assigns a case number based upon date & time. ...

If a new entry is inserted in a form (namely USERS) 's combobox (Which is based upon another table) I have the other table based form be opened, however,...

The Windows clock is not right. I have Windows Vista Professional. Answer me as soon as possible. Thanks.

I have used the above function, however was wondering if there is a way I can change what is returned? At times I get records 1 day 10 hours 4 minutes, and...

How can I shutdown a database after a 30 day trial period. A vb code to pop up a form to advise user of 30 day trial expiration. I can configure the form to...

I have Two Tables one table has a combo box with an tblEmployeeSalary. the other table I have is called tblSalaryHours. In tblEmployeeSalaries I have a combo...

I have data for records that can span between 1 to 16 months.. I want to be able to calculate the average activity for the most recent six months in a query...

We will be using windows 7 ultimate (x86 - 32bit), I was wondering can you make an ODBC connection to Access 2000 database. When we were using a trial...

"james hall" wrote in message news:... "locked vikas" locked wrote in message ...

I am using an event to send a report as a pdf attachment. However, I cannot figure out the to use. I have tried every possible configuration of "PDF...

I have been working with this database for several years. I now have an error that comes up "id is not an index in this table". I have tried making a new...