Recent content by Mark_

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...

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

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...

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.

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.

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

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...

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!

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....

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...

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

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

Are you asking for a sample database using a path to a file on disk?

You CAN, but it doesn't always come out working well on a phone. Buttons and entry fields are especially difficult to manage when the phone's keypad can take up half the screen.

Having talked to the folks at hotels / motels, I always contact the place I'm going to stay at instead of a third party. You'd be amazed at how helpful the staff at the hotel can be when you talk to them nicely!