Is there any way of making a default value the last day of the month - the month being the next month on from the value in the previous record on the subform?

I have 2 Tables the tables have auto number fields 1. Purchase PurTransId (auto number) 2. Sales transId (auto number) they both start from 1

What are the system requirements for Access? Where can I download Access?

I have a people table and a linked events table that tracks inquiries, calls, etc. from each person. So if Mary Smith has been contacted five times and each...

Hello, I have used two controls on a form: MapiSession and MapiMessages to read the inbox of Outlook. On my computer it works fine but when I installed the...

I designed an application where I want to disable ability for users to modify any design elements; however, I want the users to be able to hide and...

I have a table with 3 columns: SUBJECT_KEY, TOPIC_KEY, FIELD_KEY, DTEXT . For example: SUBJECT_KEY TOPIC_KEY FIELD_KEY DTEXT 100 ...

I have been using "Can shrink" on text boxes in a report so that only those with data can be seen and thus eliminating blank pages. The problem is I also have...

i restored my system ,xp pro, and delete a user ,and now i cant open any office program as i am missing this file ,, help

Sally doesn't live here anymore, Nancy. -- Van T. Dinh MVP (Access) "nancy" wrote in...

Hi, I have an Access database which runs fine in an XP machine. But when I copy it to Windows 2000 machine, and open it with a Chinese version access, I got...

I'm trying to format a null table field to display zero. I've tried the () expression but have had no success.

To Anyone that can help, I would like to Sort a Table in a subform by clicking on one of the column headings in the table. If it is possble, please...

Hello! Could someone please tell me why this query does not show top 20 Products ordered by Hits? SELECT TOP 20 Id, ProductName, Hits FROM Products ORDER BY...

Within the VBE Editor of Access 2000/2002 and Word 2000/2002, my mouse wheel does not scroll. I have 2 different kinds of Logitech mice and a Microsoft...

All, I have 2 tables that have 2 fields in common. The fields are Admit Date and Record Number. I'm trying to isolate the records that don't match in either of...

In my database I keep getting a #Name? and it won't allow me to enter any information in it, I got it off once, but it keeps coming back and I can't seem to...

I am unable to open the report window for both designs and the report wizard. I have tried removing and re-installing Access but there seems to be no change. ...

A number of users here at the University of Plymouth have reported to me a problem regarding the font settings. It does not allow them to specify the default...

Can I change the default file type filter used on File Open? When a user chooses File Open, I want them to see only .MDBs. Currently they see .mdbs and other...