I have some forms in Access that have quite a few dates to be entered on them. The information is not always entered in a particular order, so the end users will skip around the form by clicking on the field to enter. They are asking me if I can fix it so that when they click on a date field, the cursor...

I use the attached code to successfully email a hard-coded report as an adobe .pdf attachment. I need to modify it so it gets the name of different reports from an option group on the same form as the email control button. For some reason the attached code only works when the report name is hard-coded...

Dear Experts, I have a access database, I use ASP page to run some queries, but I want to run the queries on Access how can create a page in Access and run the queries on that page? for excample, there are some colloumn name city, age, gender etc.. I want to select the data that I want with a form or...

I have a combo box that lists a bunch of descriptions of products. Limit to list is set to No. So they can either pick something from the drop down or type something in. If they type something in (and it's not in the list), then I want to do the following: Make visible a listbox (that's hidden...

If I get into the attached error handling code and the recordset rst was never opened, i.e. when the code executes the line "rst.close", it jumps to the line "Err_CalculateTotal:". Thus I continue to get error message #91, "Object Variable or With Block Not Set". How can...

In tblPreferences there is field labeled lngTheTableForMyFormID. This field is also the Primary Key for the table that is the RecordSource for frmMyForm, tblTheTableForMyForm. How do I get frmMyForm to open up to the record number listed in field lngTheTableForMyFormID of tblPreferences?

I have a form that I've been using for months. I am making some changes to it, the most significant is that I no longer have it bound. Now I am getting an error message that it cannot apply Dirty. I guess I am trying to understand why/how these are related (the dirty error message and the fact that...

This is hopefully a quick 500 points for someone - in an MS Access form, we have a date/time field. The default value is today at 9:00 AM. People go into the field and then manually will enter a new date and then tab out of the field. If they have NOT entered a time, we want to time to default to 9:00...

I have a form with a subform. I can tab into the subform but not out of the subform. Is there a way to do this?

I'm trying to display the Status on a form based on the most recent [StatusHistoryDateStamp] field. I have a parent form "frmOrders" (based on tblOrders) and a subform "SubFormOrderStatus" (based on the tblOrderStatusHistory table) lkpOrderStatusState ------------------------...