Recent content by Roemer

@DennisOJensen Your proposal is actually not what I want to achieve. With this "code" I would collect all Errors in one field. On my form there will be three rows (each row represents a row from the query). For each row I want to Show the result from the above code. Each field shall Show a...

@Spikepl Yes, you are right. I did not normalize the data in this case. Since my security setup is pretty simple it is sufficient. But I agree, in a more "sophisticated" tool where you don't know the final security setup normalization will be a must AND more criteria (like security objects)...

Thanks Dennis. Based on your Feedback I was able to see one Problem. I have not correctly determined the fields from the recordset. This is fixed and I can see with debug.print the right values populated. But the field on the form ist still not updated correctly, it is now showing always the...

Hi Jdraw Sorry, I have forgotten to answer you. I am using Option Explicit - I just did not Show that part of my code. I am running the code on a Form_Load() Event. Here is what I have - including your proposal (I removed some lines to make it easier for Debugging): Private Sub...

Hi, I have done something similar. In my "user" table I was adding additional columns (Yes/No), like Administrator, Reviewer etc. Like this I can determine the security per user. Based on this user table I am using dlookup in functions to gather the info about the user Access. I am calling...

Hi Jdraw I think I understand your example and it looks like my understanding of a recordset was not completely wrong. Still - I wonder how I can ouput the data from the loop on the form. When I normally do something in VBA and put a value into a field then I usually do it as follows...

Sorry, I can just see that inserting tables does not work. Trying it again differently 1. the query Company Check 1 Check 2 Check 3 1000 True False True 2000 True False True 2. the form Company Check 1000 True, True 2000 False, True

Hi guys, Thanks a lot for your quick Responses. As requested I would like to explain in plain English. 1. I have a query with some results - let's say something like this Company Check 1 Check 2 Check 3 1000 True False True 2000 True False True 2. In the form I would like to show...

Dear all, I am about to learn MS Access using VBA. Currently I am trying to figure out how Loops etc. are working. The book I bought does not tell me a lot about this topic and I am wondering whether anyone could help me on the following. I a basically want to Loop throug a query (or if not...

Hello everyone, I was using MS Access since years, but most of time there was no need to use VBA - that's why I never got into it and did not know about its real strength / advantage :-) Since around 6 months I am trying to get familiar with this intuitive language and I was visiting the...