Recent content by Charlottew14

I can't seem to make it work accurately without the MoveLast, and my I don't have enough code experience to really understand much of it!

I'm clueless when it comes to code and a beginner at Access, so I just kind of go with whatever works so I don't know any alternatives to MoveLast :S

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...

That sounds like a plan, but does it have to be done in vba (I have zero coding experience!) - I've changed the type of query but it now wont let me base a form on it :/ Thank you for your help.

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...

Thank you for your help everyone, it works now :)

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 like that method, but I'd prefer that the user didn't see the information captured, especially about other people that have logged in and out. I've attached a sample of my database, so you can see how the login/menu screens work (username: test & password: test). Ideally, I'd like to...

Thanks for your reply, but that sounds far beyond my capabilities!!! I've been trying to do in a simpler way - though much less sophisticated - by having a hidden form opening at the same time as the menu screen to record the login time, pulling the username from the menu. However, I can seem...

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...

Is there any way to add this to the body of the email, rather than the subject? Many Thanks :)

Thank you so much for your help, it works perfectly :) I do have another question though - is it possible to select a text box to be added to the content of the email - eg. a description of the task that has been assigned??

Hi, I've made my combo box so that there are two columns in it - the username, which is the one you see on the from, and the email address which you see when you click on the arrow to select, but doesn't appear on the form - how can I tell the code to look at the second column? If I can do it...