Search results

I have a combo box with multiple columns which are: (UsergroupID;UserGroupName;Password) Currently only two usergroups are used, "administrator" and "admissions tutor". These reside in TblSecurity Columns 0 and 2 are hidden, and column 1 is used to select a user name. This works fine for the...

Searched the internet, searched the forum. One thing I just don't understand is how you actually use these. I must be insanely stupid. I've made all the needed queries, I've made a combo box which uses a query to display all courses (2 columns, course_code and Course_Name) and all the queries...

How exactly do you declare these in VBA? Currently I have a log on page which I want to include 2 user access levels. At the moment you can type in "administrator" and the password admin or "tutor" with the password "tutor" and currently, it takes you to the same page with the same privs...

I have a Manage Staff form. This form allows you to view staff and edit them. However, If I want to delete a member of staff who is linked to another table, (e.g. 1 staff member can assess MANY Student applications) it will obviously blurt out a rather helpful, but annoying message. What is...

Wasn't sure if this was a form or reports question, but eitherway, how do you put reports into a combo box? I've been able to successfully google how to look up records from a table in a combo box, now I need to be able to give a drop down list showing several reports In my modify staff form...

I have Access 2007 and I'm creating a student admissions database. One student can create one application per year So over several years one student can create many applications. Each application contains three Course options How do I (or can I) create a form which I can add the students...

In the old(er) Access of around 2000-2003 you used to be able to create a form, set it's size, where it pops up on the screen and it's general appearance. I see most of these features still exist however, I'm having one major problem. All the forms I create, seemingly appear maximised to take...

I'm hoping to password protect the Access 2007 application using a automatic start up form with a password to allow people to continue to the main menu. I'm hoping to have two levels of password, an admin and regular user. I was hoping to hide certain buttons and labels to the regular users...

Hello All! Just started to make a database to register students and their applications to a university and already I've managed to hit a brick wall. Apparently my ApplicationHeader and my ApplicationLine table cannot be joined because the relationship is indeterminate. One Application Header...