Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    12
    Views
    393

    Re: Excel Transpose Help

    Thanks for all your help Sandy....If you could, please include screen shots in your steps, I really desire to learn this and taking a course in Udemy....Thanks again...
  2. Replies
    12
    Views
    393

    Re: Excel Transpose Help

    Here you go Sandy and thanks...

    https://drive.google.com/file/d/10hpE7jBrU0Cynrt7uTkJgtYgrO4OexwX/view?usp=sharing
  3. Replies
    12
    Views
    393

    Re: Excel Transpose Help

    Hi Sandy,

    This is what I have thus far, how do I add the List1 = Table.AddColumn(#"Grouped Rows", "ID", each Table.Column([Count],"ID")), step....

    let
    Source =...
  4. Replies
    12
    Views
    393

    Re: Excel Transpose Help

    Thanks Sandy,

    Thanks, I have the advance editor opened in my workbook for sheet 3, can I update it from here to the code you provided to make it work:

    Sheet3_Sheet =...
  5. Replies
    12
    Views
    393

    Re: Excel Transpose Help

    Thanks Sandy,

    I never used Power Query before so where can I find the steps to implement this Code above...
  6. Replies
    12
    Views
    393

    Excel Transpose Help

    Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format....


    <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
    Part
    ID
    Amount...
  7. Replies
    8
    Views
    925

    Re: Multiple Update Query in Access

    I'm new ti this so how would I do this, do you have any samples for me to follow....
  8. Re: Change the color of a row in a form if criteria is met

    So, I can apply all 3 criteria's within the expression in conditional formatting and if so, how would I write the expression in order to meet the 3 criteria's:


    If any row meets this criteria:
    ...
  9. Change the color of a row in a form if criteria is met

    Can anyone tell me how I can change the color of row data in my form if it meets this criteria and how would I create the query if it already has a select statement that populates the form... ...
  10. Replies
    8
    Views
    925

    Re: Multiple Update Query in Access

    That is what we are trying to get away from, so many marco's...

    1. UPDATE BSMTimeTableTemp SET BSMTimeTableTemp.ReferenceNumber = [PaymentID], BSMTimeTableTemp.PaymentID = [ReferenceNumber];

    ...
  11. Replies
    8
    Views
    925

    Multiple Update Query in Access

    Hello, I'm trying to find a way to combine multiple update queries that are updating one table into a single query and I'm unsure of how to create it...Is there a way to do this and if so can you...
  12. Replies
    3
    Views
    391

    Re: Access Query Issue

    Thanks but I got it working and it's stable now...Thanks again....
  13. Replies
    3
    Views
    391

    Access Query Issue

    My update query keeps failing, please see below...Any help will be greatly appreciated...Thanks

    UPDATE TSMDistributionTableTemp SET TSMDistributionTableTemp.DistributionType = "*" &...
  14. Replies
    7
    Views
    460

    Re: Delete a module

    I did and thanks for the help....
  15. Replies
    7
    Views
    460

    Re: Delete a module

    I think that's my best course so I did that and it seems stable now...Module 5 was a button I created but didn't work and once I deleted the code out the module then tried deleting the module I got...
  16. Replies
    7
    Views
    460

    Re: Delete a module

    I see the module which is Module5 but when I try to remove it it gives the Error File Not Found but the module is still there...I made the mistake and deleted the code in the module first and then...
  17. Replies
    7
    Views
    460

    Delete a module

    Can anyone provide me with the steps to delete this module off my form homepage in access...I'm receiving this error when it opens now but it won't let me delete module 5 nor do I know how...Right...
  18. Replies
    4
    Views
    388

    Re: Maximize Window in Access

    Where in the code would I insert the Docmd.maximize to ensure it works properly...Thanks
  19. Replies
    4
    Views
    388

    Re: Maximize Window in Access

    Where in the code would I insert the Docmd.maximize to ensure it works properly...Thanks
  20. Replies
    4
    Views
    388

    Maximize Window in Access

    Within my form, I need to open an external DB another Form but when I run the command, the window sits in minimize mode....

    Private Sub Command38_Click()


    Dim appAccess As Access.Application
    ...
  21. Replies
    1
    Views
    411

    VB code for button on form in Access

    I tried using this VB script for my button but it errors out telling me my DB is already open (I'm trying to open another DB from within my main DB form On_Click...Can anyone assist me in this, I'm...
  22. Replies
    3
    Views
    575

    VB code for button on form in Access

    Can anyone provide me with a Vb code to open a separate Access database from my main form using a button On_Click event...Thanks in advance....New to VB in Access so bare with me...
  23. Replies
    6
    Views
    682

    Re: Hide Cursor in form Text box

    I tried that and it didn't work unfortunately...
  24. Replies
    6
    Views
    682

    Re: Hide Cursor in form Text box

    Shell scrips do not run with Access labels. This is being pushed down to the users desktops...and I need it to act like a Hyper link...Is there a code I can use to put on my main access DB form that...
  25. Replies
    6
    Views
    682

    Hide Cursor in form Text box

    I have this Script for my text box and it's viewing as a hyperlink on the form but every time you click it, it put the cursor inside the text box...How do I hide the cursor within the text box...See...
Results 1 to 25 of 124
Page 1 of 5 1 2 3 4