Search results

Hi, I have a form, with three different sub forms on it. Rather than us the record counter at the bottom of the subforms, i'm creating my own using this code: Private Sub Form_Current() Dim rst As DAO.Recordset Dim lngCount As Long Set rst = Me!subform.Form.RecordsetClone With rst .MoveLast...

Hi, I'm in a bit of a fix with this one, and due to my lack of knowledge about VBA/SQL I'm stuck using the query functions which Access 2010 has given me to play with. I have a table, which is being populated by a number of users. The table has 211 rows (customer field - this is a fixed...

Hi, I have a database which 10+ people use. I want them to be able to edit their own details (password, email address) rather than having to ask an administrator each time. I have a form (based on a query) which pulls up just their user name and current password, but I want a field beneath...

Hi, I have attached a test database, which when logging in, records the time you press "enter" and "quit" on the menu - username and password is "test1" However, I can't get this to work WITHOUT the parameter box popping up. Does anyone have any ideas? I've been trying to figure it out all...

Hi, I'm a bit of an access novice, and I'm not good at all with coding, so please bear with me! I have a database, with a user login, and that takes you to a "menu" where you can choose to enter, change user or exit. Users would then press enter to go to their home page, determined by what...

This is a bit complicated, and I'm a novice so bear with me please.... I have a database, which is essentially based around one big table with lots of data in. I have several queries/forms relating to this data, pulling off bits where needed. The field in my main table are Country, Type...

Hello, I'm a total novice when it comes to using code (and access generally!) and am having problems setting up my database to send emails, using access 2010. I have a form which assigns tasks to different people, with a button to send an email alert when a new task has been assigned. The code...

Hi, I really hope someone can help because I'm totally stuck! I've created a database which is used by 4 different "teams" of people, who can only see various bits of information relevant to them. As part of this, there is a "task manager" section, where people can assign tasks which have come...

Hi, I don't know if anyone can help, but I have an access database with three main user groups. They're all similar, but I want to be able to hide certain information from certain groups. I'm looking for a piece of code, or macro, so that when a user clicks on something, depending who they...

Hello, My previous query was solved brilliantly on here but unfortunately now I have another! My database currently has three logins, one for "research", one for "admin" and one for "service", and depending on which is logged in, a different form opens next. I'm now looking to expand this to...

Hi, I'm a total novice when it comes to using Access, but I'm making slow progress! I'm using 2010 and have created a database with two main functions - one is to add records and the other is to view records. There are 5 users adding records, and at the moment they all use one login, and then...