Search:

Type: Posts; User: MatthewLane412; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: MS Access required field event procedure if another field contains a certain value

    Sorry for the delayed response. I have figured out this much. If I type in 'Contractors' into the control source box. The code works. If I use the normal control source which pulls from another table...
  2. Re: MS Access required field event procedure if another field contains a certain value

    No luck. Thanks for the attempt.
  3. MS Access required field event procedure if another field contains a certain value

    I am working on a split form in ms access. I would like my form to not add a record if the Sending_Category = Contractors or Salaries & Benefits, and the Sending_FTE is blank. I have tried this as an...
  4. Re: Formula showing in the cell but not the result.

    I had a similar issue. I found that deleting the apostrophe before the equal sign fixed it
  5. Replies
    7
    Views
    409

    Re: extract 10 digit number from cell

    The code worked wonderfully. Thank you very much.
  6. Replies
    7
    Views
    409

    extract 10 digit number from cell

    In my excel file I have column AK. Each cell is filled with strings. These strings contain numeric and non numeric information. An example of a string is "house 7410145689 October 2018". The stings...
  7. Re: Excel VBA InStr Function to delete string of text within a cell

    Scott, this code worked perfect. Thank you again
  8. Re: Excel VBA InStr Function to delete string of text within a cell

    You are correct. The number after TUR is always 8 digits. When I run the code I get the following error. "Run-time error '1004': Unable to get the Replace property of the worksheet function class....
  9. Excel VBA InStr Function to delete string of text within a cell

    I have a strings of text similar to the following (4010059877-TUR36036133 or TUR603916## 401007329) in column "AK".I need to Eliminate the TUR######## which can be at any point in the cell and has a...
  10. Re: Remove Characters after certain # of characters reached

    Took me directly to column AK. Thanks for the tip.

    Matt
  11. Remove Characters after certain # of characters reached

    Hello,

    I am trying to remove all character in column AK that exceed 14 character in length. I found some code online which works for column A only. I have been working on trying to get it to work...
  12. Replies
    3
    Views
    185

    Re: Conditional Formatting

    That was a typo. it should have been Mar. I Use Hyperion at work so all our months are abbreviated.

    the code I have come up with, with some help, isn't doing the trick. the code takes and I set...
  13. Replies
    3
    Views
    185

    Conditional Formatting

    Hello, I have a workbook with 2 sheets, sheet one has column I. Column I is filled with Percent's.

    Sheet has cell B2 filled in with one of the following "Jan, Feb, March, Apr, Jun, Jul, Aug, Sep,...
  14. Filtering Data for specific #'s - Code works in VBA screen but not using a "button"

    Hello,

    I have a spreadsheet that I need to filer for a specific set of #'s each time. The code works great when I run the Macro from the VBA Screen, but I am unable to get it to work using a...
  15. Replies
    0
    Views
    56

    Graphing macros data selection

    Hello,

    Hoping someone can help me with this dilemma.

    I have an annual project that needs to have 19 graphs updated with new information. This graph will keep the original data from the start...
  16. Replies
    5
    Views
    247

    Re: Countifs

    This worked perfect once I remembered to use the "text to Columns" function. Thank you very much for your time.

    Matt
  17. Replies
    5
    Views
    247

    Re: Countifs

    Thank you for the link. "Countifs" are exactly what I should have been doing. Unfortunately, I am still having trouble, trouble shooting this. When I use the code below, I come up with Zero. I'm...
  18. Replies
    5
    Views
    247

    Countif and If functions

    Hello,

    I'm trying to pull data from sheet 1 and insert it into a particular cell in sheet 3. This has worked perfectly however I need to lay down a set of limitations. If Column "I" contains...
  19. Replies
    3
    Views
    180

    Re: Do Until Loop + Then GoTo Skip

    Thank you both.

    Norie, I substituted your code for mine and everything works perfect.

    Matt
  20. Replies
    3
    Views
    180

    Do Until Loop + Then GoTo Skip

    Hello,

    I am still quiet new to VBA. I am working with a spreadsheet that requires me to Divide one column by another (eg. G2/F2, G3/F3, G4/F4...).
    I'm having trouble getting "Then GoTo" skip to...
Results 1 to 20 of 20