Search results

Originally I created the If then statement to just compare two set of values. cboOption has five different options. Two of options, if selected needs to be Nz(Me.Example1, 0) < & Nz(Me.Example2, 0), and the rest of the options are Nz(Me.Example1, 0) > & Nz(Me.Example2, 0). Thanks

I have two text boxes that compare values, one cannot be greater than other. Thats all. Nz(Me.Example1, 0) < Nz(Me.Example2, 0)

I am getting an Expected: = and it highlight the less than or greater than statement. What am I doing wrong? If Me.cboOption = "Plan 1" Or "Plan 2" Then Nz(Me.Example1, 0) < & Nz(Me.Example2, 0) Else Nz(Me.Example1, 0) > & Nz(Me.Example2, 0) End If Thank you

I am living with the way it sorts :) thank you everyone for helping me resolve this problem

June I used the report sort and group. Let me see if I can order by query now.

Awesome you are the best June7, thank you so much. I got everything to the top but now not it's not sorted by A-Z. Since it's sorting by ID number now. Any work around, I tried adding a second expression but nothing.

Thank you June7, and other problem why is blank rows showing as first? I want rows with information show to show first.

I have an continuous records in a report, and when I click print view in orders my list of inventory and random order. How do I order the list by A to Z?

The shape is called Singe Corner Rounded

In MS Access under "Format Design Tools" > select "Format" > then there is an option called "Change Shape." One of the shape is called "Singe Corner Rounded." The rounder corner is on the top right, I would like to change the rounded corner to the top left.

I have a single corner rounded shape, but its only in the right side. How do I change the corner to the left?

Thank you :)

I am receiving, I cant hide a control that has a focus. Private Sub cmdOpen_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) If Me.cmdOpen.Visible = True Then Me.cmdOpen.Visible = False Me.openGreenBtn.Visible = True End If End Sub Private Sub...

Thank you everyone.... fixed :)

Its kind of working now, is there anyway to stop the flicking when the mouse is not over button?

I am receiving no error, it just skipping that area. When the mouse is over the cmdOpen, it displays openGreenBtn. It does not switch back to cmdOpen, when moving the mouse off the button.

My code goes from starts with private sub, then go through Starts here If Me.cmdOpen.Visible = True Then Then goes here Me.cmdOpen.Visible = False Then here Me.openGreenBtn.Visible = True and skips.... this Else Me.cmdOpen.Visible = True Why is that? Private Sub...

Nothing is working

When I place my cursor into a procedure, I would like to debug and press F8. The Step Into does nothing, why is this?

Thank you, but it doesnt work. When I put my mouse over the image, it just goes blank.