Recent content by david.allan.johnson@redsa

  1. D

    Call Command_Click

    T That worked!!! Thanks : )
  2. D

    Call Command_Click

    I tried calling the command button directly, but it doesn't work.
  3. D

    Call Command_Click

    Can someone advice me on how to run the Command405_Click button that's on the (Parent form) from the (child Subform) using a Command330 button?
  4. D

    Date and Time Format

    That worked :). Thanks so much. You're a genius!
  5. D

    Date and Time Format

    Ok, thanks. I'll try that.
  6. D

    Date and Time Format

    I tried Format(Date, "mm/dd/yy") and I'm still getting a 12/19/2024. Should I enter the format in my query?
  7. D

    Date and Time Format

    As a start, I tried MeetingStartDate = Format([MeetingStartDate], "mm/dd/yy") , but it still displays a 4 digit year. Any ideas?
  8. D

    Date and Time Format

    Thanks
  9. D

    Date and Time Format

    I have a Date text box that will display the date in the following format 12/18/2024 5:00:00 PM. Is there away to remove the 2 digit seconds numbers and add text within the string? For example, I would like it to be in the following format: 12/18/2024 at 5:00 PM. Thanks,
  10. D

    Solved Format a 10 digit character text box using Access VBA

    Yes, I copied and pasted from a webpage a phone number. The problem was that the webpage wasn't consistent and there was different characters in the phone number. For ex. sometimes there were () , - and other times there were -. Just wasn't consistent at all. I created a module that extracted...
  11. D

    Solved Format a 10 digit character text box using Access VBA

    No, I haven't. Not quite sure how I would set that up. I have a field called officeNum that I'm going to past my 10 digits in. Then I would like to format that 10 digits as (123) 456-7890.
  12. D

    Solved Format a 10 digit character text box using Access VBA

    Hello, I have a module that goes through a series of characters and removes any characters other than 0,1,2,3,4,5,6,7,8, or 9 , and it's attached to the After Update Event. Is there away to format the series of numbers, after they're filtered, in a certain formation. For ex. after the...
Back
Top Bottom