Recent content by wiremonkey22

Just in case anyone was curious i found the solution here: http://www.eggheadcafe.com/software/aspnet/31834078/make-text-boxes-the-same-height.aspx :cool:

I have it in the Detail format event like this, these fields are pulled from a query. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.CodeNumber.Height = Me.TASK_REF.Height End Sub I currently only have the TASK_REF property set to can grow/shrink i want the other...

I have a report with 6 fields in a row, i only want one of them to grow or shrink depending on the amount of words in it. What i need is the other fields in the detail section to match the height of that one field. I have tried to set the height property (me.fieldA.height = me.fieldB.height)...

First or Second Example:

Im assuming you want some thing like this: 01 John 72" 01 John 160lb 01 John 32" 02 Bill etc.... or 01 John 72" I used dots because the post messed up the spacing ...........160lb ...........32" 02 Bill etc...... Not sure if this can be accomplished with a query i rarly use SQL but...

I sent you a private message with my email info be easier to walk through it that way.

The first part is a little confusing. Explain the process that needs to happen step by step for me including what the user will do.

First of all i only used the And because there were two radio frames, here you use only one Checkbox so the And isnt necessary. Also check boxes evaluate to either -1 or 0 or you can use true or false in this case. If Me.Check92 = True Then 'What happens if the box is checked'

Can you attach the db?

Look up the docmd.SendObject function it works well with Outlook not sure about any thing else.

On part two I used the following code to hide the txt box when the options were yes and unhide when no. Private Sub Frame77_BeforeUpdate(Cancel As Integer) If Me.Frame77 = 1 And Me.Frame93 = 1 Then Me.Text88.Visible = False Else Me.Text88.Visible = True End If End Sub Private Sub...

I would say take a look at the Weekday function something like select case Weekday(yourField) case 1 'sunday' case 2 'monday' etc......... http://www.csidata.com/custserv/onlinehelp/VBSdocs/vbs220.htm Just an idea.:cool:

You can use some if .. then.. else....statements or select case like cannot leave blank if isnull(me.DateSubmitted) then 'do something here like a message box or undo set focus etc...' else 'do this' end if Greater less than if me.DateSubmitted > me.M11Qdate then 'do something here' else...

or right click combo box other tab tab index to 0

tab order 0 works good idea