Search results

@NauticalGent, Are you asking this because you are looking for a way for a user to roll back during their instance of your database OR are you looking at being able to roll back changes made by any user even when their copy of access (or their computer) is unavailable? If you need to be able...

2nd to Pat's response. Queries allow you to also do some clean up on data in the query def to better facilitate import / export of data. Really handy to be able to proper case names and such when you keep getting users who DON'T KNOW WHAT THE CAPS LOCK KEY IS OR WHAT IT DOES.

Do you have the latest ASPEmail?

You will DEFINITELY want to reduce the thousands of reports and forms you have then. 2 pages EACH? For a printed manual you'll be contributing to the deforestation of the planet! 😁

Something I've noted is at the top your code shows 'Date Last Modified: 07/18/07 The following sample code should give you an idea how easy this is currently. It creates the PDFs creates the EMails, and gets them ready to send out. Private Sub Btn_PrintAndEmail_Click() Dim MyRs As...

Best way to "Wrap your head around it" is to think of programs like Notepad. Notepad lets you open another file, edit it, save it. Notepad can create a new text document. Notepad DOES NOT save the data in itself, so if you put in a new copy of Notepad you don't loose everything you've written...

@ Doc, wasn't calling Tom's beliefs in question, more the point he'd be singing about "Putin drops the bomb". Seems to have the cadence he'd sing to.

Isn't there also a soft limit on the number of posts a new user can make per day? That way a spammer can't just make a couple hundred posts to the same thread to get past the limit.

@MajP, but that intersection works just perfectly when you realize that each line is intended for a different type of traffic! One for blue traffic, one for yellow, one for red, one for green, and an extra to cover non-standard traffic that doesn't adhere to the standards! Also has a bypass for...

@Ken, thank you for showing that that OP will need to convert to a different data type (string) for display!

Before giving any theory advice, how quickly does your stock change? Do you normally have plenty to sell during the day and still keep stock for the next day? Do you sell out by the end of the day? Do you sell out during the day and have to stop selling that item? Depending on how quickly your...

I've a feeling Tom would approve though...

@ Uncle Gizmo One thing ChatGPT is NOT is non-binary!

With the number of objects you have, I'd estimate your application has very poor agility. Case in point is your asking for help in clearing individual records from 50 tables when in a normalized database this would be a simple delete query OR use of referential integrity to delete the required...

Back to the original, I've a feeling asking someone to grab your rubbers (or Wellies) out of your boot would confuse most Americans. Not sure if those are still common terms in the UK though. For the US, that would be grabbing your rain boots (Galoshes) out of the trunk. 😁 I've always had fun...

When we hear the angles sing, it will be Freddy, Ozzy, and Tom. Unfortunately we me join them soon if Putin drops the bomb.

DELETE FROM table_name WHERE condition; I'd suggest doing a little reading on SQL.

@ Jen-Jen, You are asking to enter only time. Is this because you really want to track how much time has elapsed? If so, remember that using a DATE won't let you show a time value of greater than 24 hours. Instead, as the time portion is the decimal, you get your time to wrap. If you don't keep...

Honestly if they are committing thread necromancy, it would be far more fun to have icons appear to let them know. Say Marty Feldman for recently dead threads to an old Voodoo priest in a top hat and skull face for old threads. Ancient threads would just get a picture of Chicago's Mayor Daley...

You may want to look at your table structure. 80 fields seems excessive for this type of data. If you find yourself adding extra columns from time to time this definitely points to non-normalized data.