Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: Query with time

    by JeanM
    Replies
    7
    Views
    560

    Hi My mistake it should be 10:59 am--how do I...

    Hi

    My mistake it should be 10:59 am--how do I fix that? Is there a way to make the date option entered in by the user?

    Can I type this on the criteria line in a query?

    Jean
  2. Thread: Query with time

    by JeanM
    Replies
    7
    Views
    560

    Query with time

    Hi

    I have a report that I want only transactions that were entered from 11:01 am to 10:29 am. The results of this time span could result in two days. The table has a field named "Date Entered"...
  3. Replies
    1
    Views
    151

    Mail App Not Working in Windows 2010

    Hi

    I upgraded to Windows 10 and I cannot get the Mail app to work. During setup it found my email address and setup up an account for Outlook with the server blu405-m.hotmail.com. I synced the...
  4. Replies
    13
    Views
    901

    Hi Maud Thank you very much for all the help. ...

    Hi Maud

    Thank you very much for all the help. I will try to be more thorough in the future.

    Jean
  5. Replies
    13
    Views
    901

    Hi Maud I finally figured out what I was doing...

    Hi Maud

    I finally figured out what I was doing wrong and I am getting the text to extract correctly except I have the same issue when the town has two names such as NEW HAVEN.

    Jean
  6. Replies
    13
    Views
    901

    Hi Maud I must be doing something wrong. In...

    Hi Maud

    I must be doing something wrong. In cell B2, I entered =UcaseTxt(A2) and I get #NAME?

    Jean
  7. Replies
    13
    Views
    901

    Extracting text

    Hi Zeddy

    This works great until it gets to a town with two names--such as OLD SAYBROOK. Egads!

    Jean
  8. Replies
    13
    Views
    901

    Hi Maud The text to be extracted will always...

    Hi Maud

    The text to be extracted will always follow a "\". I do not want any other text that are in uppercase letters. The string where I want the uppercase text will always follow after the...
  9. Replies
    13
    Views
    901

    Extracting uppercase text from a string

    Hi

    I found the following code but I do not know how to edit the pattern to get what I need.
    The string could look like the following:
    D:\test1and2\BERLIN - TCNY-F-Paid-JM.xlsm...
  10. Replies
    18
    Views
    2,158

    Hi Zeddy Wow! That works really nice. I have...

    Hi Zeddy

    Wow! That works really nice. I have two suggestion: make the button in Step 1 larger--I almost didn't see it--I guess I shouldn't test things when I am tired. My other suggestion is I...
  11. Replies
    18
    Views
    2,158

    Hi RG This is exactly what I was looking...

    Hi RG

    This is exactly what I was looking for--hard to believe it got that complicated. The tab name is not important. Searching this topic under importing was not helpful--I tried move/copy and...
  12. Replies
    18
    Views
    2,158

    Hi RG So sorry about that. The password is...

    Hi RG

    So sorry about that. The password is HWSDUI.

    Jean
  13. Replies
    18
    Views
    2,158

    Import Button with Code

    Hi

    Attached are two workbooks. The Master workbook has a button without any code. I want the button to allow the user to open a workbook from a directory/folder. For this example the user...
  14. Replies
    18
    Views
    2,158

    Hi RG Can I attach my workbooks--because I am...

    Hi RG

    Can I attach my workbooks--because I am getting confused--and you can see more clearly what I am trying to do?

    Jean
  15. Replies
    18
    Views
    2,158

    Selecting Filenames & Directories

    Hi RG

    Thank you for the code to select filenames and & directories but I need to have the workbook sheets appear in another workbook that will be open at the time when the user chooses from the...
  16. Replies
    18
    Views
    2,158

    Hi Maud 1. I want the user to be able to pick...

    Hi Maud

    1. I want the user to be able to pick the workbook within the folder.
    2. The workbooks should all be xlsm but maybe I should have xlsx available too.
    3. Each workbook could have one...
  17. Replies
    18
    Views
    2,158

    Import Button with Code

    Hi Maud

    I think I need to start over. This is what I wanted to accomplish:
    I have a workbook--DDHVE.xlsm.
    I have a button that will allow me to chose a directory and import another or several...
  18. Replies
    18
    Views
    2,158

    Button with import code

    Hi

    I have the following code on a button and it is not recognizing any excel workbooks in the directory where they reside. My goal is to have the user pick the workbooks they want to import.
    ...
  19. Replies
    3
    Views
    268

    Hi I actually got it to work. It took forever...

    Hi

    I actually got it to work. It took forever to show up in my email and I have the workbook with just the sheets I wanted. Sorry that I was not more patient with my email delivery.

    Jean
  20. Replies
    3
    Views
    268

    E-mail code in Excel

    Hi

    I have the following code where I attach one sheet of a workbook but now I need to adjust the code to attach several sheets. The sheets all begin with ChkptTS--example ChkptTS1, ChkptTS2,...
  21. Replies
    26
    Views
    2,759

    Hi RG Where am I suppose to put this code? As...

    Hi RG

    Where am I suppose to put this code? As for continuing on with a pop-up box, do you think I should start a new post?

    Jean
  22. Replies
    26
    Views
    2,759

    Hi RG Thank you very much for testing,...

    Hi RG

    Thank you very much for testing, cleaning and adding all that was needed for the wb up to this point. I learned a lot but I would not have been able to do it without your help. I am...
  23. Replies
    26
    Views
    2,759

    Exit code with a password

    Hi RG

    I have another problem with closing the wb without entering in the data in the exit code. The suggestion was to use the following code:

    If UsrName="HSO" Then Exit Sub

    Obviously that...
  24. Replies
    26
    Views
    2,759

    Hi RG That works great with the fringe. As...

    Hi RG

    That works great with the fringe. As for the Project Number, my change works. Maybe if you like I can send what I have and you can test it?

    Jean
  25. Replies
    26
    Views
    2,759

    Exit Code Continued ...

    Hi RG

    I am continuing with the exit code and going in order of the worksheets and the fields I want to capture on exit. I have the user form with project number working. This is what worked:
    ...
Results 1 to 25 of 78
Page 1 of 4 1 2 3 4