Search:

Type: Posts; User: Lou Sander; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    172

    RG's Post #6 solved my problem. I spent quite a...

    RG's Post #6 solved my problem. I spent quite a while fooling around with it until I finally figured out how it worked. That stuff was a lot easier 20 years ago.

    One more thing: Though I can...
  2. Replies
    9
    Views
    172

    I'm not getting it. I didn't explain in enough...

    I'm not getting it. I didn't explain in enough detail. My summary sheet just picks up some data from the various WKn sheets. It doesn't need to perform any operations.

    The data being picked up...
  3. Replies
    9
    Views
    172

    "IF EXIST"-type formula

    I have a workbook that includes, among other things, anywhere from 1 to 13 worksheets, each pertaining to a given week in a calendar quarter.

    The first week in the quarter, I create a sheet named...
  4. Replies
    6
    Views
    232

    [SOLVED] Got it! I now have six macros for updating the...

    Got it! I now have six macros for updating the dates in six different cells, and it works exactly as I want.

    Two questions:

    1) If I give a cell a name, how do I use the name in place of the...
  5. Replies
    6
    Views
    232

    [SOLVED] I didn't make it clear... I just want TODAY's...

    I didn't make it clear... I just want TODAY's date in the cell. It needs to stay there, unchanged, tomorrow, the next day, and forever, until I change it manually or click the command button again. ...
  6. Replies
    6
    Views
    232

    [SOLVED] Macro to insert date

    I have a simple macro attached to a command button, but it's not working right.

    When the button is pressed, I want to select a certain cell and plug today's date into it. Right now the code is
    ...
  7. Replies
    4
    Views
    540

    I went ahead and named the range, then put the...

    I went ahead and named the range, then put the name into all the macros that use the range. It works well. A big advantage is that if I add a column inside the range, the sorted area expands to...
  8. Replies
    4
    Views
    540

    I understand it pretty well now, and everything...

    I understand it pretty well now, and everything works as I want it to. I've organized the code along your lines, making it much easier to follow.

    The original sorts were made by recording macros,...
  9. Replies
    4
    Views
    540

    Sorting from a Command Button

    I have a workbook with a dozen or so worksheets. On the Finances worksheet, I have four Command Buttons that sort a table on four different columns. Things work OK, but I need to make some...
  10. Replies
    21
    Views
    1,439

    [SOLVED] RolandJS: I, too, hope the cloud never rains....

    RolandJS: I, too, hope the cloud never rains. I've seen and had too many catastrophic computer failures to be too, too trustful of other people storing my stuff. The local backup feature is a good...
  11. Replies
    3
    Views
    372

    I have a LinkedIn account, but I haven't the...

    I have a LinkedIn account, but I haven't the foggiest about how to interact with a group there. I do not subscribe to their email service (whatever it's called).
  12. Replies
    21
    Views
    1,439

    [SOLVED] Success! Here are some links to step-by-step...

    Success!

    Here are some links to step-by-step instructions, including numerous screen shots, for setting up a USB external hard drive to be available to all the computers on your Windows 7 network....
  13. Replies
    21
    Views
    1,439

    [SOLVED] Thanks! I'm still working on this...

    Thanks! I'm still working on this...
  14. Replies
    21
    Views
    1,439

    [SOLVED] The router is an ARRIS TG862

    The router is an ARRIS TG862
  15. Replies
    3
    Views
    372

    Using Craigslist to get help on Access

    This forum is arguably the world's best source of help on Access and other areas of computer knowledge. I've gotten tons of good help here, and I've been able to give some minor help to others.
    ...
  16. I'll give it a try. I can see where my long...

    I'll give it a try. I can see where my long weekend is headed -- Accessville! I've got plenty of "better" things to do, but this stuff is addicting once you take a few hits of it. :rolleyes:
  17. Replies
    21
    Views
    1,439

    [SOLVED] Boy, this gets complexer and complexer. I've had...

    Boy, this gets complexer and complexer. I've had something like this in the past, but working with it was a minor nightmare, and I didn't have time to get to the bottom of it. I'm taking all these...
  18. Thanks for the response. I DO have a split...

    Thanks for the response. I DO have a split database, thanks to the expertise of the fellow who designed it ten years ago. And you are right, most of those windows ARE attached to a form or report.
    ...
  19. Replies
    21
    Views
    1,439

    [SOLVED] Roland: I don't know how to "lock in" a drive...

    Roland: I don't know how to "lock in" a drive letter. RetiredGeek's post shows one way, but the explanation at the link is a little scary. Are you thinking of another way to do it?

    BTW, my network...
  20. Replies
    21
    Views
    1,439

    [SOLVED] Network-accessible external hard drive

    How do I make my external USB hard drive available to all the computers on my network? This seems as though it should be easy, but I haven't been able to find an intelligible explanation anywhere.
    ...
  21. [SOLVED] This looks good. Thank you. (By the way, I have...

    This looks good. Thank you. (By the way, I have used the method in the uploaded document dozens of times, and have never had any problems. It is a nuisance to do all that typing in the Criteria...
  22. [SOLVED] Using one Access table to select records from another Access table

    I have a large table that contains all the information about members of our association. There is one record for each member, and each member has a unique identifier called a Handle.

    Sometimes I...
  23. Printing Numerous VBA Windows - Access 2010

    I have an Access 2010 application that uses a lot of VBA. When I switch to VBA mode, there are about 30 different windows open, most of them with under 20 or so lines of code.

    I'd like to see all...
  24. Replies
    5
    Views
    416

    [SOLVED] Well, I've accomplished what I wanted to do, and...

    Well, I've accomplished what I wanted to do, and everything seems to work.

    RetiredGeek's tip was essential to it all. What WendellB pointed out wasn't useful at first, but I broke out Access 2007...
  25. Replies
    9
    Views
    1,036

    [SOLVED] Thanks to everyone for their input. In the end,...

    Thanks to everyone for their input. In the end, WendellB's reply was the most useful: I don't need the two versions of Access, since they both can handle .MDB files.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4