Search results

This answer may not be exactly what you are looking for but it is how I work. I hope my comments are helpful. I try to avoid using complex code. I like to keep life simple. My way of achieving what you want would be to: 1. Create an unbound text field. 2. Make it a password field by typing...

Many thanks for your suggestions. All I have is 3 buttons each sends an email using the SendObject command to a different group of people. The email includes text and fields from the table. The database is an inhouse application that will be used by a very small known group of people. They...

In the above expression the [FormName] refers to the parent form. The child form will follow the parent form. The macro should do the following: > Open the form based on the criteria the user gives. (I would get the user type their id in an unbound field on an unbound form). > Run the above...

When the user enters their id either code or a macro runs to open a form/report that shows their details, am I right? If so, use either a macro with a condition or an If ... Then ... statement in your code. In both instances if the record count = 0 it means the users code is not found (no...

I have a form that has several buttons, 3 of which use the DoCmd.SendObject action to send an eamil, (each email is diffent from the other). There may arise an instance when in operation a user needs to send 2 or 3 emails consecutively to different people. There is never a problem sending a...

I know the following would work if the 'End' field was in the form I am trying to open but its not. The 'End' field is in a subform of the form I am trying to open. The subform uses a different data source to the main form. DoCmd.OpenForm "LinkFm", , , "[End]>= Forms![menu]![Text10]" If...

Creating multi-user applications is generally achieved by splitting the database. Access has a database splitter feature that is available from the Tools menu. The tables are stred on the server and the forms are local to each user. Please note you will still get sharing violatuions if 2...

Access queries cannot calculate column totals. Crosstab queries cannot be sorted on the calculated columns. Basically they give you a calculated value in the row-column grid and a row total.

From what you have said I'm not sure if I am on the right track as it were, so please forgive me if I'm way out. It reads like you had your query working but then you changed some fields, perhaps you changed the field types, e.g. from a text box to a combo box and you have also changed the...

I have a database that loggs the jobs each employer does each day. One can enter job details, a start time and an end time. I would like to prevent someone from entering a start time that is before the end time of the previous job. I have been trying to do this as a validation rule in the...

Many thanks for your help - problem solved. The relationship between the master form and the subform is a one-to-many relationship. I needed the form, upon opening to find a particular record in the main form (a name)and a particular record in the sub form (a date) which is a starting point and...

Help!!! I would like to make a form open based on two values. One value is in the form and the other value is in one of the subforms. Any ideas will be gratefully received.

I have comeaccross this several times, usually when the report has several memo fields that are full of long 'essays'. I am not sure how you are exporting the data, presumably from a report. Presumably you create an RTF file which is then opened up in Word or you use the Publish with Microsoft...

Superb, I'm glad it works for you. Please let me know the final outcome. One thought I have just had, (thinking on the hoof). I have put subforms in a tab page before today. If you can do that you could activate the message box from the OnFocus event of the subform. It might work better because...

I HAVE JUST TRIED THE IDEA I HAVE EXPLAINED BELOW AGAIN AND IT DOESN'T ALWAYS WORK, SORRY. For example, if/when the controls loose their focus! My idea depends on how or if you are able to shepherd users around the form??? The above text was added after I wrote the text below...

My database contains the following code that saves the record and sends a report by email as an attached file using the SendObject command. My problem is that the database runs this code onceperfectly, and then it wont run it again. i have to close and reopen the database in order to get it to...

Many thanks, works a treat!

You can use the maco action SendObject. This is quite a powerful tool that gives many options to design the e-mail or leave the options blank so they are user defined. You can then create a command button that runs the macro or you can run the macro from an event on the form. [This message has...

I have seen many examples of how to change the text colour of a field in a form on condition of say the value is >50 or the value = "Yes". But I cannot do this in a report. Any help will be gratefully received. Many thanks.

Create a macro and use the MsgBox action to define type of message box, e.g. Information, Warning! etc. You can also type the message you want your message box to display. Save and close the macro , eg MsgMacro. Open your form and select the field. Open the Properties box (right click mouse...