Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BeallDon

  1. BeallDon

    What has happened here to Tek-Tips??

    Ya, not impressed with this new format. I can't locate the MS Access forum!! Arrrrgh.
  2. BeallDon

    use VBA to group rows in Excel

    Skip, Do you see how simple this was? You were making this sound so complicated. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim f As Range If Not Intersect(Target, Range("C:C")) Is Nothing Then Cancel = True Set f = Range(Cells(Target.Row...
  3. BeallDon

    use VBA to group rows in Excel

    Skip, If you don't understand what i'm after, or if you have no idea how to accomplish it, then kindly, don't respond. I feel I have clearly outlined my goal. The code would be the same no matter what the name of the rep is - if there were 2 reps, then there would be 2 GROUPS instead of just...
  4. BeallDon

    use VBA to group rows in Excel

    This is EXACTLY what i'm looking to do: See attached. Do you see the "+" or "-" sign on the left of column A? That's what i mean by grouping. I didn't know there was another grouping function in Excel. I want to GROUP all ROWS that contain the same data in column C when i double-click on a...
  5. BeallDon

    use VBA to group rows in Excel

    Skip, I already know what i want to accomplish. i am simply looking for a bit of guidance to perform a repetitive task. i don't need to modify the spreadsheet and i'm not going to start messing with pivot tables, etc. This is a spreadsheet provided to me by the company i work for and i'm not...
  6. BeallDon

    use VBA to group rows in Excel

    Skip, see attached. I want to be able to double-click cell C2 and automatically GROUP rows 2-39 (actually 2-38 because row 39 would be visible) because they all have the same data in Column C.https://files.engineering.com/getfile.aspx?folder=323bd55c-059e-4ca3-ba30-c51c81700bb5&file=Sample.xlsx
  7. BeallDon

    use VBA to group rows in Excel

    Skip: I never said i CANNOT filter by sales rep. i said i DO use filters. But i WANT to be able to double-click on the rep's name in column C and have VBA automatically GROUP all the rows immediately below with the same rep name (whether it be 40 rows or 100 rows). i just don't want to...
  8. BeallDon

    use VBA to group rows in Excel

    i do use filters but i want to group them by rep names so the when i filter a specific territory, i can see all reps on one screen (there may be 6-10 reps in each territory and up to 100 customers per rep). Not looking to group by territory, just reps because the spreadsheet isn't sorted by...
  9. BeallDon

    use VBA to group rows in Excel

    I have a fairly large spreadsheet to list customer details which is sorted by sales reps (about 40 reps). I want to be able to double click on a rep's name and have VBA automatically group the rows with his name; then double click on the next rep and group, etc. The reps' names are always in...
  10. BeallDon

    Rounding Issue for Currency

    I'm using the "round" function in my form to do tax calculations but when the result is 3 decimal places and ending in a 5, the "round" function rounds it DOWN. Is the something I could do to make it round UP if the result is half a cent? Gross = me.GrossAmount (from the form) CommissionRate...
  11. BeallDon

    Rounding up half penny

    I'm using the "round" function in my form to do tax calculations but when the result is 3 decimal places and ending in a 5, the "round" function rounds it DOWN. Is the something I could do to make it round UP if the result is half a cent? Gross = me.GrossAmount (from the form) CommissionRate =...
  12. BeallDon

    Attach a file to a record

    using Tigerlili3's advice in thread702-1137528, "You can have a field in the table which I'll call Attachment for this example. The data type needs to be OLE Object. On your form you need to have a bound object frame which I'll call tvwAttach for this example. You can have a button on the...
  13. BeallDon

    Open folder to view specific files

    Thank you very much jrbarnett and kjv1611 for your suggestions. I will look at each of those methods and will figure something out.
  14. BeallDon

    Open folder to view specific files

    I have a button on a form that, when clicked, will open an explorer winder to a specific directory where I have PDF files stored. Private Sub ViewPDFFiles_Click() Dim OpenPDFfolder As Variant, myPath As String myPath = "C:\Documents and Settings\myPDFfolder" If Dir(myPath, vbDirectory) <> ""...
  15. BeallDon

    Database Replication

    I am considering replicating my database for a multi-user environment. I have tested it a few times and the only issue that I have with replication is that in each of my tables, I have a primary key field that is an incrementing autonumber and after I create the replica, every single one of...
See more

Part and Inventory Search

Back
Top