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

This morning my form was working fine. However, after a few changes, I am not getting this error (2147352567) saying Recordset is not updateable when I...

How can I do this? thanks

Hi, I'm trying to create a form containing a Page Control (?) - the one with tabs, not sure if this is the name - and I want to add a different icon on the...

I had a subform on a form and it had been working for quite some time. It was a Purchase order which was place on the customers original form. For some...

I need to have a form which totals two fields on one table and one field on another table. There is no relationship to tie the tables, but these totals are...

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...

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 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...

I have a resource form. This form is used for inputing available resource information. It contains name, dept, discipline and availability by week 1 thru 15....