Search results

Hi I have various forms for users to enter data. When the form opens I wish to warn them of about the form adding records. To this end I have created a public sub Public Sub AddRecordsub() Dim Message, Title, MyValue Message = "Entering This Form Will Add Records. Are You Sure This Is What You...

At the minute I want to hard code the password, hence the module so that If I want to change the password, I only change in one place not in every form. I have looked at the security settings for users but at the minute cannot think of a way around my problem. My original problem is that I want...

Thanks, removing the (Me.Name) worked Enjoy the rest of your Sunday

Bob Have tried both of your answers Answer 1 caused a compile error with the 1st line of the module code with the word As highlighted by Access Answer 2 causes a compile error with the code in the form saying I have the wrong number arguments any thoughts

Hi I have various forms which are set to Allowedits=False to prevent accidental overwriting of data. Each of these forms has a command button which changes Alloweditsto True. Now my boss wants to password protect these buttons for added security. I have created a module that will create the...

Currently the enquiry details (enquiry ref, client name, details, date of enquiry)are stored in the table 'tbleeaenquiry' and the costing details (materials, labour, overhead buildups) are stored in the table 'tbleeaquote' The form (frmeeaquote) discussed was linked to table 'tbleeaquote'. The...

that was not how I typed the question list box looks like this quote ref------subref-----materials-----labour 1---------------a---------£500---------£500 1---------------b---------£500---------£500 --------------------------totalhere-----totalhere How do I get the totals to show in the space...

Thanks for that I now have a list box which looks something like this quote ref subref materials labour 1 a £500.00 £100.00 1 b £500.00 £100.00 Totalhere Totalhere How do I now...

Thanks The sub form is showing a summary of the records with the same (enquiryref) from the main form. If a sub form is not the way for this, what would be the best way to display this information on the main form.

Ok have checked the field name and it is typed correctly, the box name and the field name were the same, have made the changes you suggested but still no joy. The field is also on the main form with the same record source but with a different text box name could this be making the difference??

Still getting #error after entering the revised string

Hi I have a subform (frmquotesubfomr) which is displayed on main form (frmquote). The subform shows all the records related to a field (enquiryref) on the main form. So far so good, now what I want to do is total one of the fields (materials) displayed in the subform in the subformform footer...

Hi Trying to run a report which will look at a field and if a persons name appears in that field the their signature will be visible on the report, if it is not there name then another person signature will appear. I have put the if statement below on the reports Details section in the On...

I would like to run a query for quality assurance that selects a random 10% of records with the same date. Is this possible and if so could I have some pointers regarding the 10% bit and the Random bit. I am ok with the general criteria regarding the date field. Many thanks Richard

If you have multiple users at the same time then you really have no choice other than to split your database. Tips Make sure you keep a copy of the front end for yourself so that you can make changes and check they work before copying the revised front end to each user. If you make changes to...

Else would be the answer Thanks Richard

Have posted code into the 'On Format' event of the Detail Section of the Report and still getting the same result Any further thoughts Richard

I have had a problem similar where the printer was not compatible with Access and all the reports would not open when the non compatible printer was selected as the default printer. Maybe try and see if the thermal printer is compatible with Access 2007 My problem was only with access. Word and...

Sorry for the poor thread title. I have a report[Lab Sheet] based upon a query [Lab Sheet Query] which selects values from a table. One of these values is from a checkbox, so we have records which may return a value of -1. I have created an if statement in the 'on activate' event of the report...

I have a form which has a combo box which allows the user to display all the record details on the main form. Also attached is a sub form which shows all the other records that are related to the record being displayed on the main form. The user can click a command button on the sub-form which...