Search results

The link George referred to is https://www.mockaroo.com/ I am working on an Anonymizer that can generate plausible-looking random data. Send me a PM and maybe I can share it with you.

Considering your situation, I would keep it very simple: * SQL Server Express, the free edition, on-prem. You'll need to add a sproc to perform a database backup, since scheduled backups are not included in Express. * Very few stored procedures and views. They are mostly to optimize performance...

I can only think of disadvantages, such as The software you'll install on this machine has not or barely been tested on this OS. This includes device drivers like your printer and camera. When you build your app (this is more for .NET development than Access) it may pick up unusual references...

Cut/Copy/Paste more than likely are unchanged. But what could have happened is that the clipboard was in use by another app. Reboot the machine, don't start anything else, and try again. Another test you could perform is to do the operation manually. Is "Paste" grayed out when you get to that...

Thank you for answering question 2. We'll wait for the answer on question 1.

That was my thought as well. The OP better very clearly define what threads he wants to defend against. Keep an excellent Access developer, putting in an effort of N hours, from accessing the algorithms / encryption keys, or the NSA?

> without having to execute the function wherever it is required Perhaps this is an issue of not using precise enough language, but the way I am thinking about it, yes, you have to execute a function if you want its return value. If it is a deterministic function, then conceivably you can cache...

Replace the word "SSMS" with "SQL Server". The former is an editing tool; the latter is the database engine. You could put complicated calculations in a .NET assembly, and call it from your sproc or function. See this about assembly security. See my Simil blog page for an example of calling an...

I have a few questions: 1. Roughly how many products do you have, and how often do they change? 2. Why are you joining with tblWarehouse? Do you only want products that are in the warehouse? If so, there may be better ways.

You can write code like below (and more for each container) to get Create and Modify dates, but these are not super reliable. They are sometimes updated even when you think you didn't change anything. Dim ao As AccessObject For Each ao In CurrentProject.AllForms Debug.Print ao.Name...

Thanks for clarifying. Since you attached text files, I wasn't sure if these were sent to you by some other entity. You could have attached a zipped copy of your database, stripped to the bare essentials. I'm thinking your crosstab is a good attempt to get the data for HTS2 - 7, and now you're...

I have a few questions. Please answer all of them. There are good reasons for each of these. 1. Where does Special Duty.txt come from? Do you have any control over its format? 2. Special Duty Crosstab.txt: seems to be the results of a crosstab query over Special Duty data. How was that created...

As I wrote in #5, as long as you are storing the date value as a Date/Time field in the database, you are good. How you format it to display to the user does not matter to the date math and queries. If you are storing your date values in Short Text fields, that is really bad and should be fixed...

Another very important point: there is an important difference between the VALUE of a date, and the way it is DISPLAYED. Under the hood every date is an 8-byte floating point value. We can display it in many ways, such as the several ways mentioned above, and many others. Example (in the...

> "#" & Format([CheckIn], "dd/mm/yyyy") & "#" No, that is no good, because that would result in a date like 31/12/2025, which is not a legal date in US format. You have to either use US format mm/dd/yyyy, or ISO: yyyy-mm-dd

Agreed, especially if you digitally sign them. The other justification is that it is a universal file format, likely to be supported decades into the future.

Only if you need it for just half a year. https://www.accessforever.org/post/deprecation-of-ie-browser-control

I ran a quick test. Looked terrible. External browser may be your best bet.

> Why do I need to KNOW if the input is a BigInt/LargeLarge/Large Number data type? I am the OP and I will explain. I am working on an Anonymizer. The user can select a Converter for each column in each table in the database. One of those converters is called RandomNumber. It takes a few...

Add this: rst.FindFirst reeksletter if not rst.NoMatch then Forms!keuzetitel.Bookmark = rst.Bookmark You always want to test the result of functions that can fail.