expression builder

  1. N

    Date Input Expression Builder

    Hello, I am trying to create an expression that will control a users date input in reference to a pervious field. This is what I currently have: [Field 1]<=[Field 2]<=[Field 3]<=[Field 4]<=[Field 5] Field 1 has an expression/Validation rule of: <=Now() Essentially, I want the first field to...
  2. D

    Conditional Formatting in Access Form

    Hi Everyone, I've got a DB that's setup to show a list of our all sub-contractors that we use. The main goal is to show details of each subbie and if they meet the approval criteria or not. This way our contracts team only place orders with approved subbies. The main field is the 'Approval'...
  3. F

    DLookUp for textbox control source to pull from another query

    Hello, I have been all over the web and keep seeing the same examples on how to do this, but for some reason, I can't get it work for me. I have a form called "frm_Metals_JobDetails" it is bound to a query called: qry_MetalsJobsActive There is one textbox on the form that I want pull data...
  4. H

    Access adding dsum to a form. Dsum inquiry about +/- values.

    Little out of my wheel house, would appreciate being pointed in the right direction on how to get the desired results. I have a form where I need to add the value for credits and subtract the ones for billing. Consumed would be the amount of the (+)credit[static] or (-)Billing[dynamic]. The...
  5. J

    Expression builder escape character?

    I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand. Everytime the form is loaded the text box evaluates the ampersand and so it disappears. C:\J&B changes to C:\JB and so the subsequent code doesn't run. Is there a way to escape the...
  6. A

    Update query- Access 2010 Win7

    Hello, I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where...
  7. M

    Expression Builder Help in Access

    Hi all, I was wondering if I can build an expression which will show either "Exceeds", "Meets" or "Does not Meet" depending on the number in another field. I have used the iif function, can I nest multiple functions in an expression to do this. Eg if [occurances] is 0, "Exceeds" but if...
  8. S

    Text Message in Access form when tabbing through

    I want to create an event procedure in ACCESS under 'Events' to display a message on a form when the user gets to a certain field by tabbing. 1. Would 'On Got Focus' be the correct item to use? I tried in Code Builder to add the following text in the On Got Focus for the Check Box, but when I...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back