Search results

  1. M

    Solved Data entry creates a new client

    As this is for permits, fees, and the like, is your accounting required to break out when the debt is incurred by the resident as well as when the expense is paid? Are you having to break out the sources? For example, trash or sewage charge that is periodic, has a date due, and that has to be...
  2. M

    Solved Using ACCESS, WORD and OUTLOOK to send bulk E-Mails

    I've code to send multiple emails to a list, but I don't read in the "Body" from a word doc. Instead I generate reports that get sent to individuals and attached. Yes, very doable with classic outlook. I'm DREADING if they decide we MUST use new!
  3. M

    Solved Data entry creates a new client

    I'd suggest you work through your business logic first. Is Revenue just assigned to a client OR is it linked through something like a purchase order, payment for service rendered, transaction fee, or some other source? If the answer is YES, then you need to put in the middle part first. This...
  4. M

    Reducing foreign visa tech workers

    You would need to get state legislators and academics to stop pushing them. I've a feeling it would be easier to push urine back up a urethra!
  5. M

    Online Annoyances

    ellucian. If you know, you know. If not, be grateful! Has the wonderful look, feel, and helpfulness of a 1970's terminal program. Would probably be easier to use if they actually let us see the documentation for it!
  6. M

    Force Exit on Timer

    When it first came out I asked ONE question that told me it wouldn't work; "Does this mean each UIC will get its own server to run it?". If they had set it up where each member's information was kept at their UIC and only summary data was pushed up, it would have worked. This is kinda how...
  7. M

    Force Exit on Timer

    I am very much hoping that wasn't when the DoD decided that "Peoplesoft" could do everything for them. That was a Charlie Foxtrot.
  8. M

    resizing an image

    As a note, you may run into issues with ACCESS not showing specific images. I've learned (the hard way) to only use .png files for display. Really really really annoying but stops users from complaining that some images don't show. Mostly affects reports, fortunately.
  9. M

    Force Exit on Timer

    The table being access does not need to be in the same "back end" as is being maintained. It can easily be in a totally separate back end in a different location from your main database. That is the nice part about linked tables, they don't all have to be in the same file, same directory, or...
  10. M

    Force Exit on Timer

    From a UI perspective, please make sure you give the user some kind of warning, say 5 minutes before.
  11. M

    Calculated Field Error

    He admitted in his first post he knows, but this is for a demo. I'm just hoping he's able to get it done in the timeline he needs. Having had to work through an issue or two with clients in the distant past, I can see wanting to be able to edit a "Calculation" while with them, especially if...
  12. M

    Calculated Field Error

    If you are using a form for data entry, you could avoid doing the calculation in the table and do it in a field on screen, then STORE the result. If you've not resolved this yet, that may be quicker for your demo than spending more time trying to work this out.
  13. M

    Solved Need help with one of my Time Clock forms

    This may sound like an odd question to OP, but why isn't the "Clock out" disabled if there is no "Clock in" time? I've a feeling you'll have a few cases where a user accidentally clocks out first thing in the morning as they are being a bit careless due to lack of sleep and/or caffeine.
  14. M

    What's your best/worst joke?

    But can I get a pet fish licence for my pet fish Eric?
  15. M

    Update of stock quantity

    Please note, for the type of query you are looking for, you want to have "Order level" in one table and "Stock Quantity" returned by a different query. You then calculate what you need as "Order level" - "Stock Quantity". If you have 10 in stock, but have an order level of 20, this gives you...
  16. M

    Why so many adverts suddenly?

    Well, to help avoid annoying adds we can start asking for a list of "All places that have and independence day thanks to the UK". Should give Collin some possible vacation plans and make big brother help us for a change!
  17. M

    What's your best/worst joke?

    Watched the true struggles of one with a disability. Seems there was this blind man who walked into a bar. Then into a table. Then into a chair. If I'd stopped laughing, I'd have handed him back the cane he dropped....
  18. M

    What is your favorite recipe?

    I do a variant on dirty rice that is very easy. In a pot, add one lbs high fat ground beef, upto one onion (diced), upto one green pepper (diced) and a stalk of diced celery. Optional salt and pepper to taste. Brown on a very low temperature so you don't burn off the fat. When browned and the...
  19. M

    Yikes! The UK is serious about tweeting

    At least they will have a warm bed waiting for them! :ROFLMAO:
  20. M

    Expedia

    That's why I'll check a third party site, but call the hotel directly instead! ☺
Back
Top Bottom