Not sure where to post this. I have a database for making occasional reports. The first report of this year is numbered RPT-05-01, the second RPT-05-02, etc....

If I populate a form using a query result, does that preclude me from editing the data that is shown in that form?

Hi, I am new to forms and macro's etc so apologies in advance if there is a simple solution to this. I have a basic requirement where a form shows a related...

how can i limit a certain number of records on my subform

I am building the criteria for a query on the fly using a form which has 3 elements: 1. 2 check boxes to determine which of 1 or 2 additional fields are...

I have an attendance form with a list of employees, a check box (checked if presemt) and a comment text box. A command button on the form appends records to...

Is it possible to have the first row of a table show the "blank record line" instead of the first record. That way when people enter into that table they...

I have a customer database, with contact details as the main form, and orders as the subform (on a tab). The customer ID is the primary key, and link...

I have an Instructors form with two tabs. In one tab called Courses, I have a subform called sfrmInstructorCourses. Since an instructor can train many...

On my access form, I have a ListViewCtrl. Everything works including figuring out which row the user selected on. I can't figure out which column (i.e....

Hello everyone. I have a table called "Site List" with multiple fields, but only 2 fields called Site Status and FSM that I'm concerned with. I have created...

I have a table configured that the ID is indexed with no duplicates. However, I can input duplicate records via an input form. Can someone advise me how to...

Hi! I have a main form where I disable the wheel mouse (at form load time) using the latest code from Stephan Labans (downloaded yesterday). The main...

Hi folks I've been using Stephan Leban's Calendar and RTF control with great satisfaction. But just recently discovered what seems to be a bug... I have a...

I figured out how to show the data labels in a pivot chart and how to format them, but I don't see an option for moving the label in case of an overlap. Any...

A button on a form opens a modal dialog box by which the user makes a selection identifying the subform to load. Other data on the original form must be...

I have an Access 2000 database running under Win XP SP2 that uses a subform on the main data entry form. The subform is in an area with limited space so I'd...

I have two problems that are probably related. I have just gotten my own Access DB software. When I try and use the Date() function (or just Date) in VB...

Asking for help in an Access newsgroup and complaining about it will not buy you a lot of friends, and may cause some posters to ignore your question. And,...

How would I write a function or a module to tell a month that is displayed in the table as a number to display on the graph as abbreviations such as Oct, Nov,...