Recent content by swan

Thanks for coming back to me. On opening the database, the user is presented with a login form. It requests their username and password, then allows them to press an "ok" button to enter, or a "cancel" button to close the system. The "ok" button has the following code behind it: Private...

Thank you all for your replies, and apologies for the late response. @JLCantara, I have added the yes/no field into my "Users" table, but I'm not sure what to do next. What do you mean by a utilities module? Thanks.:)

Thank you for your replies. I am using 2010, and know that the user level security does effectively not now. However, I wondered if there was something that I could add to my existing system. The "Login" form requires the user to put in a matching username and password to a table called...

Hi all, Let me start by thanking you for reading my post, and for any assistance you may offer. I posted this in the general forum as I wasn't sure which other section user level security would fit into. I have a database whereby users already have to sign in with a username and password...

Thanks. I have changed the query, but it still doesn't allow me to produce a matrix, or even design one like I need to. I have started to design it as a report so I have the "axis", but now need to populate each box from the query - any ideas how? Thank you.

Thank you for your reply. I do have the data in a query already. Are you suggesting a cross-tab query of the existing query?

Hi All, I have tried various ways of producing what I need, but I am stuck, so hopefully someone can assist me. I have produced a query, which counts the number of records fulfilling each set of criteria, but I can't now convert that into the matrix presentation. I think a report is the...

Hi All, I have tried to look for an answer to my question in the forum, but I can't find anything and I can't seem to fix it myself ... so I thought I would ask you all. Any help gratefully received. I have a database which is populated, but users have to review and amend the data. I was...

Hi All, I have basic knowledge of access, and anything I have done previously is self-taught.I am now trying to improve a system at work so that it is in access rather than excel. I have started creating my database, and everything is working as I want, but before going any further I want to...