Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    59

    Hi Maudibe This works great. Before I heard...

    Hi Maudibe

    This works great. Before I heard from you I did come up with code that worked when opening the WB, but it took to long to open the WB. This works so much better. Thank you.

    Jean
  2. Replies
    4
    Views
    59

    Excel WB that has required cell input!

    Hi

    I have an Excel WB that is set-up with several worksheets where I require input on various sheets before closing the WB. The WB is distributed to many users. I need the required cells to be...
  3. Replies
    9
    Views
    879

    Hi That works great. Thank you for the help....

    Hi

    That works great. Thank you for the help.

    Jean
  4. Replies
    9
    Views
    879

    Hi I did use a textbox with the drawing tool...

    Hi

    I did use a textbox with the drawing tool versus embedded forms textbox. The code worked great but I would like it to work on any worksheet tab in the workbook instead of the active sheet. To...
  5. Replies
    9
    Views
    879

    Excel code requiring input in textbox

    Hi

    I have a workbook with several sheets. The sheet named "Recap" has 6 textboxes where I want the user to enter text. If the user does not fill-in the textboxes I want the code to activate a...
  6. Iif statement in access query with color criteria

    Hi

    I am trying to alter the following IIF Statement:

    IIF(IsNull([Diff],"",IIF([Diff]>0, "Over","Not Over"))

    This is working correctly but I was wondering if there was a way to add in a light...
  7. Replies
    10
    Views
    1,453

    Hi Paul/Jeremy Thank you guys for all the...

    Hi Paul/Jeremy

    Thank you guys for all the help--it works perfectly and is a godsend not to have to adjust each workbook for importing.

    Jean
  8. Replies
    10
    Views
    1,453

    Hi Is there anyway you could just share with...

    Hi

    Is there anyway you could just share with me the exact code that would create the loop? I am not proficient in writing code--I just find code and adapt it!


    Jean
  9. Replies
    10
    Views
    1,453

    Hi Paul Sorry it took so long to get back to...

    Hi Paul

    Sorry it took so long to get back to you but it crashes on the If UCase ...
    Here is the code:


    Dim i As Integer
    Dim zXLFPath As String
    Dim zXLFName As String
    Dim...
  10. Replies
    10
    Views
    1,453

    Hi Paul It means changing 75 workbooks. So...

    Hi Paul

    It means changing 75 workbooks. So there is no easy fix to the existing code or any other code I can use and adjust?

    Jean
  11. Replies
    10
    Views
    1,453

    Hi Paul I need the code you suggested not that...

    Hi Paul

    I need the code you suggested not that savvy with understanding what you mean?

    Cheers, Jean
  12. Replies
    10
    Views
    1,453

    Need VBA code that changes field name in table

    Hi

    I found the following code to change a field name in a table:

    Dim dbs As DAO.Database
    Dim tdf As DAO.TableDef
    Dim fld As DAO.Field

    Set dbs = CurrentDb
    Set tdf =...
  13. Replies
    36
    Views
    19,124

    Hi I used the following code with a button in...

    Hi

    I used the following code with a button in Access 2010. I allow the user to choose the excel files they want. This might be a start in helping you setup this procedure automatically. The...
  14. Replies
    11
    Views
    1,870

    Hi Mark All set with page breaks. In design...

    Hi Mark

    All set with page breaks. In design view it does not show the page breaks. In print preview it did show the breaks. As for the PO I hedging toward an automatic generation of PO numbers,...
  15. Replies
    11
    Views
    1,870

    Page Break in a Report and Entering a PO Number

    Hi Mark

    That is awesome--thank you so much with the help. I have another request. I have attached the database again. I have a PO and I am having trouble with page breaks!! I also wondered if...
  16. Replies
    11
    Views
    1,870

    Calculated Field in a query

    Hi Mark

    Sorry about that I do not use this forum that often and I forgot to upload the attachment. The attached database is just the piece that you are helping me with. If you need more I can...
  17. Replies
    12
    Views
    2,828

    Hi I did as you suggested with an update query...

    Hi

    I did as you suggested with an update query and it worked great. Had to relearn how update queries work. Thank you again for the help.

    Jean
  18. Replies
    11
    Views
    1,870

    Calculated Field in a query

    Hi Mark

    Attached is a zipped database that I think would be easier then me going back and forth trying to example what I am trying to do.

    Jean
  19. Replies
    11
    Views
    1,870

    Hi Mark I tried your suggestion by altering...

    Hi Mark

    I tried your suggestion by altering the formula to fit my needs in the select query: PO Order: [NeedtoOrder]+Choose(Weekday(Date()),[Mon Safety],[Tues Safety],[Wed Safety],[Thur...
  20. Replies
    11
    Views
    1,870

    Hi Do not want to do in a form. Prefer to do...

    Hi

    Do not want to do in a form. Prefer to do in query. Will do in vba if that is my only choice.

    J
  21. Replies
    12
    Views
    2,828

    HI Both fields are in the one table. Can I do...

    HI

    Both fields are in the one table. Can I do this in a select query versus an update query?

    J
  22. Replies
    11
    Views
    1,870

    Calculated field in a query

    Hi

    I have the following formula:
    [To Order]+[Mon Safety]-[On Hand] all number fields.

    I need to change [Mon Safety] according to the day of the week, for example, on Tuesday I need to alter...
  23. Replies
    12
    Views
    2,828

    HI Thank you for the help. I do not use this...

    HI

    Thank you for the help. I do not use this forum very often so I am having trouble posting a new thread. I have another question. This involves a calculated field. If I have a field On Hand...
  24. Replies
    12
    Views
    2,828

    Hi Thank you for the help but I need to be...

    Hi

    Thank you for the help but I need to be able to enter item codes which I know pretty much by heart. Can you switch it around?

    J
  25. Replies
    12
    Views
    2,828

    Combo Box

    Hi

    Attached is the test database. The combo box works when you choose from the list. The combo box does not work when you type in the Item ID. Appreciate the help.

    J
Results 1 to 25 of 45
Page 1 of 2 1 2