Thanks all for the advice in a Open Report with current Record thread. Instead of highjacking that one I decided to start a new one for help with a related...

Hi, I have this query SELECT tblPst.Field2 FROM.... WHERE (((tblPst.Date) Between And )) GROUP BY tblPst.Field2 ORDER BY tblPst.Field2,

Hi MS Access 2003 SP2 After I did some refactoring of the subform code, the subform just would not load. In fact, it skips the subform without any error,...

Hi Is it possible to identify individual fields changed by a user during editing on a form before or immediately after the form is saved? Thanks Regards

I have a custom menu bar that I have been using for some time. I added the icons for sort ascending and sort descending on the bar and they worked whenever...

I have a form called Opportunities that has a Subform called Funding. I originally set up the link between the two on the "Title" field name. Then I found...

I have a report that lists all the courses and their descriptions for a term. If a course is marked as a GenEd course( = -1), the course description will...

Hi, I am getting a compile error - user defined type not defined. The VB code lists Private Sub cmdReport Click() Dim qdf as DAO.QueryDef The Dim qdf as...

Hi, I have a form which has 2 command buttons, they run 2 different macros to display results on the form. The queries in the marcos require date range input,...

I have a search from that has code in the form,open event to hide the detail section Private Sub Form_Open(Cancel As Integer) Me.Detail.Visible =...

I have a report that needs to print as follows: Header of PAGE 1 FRONT of Paper Customer Name Customer ID IN COLUMN FORMAT 2 to a page

I am using Access 2003 on Windows XP. I have created a document storage database with approximately 15 fields per record. One of the fields is a hyperlink...

Hi all, I have a database of 200+ students. Most of their details are shown on their main form. However I also need to show within this form the details of...

I have a main form that contains general details about a PO with a subform that contains detailed information about activities associated with that PO. My...

Is it better to use a single table and have one of the fields (for the form) lookup via a combo a state for example or; use a query for the form and then link...

Hi Clive, I see you and I have a question with no response. Perhaps I can help you. Functions is module are usually place their if the are either 1. Global...

Hi, I have the following code for combo box on entry form: Private Sub ContactNameCombo_NotInList(NewData As String, Response As Integer) On Error GoTo...

On a form I have a combo box that uses a lookup list to display values. The row source type for the combo box is a query. I need to "Limit to List". I...

I have recorded the following macro from Excel, and wish to run it from a button on a form. could someone please show me how to convert the code so i can use...

How do i make a subform only visible when the contents of a field on the main form has a valid entry (ie is not blank). I do not wish the sub form to be...