Recent content by Screaminxpert

Please forgive me, I have absolutely no idea how to do what I am asking. I need the Field - User: to be set with the current users (windows login) user name. The aim of all of this is for a sales agent to be able to request leads as they need them and to never be given the same lead twice in...

OK, so I have created the Table and a form, I am now having trouble making the User Field populate with the current user when the record is opened in the form. Could someone advise on the easiest way of doing this?

So when the record is opened the field would be populated with the user?

Hi, I was wondering if someone could advise me if it is possible to lock a record to a user and when another user requests a record from a table they are not displayed records locked to another user. I am designing a Lead Distribution database and this is a fundemental part of the design...

I have never used ACT so I dont know it's capabilities and we need an option that is cheap/free (hence be building a database). I will take your advice and start with a contact database and then see how I get on from there. Thanks

Hi All, I am looking for some advice/help creating a new database for our business. I have some knowledge of Access but will need someone to guide me through this project. I was going to outsource this project but at £4000 it was a big ask so I am attempting it myself. The basics of the...

Hi, I have a number of forms in an Access 2007 application, the forms have a number of List Box controls which have a default selection of 'Select', this is set by the table. Some of the list boxes are mandatory and Access is allowing the record to be saved as 'Select' is already selected...

I use a Front End - Back End scenario on my database so I would like to throw in what I have learnt. I dont know if what I am doing is the correct way but it works. Firstly I have the front end and back end on a server, every morning or when users log in to their PC a batch script runs which...

Ok thanks for the quick replies, as I said in my original post I am a bit of a novice with access and I am especially not good with VBA, could point me to a guide or give me some instructions?

Hi I am currently using a Macro and using the SendObject action this allows me to specify the recipient, subject and body.

Hi, Sorry if the title is not very clear, I was not sure how to simply word what I am trying to do so here is the longer version. Currently we have an Access 2007 DB with a button on a form that opens up a new email with the subject and body filled in, all the user needs to do is click send...

Hi, The text box is not created using a form, it is created by the VBA code posted in my original question. Thanks

Hi All, I am using to VBA code on my database to protect a form with a password, I need to know how to create a password input mask in the text box, below is the code I am using... Private Sub Command231_Click() Dim stDocName As String Dim stLinkCriteria As String Dim PassWordtxt...

Now I am not sure if this is even the right thing for what I am trying to do. I dont know if I can reference this to a specific user as we have about 20 employees, 16 of them will have no access to this information and 4 will. If anyone has any ideas how to achieve what I am trying to do...

Hmmmmm, I am trying to get the code to look at the current user looking at the form and if their access level is >=50 there will be no input mask if it is less <50 then there will be a password input mask. I dont even know if I am coding it correctly!