Search results

Group-ies controls that are grouped together to keep their relitive position to one another constant

Moving a Group with code I'm not sure that you can move a group since it is not a control and there is no way to identify it. You could place the controls on a sub-form and move the sub-form. If you set the border Special Effect to “Flat” and the border Color to “Transparent” and the “Detail”...

Still need help First, check to be sure that there isn’t other code that sets the forms “Visible” property to False. This would account for the ability to open the form through the DB window but not being able to see it when it’s opened from within the application. Use Edit | Find/Find Next...

Add a Field You could try setting the Default Value to your crosstab query and set the ControlSource to a field in the ParentIssuerList table named [Total Of Amount]

Using a Checkbox, you can't, but if you want to have the value of the checkbox (1 or 0) to show up in a report, Use the "Switch" function in the Format event. Switch (checkbox = 1, "Apples", checkbox =0, "Beans")

Fill from combo You can accomplish this by setting the RowSource for the combo box to include the data for fields that you want to populate. If you don’t want the users to see all the data in the combo box dropdown, set the width to ‘0’ for those fields. Then, on the ‘Click’ event of the comb...

If you mean that you want to group controls so that you can move them as a unit and if you are working in Access 2000 or XP all you need to do is select the controls to be grouped, go to FORMAT on the menu bar and select GROUP.

send object Thank you oh Ancient One. I might have caught this if i had put in error handling, but I'm just developing this and I tend to go back through the code and put in the error handling...maybe I should rethink my methodology. Thanks again.

Here is the code...what I'm not sure how to do is respond to canceling the e-mail. The system has its own error message but I would like to replace it and cancel the update event (Cancel = -1). Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strCIFRef As String Dim strCBRef As String Dim...

This might not do everything that you need, but it should get you started.

This might not do everything that you need, but it should get you started.

Using the DoCmd.SendObject method to open an e-mail in the Before Update event, how do I handle the canceling of sending the e-mail and still have the update event fire?:confused:

Sorry, I tried to send a .pdf. I've attached a .jpg this time

This might help. Check the Attachment

stumped I’ve run into this with Access 97. The easiest way that I’ve found to correct it is to remove the criteria from the query, copy and paste the query and reenter the criteria in the new query.

ComboBox This should do it for you… On the click event of the checkbox, select [Event Procedure] then , in code enter something like this: Private Sub CheckBox_Click() Dim strSQL As String Dim strSQL2 As String strSQL = "SELECT [NameOfField or Fields (separated with commas]FROM [NameOfTable...

Query Help Try using a gTotalsh query (the ‡” button on the menu bar). Set the Total: field to Count and the Criteria: field to >= 2

Usualy, the sub is related to the Parent so they will stay in Sync. How will the user know if the subFrom is not showing the right data? You could make the Navigation Buttons visible as a way to allow selecting rcords he needs to see. Or, You could try putting another subForm and nesting the...

A little more information, please. How are the Form and subForm related? Why is the Parent Form or subForm changing? Is the data in the subForm being changed by another user?

switch-a-roo You can use the “Switch Function”. Switch (1, “Yes”, 2, “No”, 3, “I don’t know”) It read like this…Switch (1 = Yes and 2 = No and 3 = I don’t know) Look under “Switch in the help files. :cool: