Forms

switch to split form from single form with code
My form opens in single form view and I would like to create a button to switch to split form view. Then I will create one to switch back. Help ... 21 May 2010 12:49

error 0
I get error 0 when I double click on the mdb file. I trap the error occur in my AutoExec. When I double click on AutoExec marco, but it does not have error. The error does not appear when I compact and repair database which will automatic run the mdb. The error does not appear when I debug line by line. Any s... 31 May 2010 00:06

Buttons for multiple subforms...?
Hello... I have a form where i have multiple subforms. The main subform is our client's contact information, and the subform I am trying to add a button for is for our call notes to log our call. The call log subform is linked to the customer contact info via customer number and displays the correct call not... 21 May 2010 18:23

Stephen Leban's Conditional Formatting
Hi All I am totally stumped at the moment with trying to use the Conditional Formatting classes written by Stephen. I am in the process of rewriting a database. Some of the functionality remains the same and is just getting a cosmetic tweak. In this instance I am trying to re- create a search result form which i... 24 May 2010 05:49

Filtering, RecordsetClone, Main Form - Subform Issues
My client has an Access database that was created in an earlier version of Access and they are now trying to use it with Access 2007. The main Customers form is not working right since changing versions. I can't figure out what's wrong with it. Can you please help me? The form has (5) tabs on it; Tab 1 ("Searc... 27 May 2010 17:04

Allen Browne’s Name table design
Hi, I'm on Access via Office XP Pro running on Windows 7. I'm working on a simplified version of Allen Browne's People / Name table design. I'm finally working on a church database. I did not implement the entire design. Instead, I implement a two tier table design. The first table is tblFamily and th... 28 May 2010 15:59

Column Orders
I design ad hoc report form that users use to create reports based on requirements. users are able to choose up to 10 fields in order of preference 1st, 2nd, 3rd, 4th, etc. the 10 combo boxes are in vertical position (1 field under the other). the combo boxes are unbound with a Row Source Type as Field List and... 21 May 2010 00:52

Check for null values before updating table from form
I have a form where the user must enter a value in at least 1 of 15 boxes. If all of the values are null then I do not want the record added to the table. Once the user is finished entering their information, they click a Submit button. Private Sub cmdSubmit_Click() If IsNull(countClaim) And IsNull(co... 20 May 2010 19:26

Display Name of Field from 1 form in an unbound box on another for
I have 2 forms, 1 that is used to enter data and 1 that is a giant number pad. If a person double clicks in one of the fields on the data entry form it will open the number pad form and they can use the number pad to enter the data. This process works great. However, I want to have an unbound box at the top ... 20 May 2010 23:47

Open Add Printer dialog...
In WinXP Pro with Office 2000, 2002, 2003, 2007, & 2010 the following works Shell "rundll32.exe printui.dll, PrintUIEntry /il", vbNormalFocus In Win7 Pro, Office 2007 it doesn't work and I get this error. Windows can't open Add Printer. Operation could not be completed (error 0x0000007e). tia Vanya ... 20 May 2010 18:19