Search:

Type: Posts; User: 79schultz; Keyword(s):

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. OK. Thanks. I've been busy on a tech call most...

    OK. Thanks. I've been busy on a tech call most the afternoon, will try this tomorrow.
  2. Yes, we're running Microsoft Access 2010, AND all...

    Yes, we're running Microsoft Access 2010, AND all machines are left running all the time. I'm glad you asked the question about the backend. I did not present my problem correctly, it was misleading....
  3. Check if a database is open, if so, close it

    I have a batch file that decompiles my backend database every night. Once in a while someone will forget to close their fronted before leaving work and it causes problems. Is there a way to have a...
  4. Thank you! I never though to check that table. It...

    Thank you! I never though to check that table. It either got corrupted or someone got in there and changed it. It had 4 blank records in it. I corrected the count and it works wonderfully now!
    ...
  5. I do not get any error messages. I only get 1...

    I do not get any error messages. I only get 1 label per record.
  6. Printing multiple labels no longer works

    For a number of years I had a query that would print as many labels as I needed for an order, using Allen Browne's tip below: http://www.allenbrowne.com/ser-39.html

    A Better Solution

    A simpler...
  7. Replies
    7
    Views
    636

    Sorry, I should have been more explicit. I am...

    Sorry, I should have been more explicit. I am using this on a form, trying to get a Purchase Order ID from the date we enter the PO, plus the Product ID (minus the 3 first letters which indicate a...
  8. Replies
    7
    Views
    636

    This is the message I receive with that. ...

    This is the message I receive with that.



    36529
  9. Replies
    7
    Views
    636

    Trim Left 3 letters

    I am trying to figure out how to trim the first 3 letters in a code.


    Me.tpPOID = Format(Me.tpDateEntered, "yyyymmdd") & "_" & Left([me.tpProductID]) & "_" & Me.tpPrintingCode

    This...
  10. My apologies for not responding! We've been...

    My apologies for not responding! We've been having some network issues and I've been involved with that.

    I took what ruirib suggested and tweaked it to the code below and that works:


    SELECT...
  11. Calculate inventory only on last StockTake Date

    Hello! It's been a long time since I've been on the Lounge, but I am working on updating our database and need some help. I need to calculate the inventory on hand only for the last stock take date,...
  12. Multiple CC: Addresses from various senders

    I have a friend who is using Thunderbird (I use it also) who recently received an email from a company who had broadcast to 212 customers using CC: instead of BCC:. Now, at different times when my...
  13. I thank all of you for your help, I have been too...

    I thank all of you for your help, I have been too busy at work to get around to this and am leaving on a business trip today. I'll try to get back to this (I hate to leave jobs unfinished) when I...
  14. Ooops. I guess I have to back up a little. With...

    Ooops. I guess I have to back up a little. With that formula, it finds the correct months, but now if a person's birthday is between now and the end of the year, it adds 1 to their age.
  15. Thanks a million, jmusgrove. That's exactly what...

    Thanks a million, jmusgrove. That's exactly what I was looking for.
  16. OK. That 'almost works'. What it does is gives me...

    OK. That 'almost works'. What it does is gives me the months if a child is under 1 year, but not exact. It rounds up. For instance, a child whose birthday is 12/21/11, it shows as 1 year, and a child...
  17. I'm sorry, that didn't work. I tried...

    I'm sorry, that didn't work. I tried IIf(datediff.....) and I think it was that one that calculated years OK, but I never could get it to show "months". I was on a deadline, so I finally exported it...
  18. Calculate an age, adding # of months if child is not yet 1 year old

    Hello, all. I am working on a membership database for our church and have run in to a problem. I need a formula that calculates an age, and I have found that information and can make it work, but how...
  19. Replies
    4
    Views
    880

    Understood. Thanks again.

    Understood. Thanks again.
  20. Replies
    4
    Views
    880

    Thank you. That's what I needed.

    Thank you. That's what I needed.

    <Your spreadsheet would be better if you included a Unique values lookup table for Song Names and Numbers.> OK. I'm not 100% sure I understood this part. In other...
  21. Replies
    4
    Views
    880

    Find missing values

    Out of curiosity, over the last 4 years I have kept track of which songs were sung out of our hymnal at church. I have been asked to give some facts about our hymnal and I would like to find out...
  22. Replies
    3
    Views
    8,412

    And how do I do that?

    And how do I do that?
  23. Replies
    3
    Views
    8,412

    Error code: ssl_error_rx_record_too_long

    I have Google's Encrypted search site as my home page. Around 2 weeks ago I started getting this message and I can't find the problem. I've completely uninstalled Google Chrome and Firefox (It...
  24. Replies
    6
    Views
    3,084

    OK. Thanks for the explanation. It didn't make...

    OK. Thanks for the explanation. It didn't make sense to me so I changed it around, now it all works.
  25. Replies
    6
    Views
    3,084

    I don't know what I'm doing wrong, but that isn't...

    I don't know what I'm doing wrong, but that isn't working. Being as there are only 122 records, I just counted them for the job I needed, but I'd still like to figure it out. I have the spreadsheet...
Results 1 to 25 of 320
Page 1 of 13 1 2 3 4