Search results

Adding to TheDocMan: just this morning I got this same error, and the problem was my field was a Long Integer, and the value was greater than the max long integer of 2 billion and change. I could have changed it to Big Integer, but in this case chose a Short Text data type. BTW, what you set...

An integer field would be good to store 32K minutes, which is about 533 hours or 22 days.

You're providing very little information, so we only have wild guesses available as to what you want. Maybe this, using the Northwind 2.3 OrderDetails table: SELECT OrderDetails.OrderDetailID, OrderDetails.OrderID, OrderDetails.ProductID, DCount("*","OrderDetails","ProductID=" &...

The Northwind 2 Templates show you how to create an OrderList with the OrderTotal amount in it:

One option is J Street Access Relinker: https://jstreettech.com/developer-downloads/

You can do without your home-grown history table altogether and use SQL Server's built-in feature. I typically use a sproc to insert data and return the inserted record.

I'm assuming you have re-link code in your startup code, which would set the (possibly new) connection string of all linked tables. It needs to do that for PT queries as well. They also have a Connect property.

While you can FIND records using a wildcard, you cannot REPLACE using a wildcard. Find: ####* (then repeat for 5, 6, etc. digits) To do a find and replace, RegEx code would be most efficient, but not super easy for a rookie. RegExp is in "Microsoft VBScript Regular Expressions 5.5" library...

https://techcommunity.microsoft.com/t5/windows-it-pro-blog/vbscript-deprecation-timelines-and-next-steps/ba-p/4148301 Let MSFT know how you feel. I am not aware of a good replacement for the regex features of VBScript. Possibly a .NET component, possibly written using TwinBasic.

Outlook Redemption for sending emails without Outlook security prompt.

Add another column, to indicate if the data came from tableA or tableB.

I think @gemma skipped over the part where you need to parse the json. Jack Leach has the right idea here: Parsing JSON with VBA - Dymeng and he explains why.

MSFT is trying to phase out Internet Explorer. I would not use it for new development.

Is there any macro or vba code in that report? Do you have code anywhere that may change the query used as the RecordSource for this report?

Hi KitaYama, I presume he means code like this: public function RunAnyActionQuery(byval sql as string) dim qd as dao.querydef set qd = currentdb.querydefs("qryBucket") qd.sql = sql qd.execute dbFailOnError RunAnyActionQuery = qd.RecordsAffected end function public function...

Why are you looking for < and >; those characters do not occur in FN and LN. Show us the data you are really working with, and what you want it to become after processing. Piling on: "it doesn't work" is not helpful.

"Similar"? Similar by what? Because one or more attributes (there is that word again) are the same or in the same range? Example: Apple and Orange are similar because they are both Edible=True, Weight between 30 and 50, Diameter between 3 and 5, etc. but they are also dissimilar with other...

You need to get the programming documentation for your printer. My guess is you need to send it a few special characters to make it cut.

Those addresses all are close to me. One is only 1 zipcode over. Maybe we should have coffee sometime. The Locale Names as used by USPS can be downloaded here: ZIP Codes by Area and District codes | PostalPro (usps.com) That would be a good way to identify for example "sun city west" as a...

There is a tad more to it than that, considering the user can move the login form, and the main window needs to remain underneath.