Search results

When i have a question and looking for an answer i want to find it at my favorite site, AWF. So when i find a nifty piece of code i use it in a solution looking for a problem and post it here. This was what i was looking for: Dim V$ Dim T% Which means V is declared as a string and T is an...

I have served in the Dutch army in '85 but that has nothing to do with my name. My first name followed by the year is started joining fora.

"sometimes I just roll my eyes out loud..." Dear OP, I ask you to forgive me. I was totally out of place to make a joke. Sometimes i think i am funny. Gladly people like Micron will put me in my place. He was right i should have waited. At least another week. I will ban myself until my next...

I have used both F&R and MZTools (commercial). MZTools does a lot more than just replacing a string. However it does not find your searchstring in control properties.

Search the site for TLOOKUP. It is a replacement for all domain functions. Not a wrapper but a much faster alternative. I would use a wrapper for a function with a complex set of arguments, like a Paramarray.

what you need to do is normalise your database. All records in the invoice tabel should be unique Make a status table and rename the invoice table to InvoiceStatus. Sort on date (you must have a datefield somewhere) and add the ID field Autonumber Create a table Invoice with unique Invoices...

I would like to summarize the question from theDBguy: Can you show us your query? There, that makes more sense now doesn't it?

If it was for personal use only, i would have considered the last solution by Arnelgp. But it is an application for a few hundred users, and i don't know if the solution is worse than the problem. As you can understand, it is a big risk to introduce this solution when only 1 user has this...

Thanks Ranman256 and arnelgp, In Access we can catch keystrokes using the AutoKeys macro. What is the equivalent in Excel?

Dear reader, I have a protected workbook and sheets but i am unable to prevent users from copying and pasting values in my sheets. It is a popular way to use the spreadsheet and fill it with data. I can understand that. But copying a value from one spreadsheet to another using ^c, ^v always...

I found this gem here on AWF. https://www.access-programmers.co.uk/forums/threads/please-explain-how-to-use-this-module.180307/ And i believe that it is outdated. It is obviously 20 years old and the return values are not always what i expect them to be. Examples...

when you do that you are storing the information twice. you dont want to do that. If you must, use a calculated field. then the information is shown the way you like while it is stored only once. You have to check if Access allows creating calculated fields. Another option is to create a query...

I need to import a text file and instead of Günther it shows G?nther. (this is just an example) Opening the file in Ultraedit the hexadecimal value is 90. I usually work with UTF-8 and also Windows 1252 doesn't give me any problems. What i want to see is the name G?nther shown in every...

If a text file was associated with e.g. UltraEdit, UltraEdit would be used to open the text file. Ofcourse i rebooted (a few times by now) and even reinstalled the Notepad++ app which i normally use for text files. Looks like im the only one ever to come accros this kind of problem. Shoot...

I got a working path when i look at the contents of the strFullPath variable. ?strFullPath c:\Temp\Scripts\Slablaadje.txt When i open notepad++ en open a file and paste in the path, it opens nicely. The code worked for a few months, and now it doesn't. fso.Open...

I have this code to open a file with the default application based on the extension. It is usually used for a .txt extension and it opened Notepad++. Public Sub openScriptInDefaultEditor(strFilename As String) 'File is opened in default editor Dim strFullPath As String Dim fso As...

Hoi Ron, Welkom bij dit forum. Een vraag blijft hier meestal niet langer dan een dag onbeantwoord. Maar we kunnen wel wat nieuwe inzichten gebruiken.

Hi B, Welcome to AWF! We could use some new faces! New?? Joined two years ago... Doesn't matter, Welcome!

Hi C, Always nice to see a new member!

Hi Dan, welcome to AWF. Good luck with your new ERP system. Come back when you need help!