Search:

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

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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!
    ...
  2. 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.
  3. 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...
  4. Replies
    7
    Views
    607

    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...
  5. Replies
    7
    Views
    607

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

    This is the message I receive with that.



    36529
  6. Replies
    7
    Views
    607

    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...
  7. 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...
  8. 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,...
  9. 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...
  10. 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...
  11. 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.
  12. Thanks a million, jmusgrove. That's exactly what...

    Thanks a million, jmusgrove. That's exactly what I was looking for.
  13. 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...
  14. 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...
  15. 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...
  16. Replies
    4
    Views
    868

    Understood. Thanks again.

    Understood. Thanks again.
  17. Replies
    4
    Views
    868

    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...
  18. Replies
    4
    Views
    868

    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...
  19. Replies
    3
    Views
    8,223

    And how do I do that?

    And how do I do that?
  20. Replies
    3
    Views
    8,223

    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...
  21. Replies
    6
    Views
    3,033

    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.
  22. Replies
    6
    Views
    3,033

    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...
  23. Replies
    6
    Views
    3,033

    Using COUNTIF with multiple criteria

    I am needing to use COUNTIF to count ages. I have a spreadsheet that calculates ages, but now I need to count how many people are between 0-10, between 10-20, and so on and so forth. I have figured...
  24. Replies
    28
    Views
    5,524

    Hello, Jim Sheldon. I don't know if you are still...

    Hello, Jim Sheldon. I don't know if you are still having fun with your printer or not. I did just a little research and have a couple questions.

    >Are you wanting to be able only to print to this...
  25. Replies
    19
    Views
    3,251

    View Post

    <What format is your back-end - mdb, accdb or some other server-based back-end? And is the front-end deployed to each of the Win7 workstations?>

    Both back-end and front-end are .accdb. Yes, the...
Results 1 to 25 of 317
Page 1 of 13 1 2 3 4