Search results

Thanks!!!!!!!!!!!!

Hi, I do not really understand exactly. How can I use a query to do that? To run this function with another value as argument? Do I need to change the code of the function itself by putting an input box when I call the function itself? Or this inputbox can serve independently to give a value...

Hi, How exactly do you run a function with a different argument value? For now, I run a form and via this way I give the variable "intputlayers" a value, used in the following function: Function QChecks(inputlayers As String) However, I want to run this form standalone, without form. So...

Thanks!! It works!

Hi, How do you know how many substrings an array contains after using split? My code needs the number of elements as it has to peform some actions on that: Function findexpression(inputvalue As String, inputexpression As String) As Boolean 'In case the rules is a regular expression, the check...

Hi, I made a sub procedure where an input is requiered, example: sub QChecks(layername) I wanted to automate a proces, so the inputstring for the parameter layername is entered by a form. To run the complete tool, I made a function in VB: Function Qualitychecks() QChecks(input) So the...

This is correct. The "inputfield" is an input, and I want to use the values of the parameters called part1, part2 and part3 wich result from the function.

Hi! I tried exactly what you wrote, however, I get the error in the code on line regexpparts (presence, part2, part2, part3) saying " byref argument type mismatch" However, I tried something similar, which does works! The code of my function: Function regexpparts(inputfield As String, ByRef...

Hi, I tried the method using Byref, although I get an error when I call the function on line "regexpparts(presence)": "argument not optional" My code for the function: Function regexpparts(inputfield As String, ByRef part1 As String, ByRef part2 As String, ByRef part3 As String) Dim...

Hi! I'm using a separate procedure in which I enter 1 variable. This procedure should return 3 strings. I know how a function procedure can return 1 argument, but I can't find how to let it return several arguments. I tried via an array "parts()" but this doesn't work: My code: Function...

Because actually, in this database (for streetnames), Susan O'Smith is not right, susan o'smith is also not right, but Susan O'smith is wright (so when a part of a streetname contains a apostrophe, it does not have to have an upper case.

Hi, I think this is a very stupid question, but for one reason it doesn't work. I have in my code: Public reftablename As String Public reffield As String Public field As String Then I created a function: Function regexpparts(inputfield As String) 'As String 'find all parts of the inputfield...

Thanks, I think using labels will be the only possibility after searching and searching.. (I was looking for a very quick way) Bye, Leen

Hi, I have a problem using regular expressions, in which I don't find the correct pattern to return the right values. I have a table, in which in the records, names are stored. For example: Street Alex Victorian Runway etc. The goal is to check whether the user has filled in the names using a...

Hi, I'd like to create a table using VBA where one of the fields is a number datataype, the fieldsize property is double. .Fields.Append .CreateField("LENGTH", dbDouble) However, I'd like tthat that, when values are inserted in this tablefield, 7 decimal places are displayed. I know you can...

Hi, actually, I want to try now something very similar, but it doesn't work anymore.. I have a form with several options, some of them can be vinked, some not. BUT, if one is vinked, it should be imported. However, for some reasons he can't save the values of the parameters and the tables...

Hi, actually I tried many pattern and had many different results. Sometimes way to many. But your initial patterns seems to do it! Actually, for the application I'm creating I really need to put everything into one record, into one field, so I can not normalize in this case. Thanks for your...

Hi, I have a msgbox and I'd like to have the colour of the text in a different color: If tblexists = False Then MsgBox ("Table RAILWAYS is not present in the database") Else MsgBox ("OK: Table RAILWAYS is present in the database") End If In the first case, I...

It works!! I'm getting to understand how Access is working already a big step better!!! Thanks for your very clear explanation!

Hi! Thanks for all help. I used your pattern and it works!! Just one question: in the help of regular expressions, I found concerning your pattern: .Pattern = "(\b\w+?\b)" \b = Matches a word boundary, that is, the position between a word and a space. For example, 'er\b' matches the 'er' in...