Search results

Very usefull site when you are struggling with regular expressions. Test and try your regular expressions on: (Generate Javascript as a result resembles VBA the most) regex101.com

Scenario: You have changed your database and want to make sure you haven't forgotten any queries. An SQL statement with missing fieldnames will ask for parameters. If this was not your intent, this little piece of code will detect parameterized queries, for you to fix. It will skip queries...

This function replaces every character with a random similar character. I use this function to anonymize data in tables. Almost but not quite entirely unlike the post made by Micron a few months ago. Share & Enjoy! Option Compare Binary Option Explicit Public Function ScrambleIt(strString...

Also try this one: https://jkp-ads.com/ JKP Application Development Services. And links to usefull utilities like MZTools? Finally, i hope that you stay with AWF because mendipdatasystems is not AWF #justsayin

Always handy: https://www.connectionstrings.com/

KILL() is a function i dont want to encounter in the code which i download. Cleaning out tables is another one something like: for each tbl in tabledefs db.execute "delete from [" & tbl.name & "]" next tbl So as long as there isn't such a function which detects these things, always...

Ofcourse, the parent property. Thanks CJ

Simple question: I have this label which is connected to a control. When i hide the control, the label is also hidden. Is there a way to see which label is connected to which control? Thanks!

For many examples on how to use VB i have used http://planetsourcecode.com/ in the past. Easy to rewrite for VBA. Other languages are also available there. Still looking for a piece of code to scan downloaded examples for malicious code. HTH:D

Hi, I have a backend which must be shipped with the customer. But it would be easier to just ship the frontend and let it create the backend from SQL scripts. I want to be able to create make table sql scripts from existing tables and run them if the frontend cant find the backend. Also some...

First i would switch these two lines: rst.Open SQL, cnn SQL = "SELECT distinct Max(DVNumber),Max(ChckID) FROM DV " And start your module with option explicit, then compile. HTH:D

Just connect tblPeople to your ACCDB file and create a function GetUserDetails which retrieves the data you require. More or less something like this: Public Function GetUserDetails(strUsername As String) As Recordset Dim db As Database Dim rst As Recordset Dim strsql As String...

update tablename set rate = rate * 1.02 or is that too simple? HTH:D

or select * from table1 where degree in ('5A','6A','6PA','11A','12A','13A','14A','15A') order by degree asc; HTH:D

I like what you did here. On the fly adding and using query parameters and filling them. Thanks!

Little bit of topic, but this bugs me: Telecom providers are using GB wrong. 2GB is not 2,000,000,000 bytes. That's why a new abbreviation is created GiB. this is now the real number of Giga Bytes Source: https://www.quora.com/What-is-the-Difference-between-GiB-and-GB HTH:D

Yes, it requires some level of OCD. I know. But i like my code neat and tidy. I have had contact with Carlos Quintero (creator of MZTools) about this feature or the ability to run code on the clipboard or under a shortcut. He told me that it is not going to happen any time soon, so i made this...

I wanted to sort the dim statements on length as part of my vb_Beautifier code: https://www.access-programmers.co.uk/forums/showthread.php?t=210180 It can't be done they said. This code fixes a problem that doesn't exist. It is just a cosmetic fix. It runs some string manipulations on the...

Thank you all for your input!

Hi, I need a sample database to store issues/bugs/wishes on programs. I thought this was a sample database in the latest Access version. But i'm on Access 2013 at the moment. Can you point me to a sample database? Thanks! Regards, Guus