Recent content by Trond Hoyem

That surely sounds like a good idea. I will adopt that practice.

OK, this is embarrassing... I have for some reason two forms with almost identical names, and one is not in use. Probably I have made a new and better one at some point. I was looking in the code of the wrong form. When pasting it into the correct form, it works. Sorry to bother you with this...

I tried now, and it skips this line for some reason, and execute the lines after it.... It does not stop at the break point. The MsgBox appears, and the record is deleted byt the query that is run after pressing "Yes". The form is also updated after the code is run. So everything in the code...

ArticleNumber is a string. The second parameter works fine in other forms with "" when there is no spesific reference to be added.

I did not try that, but the next lines in the same procedure are executed, so I don't really see why this one is not executed.

Hi I am adding some activity logging to my database. For this I have created a public sub in my module "CommonFunctions" called "activity" What it basically does is just to add a record in the activity table with the user name and a short text describing what has been done, like "log in"...

Pat and Isaax, thanks for your replies! I have put some thoughts into this matter over the years. I have also created a few similar tools in Access before, but for the one I am considering now, I would like to add something new because of big changes in the type of projects we are calculating...

Thx for answers. I will have a look at this and then there will be more questions, I am sure....

Hi I am in the beginning of creating a DB for advanced calcuation of project-offers. I am fully aware of the existence of these kind of things, but so far I have not been able to find anything that really support all my needs, and so I am doing it the hard way..... Today's calculations...

Ah! So thats the reason why it did not work. OK, learn something new every day.

OK, I found the solution. I was looking at the wrong field, but not sure if that is the reason. I tried this version instead: Highest: Mid([offerNumber];InStr(1;[offerNumber];"-")+1) This worked, I was able to get the info I need from it. Thx for help!

Still the same error message. I have tried both your suggestions. I realize that the function split() is not included in the Functions in the Build-dialog box. Might it be that it is not included in all versions of Access?

Hi I am a rather newbie Access developer. I am currently working on a project where I need to split a string at a "-". Not very different from the example in this thread. I am doing this as a calculated field in a query, as what I need is to find the number following the "-" and then find the...