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!

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

Search results for query: *

  1. bmoremu

    BIOS doesn't recognize any drives after swapping secondary HD's

    Thanks again, I'll see if a BIOS update is also available. As I mentioned, my OS is on the SATA which is the D: drive. Should I consider changing this to C:? It doesn't sound easy based on what I've read and there's a possibility to really screw things up...
  2. bmoremu

    BIOS doesn't recognize any drives after swapping secondary HD's

    Thanks guys, this has been resolved. I think it was a few things. It probably started when the secondary HD was swapped in with it's jumper settings on Master. Then when it was removed the BIOS still wasn't recognizing my SATA, my only thought is because the SATA's labeled D:? Anyway, after...
  3. bmoremu

    BIOS doesn't recognize any drives after swapping secondary HD's

    A friend of mine was no longer able to get into Windows XP on her PC and wanted to save a lot of digital photos. So I took her PC, removed her HD and swapped it with my secondary HD. (My PC has a primary SATA drive w/ the OS and a secondary IDE drive for storage). When I turned on my PC, for...
  4. bmoremu

    Partitioning and SATA/IDE problems

    Sorry, f'ed up stands for fracked up. The 120GB was the only drive in the dell w/ factory intalled XP. I tried creating a 2nd partitiong with PartitionExpert from Acronis (possibly my first mistake). I do not have another SATA capable machine with me. I installed XP on another machine in hopes...
  5. bmoremu

    Partitioning and SATA/IDE problems

    I am extremely frustrated by the problems I'm having with my hard drives. Any help is much appreciated! I have an almost year old Dell XPS. Tried partitioning my 120gb SATA HD and the software f'ed it up! My partition with my data is still there but I have no way of accessing it. I figured my...
  6. bmoremu

    Cross-tab Sorting

    The reason I mentioned Field Explorer is b/c it's the only place I find a 'Report' menu, when I right-click there. Otherwise, after left-clicking on the 'x', I do not see a Report menu anywhere up top.
  7. bmoremu

    Cross-tab Sorting

    Ido, My crosstab example is shown in my original post, that's all there is to it. LB, It is a crosstab. After clicking on the "x", I right-click in the Field Explorer, go to 'Report', and 'Top N/Group Sort Expert' is grayed out.
  8. bmoremu

    Cross-tab Sorting

    Correct, I see 'Top N/Sort Group Expert' but it is grayed out / unavailable.
  9. bmoremu

    Cross-tab Sorting

    I can only access the Report menu by right-clicking in blank space of the report, and when I do that 'Top N/Sort Group Expert is grayed out / unavailable.
  10. bmoremu

    Cross-tab Sorting

    I'm having a difficult time doing what I would hope would be an easy task. I'm using CR in .NET...here is my example table: Week1 Wk2 Wk3 Wk4 WkN Total User1 3 8 7 2 20 User2 5 6 1 2 1 15 User3 1 4 9 5...
  11. bmoremu

    Access form combo box validation

    I have a form with a combo box. When a command button is hit, the value of this combo box is displayed on a label. I've placed the following error-check in the code for the command button click to make sure a value is selected in the combo box. If cmbJob.Value = Null Then MsgBox "No job...
  12. bmoremu

    Global Database Connection?

    I have a workbook with forms that interact with an Access DB. I want to just connect to the DB on Workbook-Open and close the connection when the workbook closes so I won't have to keep opening and closing the connection repeatedly. I tried "Global DB as DAO.Database" but it won't let me do...
  13. bmoremu

    VLOOKUP vs INDEX & MATCH

    From the "Match" definition in Help: Returns the relative position of an item in an array that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself.
  14. bmoremu

    How can I identify each ListBox item to paste into cells?

    I see...in the VB editor, select the hidden worksheet with the values, and under its properties change its "(Name)", first property, not "Name" further down. Now in your code you can reference this sheet, i.e. TestName.Range("A1"), without showing the sheet. Besides forums like this, be sure to...
  15. bmoremu

    How can I identify each ListBox item to paste into cells?

    S'alright, I've only been doing it a few months myself, experience is the best way to learn I think. The coding I had in mind was....under the command button click event...have it search through the selected items like I wrote above, i.e.: For i = 0 To 9 If ListBox1.Selected(i) = True Then...
  16. bmoremu

    How can I identify each ListBox item to paste into cells?

    Well the additional info would have to be listed in some sort of table or in VB. Then you'd have to probably use some IF statements to say "If this item is selected....then return these values".
  17. bmoremu

    Why does this macro stop in the middle without an error?

    Shouldn't that be 'End Sub', not 'Exit Sub' at the end?
  18. bmoremu

    How can I identify each ListBox item to paste into cells?

    You want a multiselect listbox if you want to allow the user to add/remove multiple items. You said items instead of item so I'm guessin you want multiselect.
  19. bmoremu

    Error trapping suggestions?

    Are you asking how to handle multiple errors or what code to include in the error trapping? If you're asking the former, use an If/Then or Select Case with the Err.Number in the error handler so it'll run the appropriate code dependent on which error occurs.
  20. bmoremu

    How to use method Range inside IF control structure

    What is the value of MyRange when the error occurs?

Part and Inventory Search

Back
Top