Search results

I am using Access 2007 and cannot get a form to center, even after trying the following: 1. Overlapping windows is selected 2. Form Properties AutoCenter: Yes AutoResize: Yes 3. In the "OnLoad" Event, tried: DoCmd.Restore Me.Move 0,0,5000,5000 Regardless, it always opens in the bottom left...

Hello. I have a form (Frm1) with a subform (Subfrm1). Both Frm1 and Subfrm1 have tabs. When I select a tab in the subform, I would like to write VBA code to select a specific tab on the main form. So, In Frm1, I have TabCtl10 with Page11 and Page12. In Subfrm1, I have TabCtl20 with Page21...

When a button is clicked in a form that adds a new record, an email is sent to 3 users containing the record information. The email format is set up in VBA. This worked great before we converted to Office 2007. Now, it seems to work for everyone but me. The new record is saved, but the email...

Hello: I would like to print up to 8 records across a page, instead of down. I've tried a Crosstab query, but I don't think that is going to work because I'm not doing any type of math on the records and I want multiple row headings. I would like the report to look like the below, which...

I have a replicated database in Access 2003 w/ SP2. A coworker in another location controls the master database. We have the following references selected in VBA (listed in order): VBA, Microsoft Access 11.0 Object Library, OLE Automation, Microsoft DAO 3.6 Object Library, Microsoft ADO 2.8...

I have a form based on a select query (query does calculations as well). The query pulls from 2 linked tables, and it's not allowing me to add new records. On the form properties, I have "allow additions, allow deletions, allow edits, and data entry" set to yes. I've tried adding code to go...

Hello: I have read the Microsoft article at http://support.microsoft.com/kb/q95918/ several times. However, I am looking for an expression I can place in the field name to calcluate the median of another field in the same query. Is this possible? If not, I don't understand how to call the...

Hello. I want to hide the scollbars on a subform. I selected "neither" for scroll bars under properties, and it works. However, the formatting is ugly. I have a blue background but get grey boxes where the scroll bars are supposed to be. Can I get rid of this and have the area blend in with...

Hello. I am performing update and delete queries and don't want the user to see the alert messages indicating fields are about to be changed / deleted. I've tried using the SetWarnings command, but the alerts still appear. Any ideas? My current code is below. Thanks in advance dcnick...

Hello. I am setting up a button on a form to delete all records from a table and refresh the form. I have set up a delete query to do so. If I run the query by itself, it deletes all records in the table as intended. However, if I call the query from the form, it deletes all but one record...

I am trying to use a combo box to store a value in a table from a form. The combo box shows the following: Plan # Plan Description I used the combo box wizard to store Plan Description in my table tblPlan.PlanDescription, and I set Bound Column to 1. However, it stores Plan # instead of Plan...