Recent content by Lee83

Read/Write Settings Do you mean as in the properties in explorer when you right click? If so, no I didn't set it to read only in there but when I saved my newly updated d/base it automatically set that property and when you untick read only and apply, it just reapplies it again straight after...

Input Box with astericks **** Hi, I am new at using VB and am creating a database for work. I have a form that has an administrator button that once clicked prompts you for a password. Here is the code that I entered for that and it works fine. Private Sub Administration_Click() Dim strInput...

I got the user and admin passwords working so that when you open the database it asks you to logon and I set permissions so that users can't delete data from tables only adminstrators can. I emailed it back to work and still had the original on my workstation saved in a different location when...

Email Report Thank you so much for all your help It is greatly appreciated you saved me a lot of headaches! This all worked and the report was emailing with the current record that had been entered into the form however, after I updated a table with some information, and split the back end...

Autofill Fields Thanks That was very helpful! and is all working now I ended up using the following; Private Sub Scope_Change() Me.Est_Man_Hours = Me.Scope.Column(1) Me.Normal_Rate = Me.Scope.Column(2) Me.Overtime_Rate = Me.Scope.Column(3) Me.Est_Due_Date = Me.Start_Date + Me.Scope.Column(4)...

Att: Kempes - Code for Setting Criteria Thank you This does point me in the right direction however, I am not sure exactly how to code it so that it filters only the current record in the Services Request table are you able to help me with the code for this? This is what I have; The Report...

Hi, I have a form that has a field called scope of work which is a combo box that you have 3 options to select from. I have set up a table called scope of work which has other fields ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date. The combo box works fine...

Hi, I have a form that has a field called scope of work which is a combo box that you have 3 options to select from. I have set up a table called scope of work which has other fields ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date. The combo box works fine...

Hi, I have A form that you fill in and when you hit the send button it sends a SNP view of the related report to an email. This works fine but the report doesn't send the current record of what has just been entered into the form. How can I tell it to send a report of this current record...