Recent content by soorags

On the form frmNz2 of my database, how can I make the Back button cancel any changes made to the information in the Search Results table after it has been editted? When I edit the information in the table and then press back, when the form is re-entered the changes stay. I would like these...

I have created a standard form to add new data to my database but when the form is opened it displays data already stored. I then have to scroll through all of the data shown on the form to the bottom using the mouse wheel where I can add new data. How can I change this form so that it does not...

SELECT [UK Table].[Business Name], [UK Table].[Business Type], [UK Table].Address, [UK Table].City, [UK Table].Country, [UK Table].[Telephone Number], [UK Table].[Website Address], [UK Table].[Email Address] FROM [UK Table] WHERE (([UK Table].[Business Name] Like Forms!frmNz!txtBusinessName &...

How can I make forms frmNz2, frmNz3 and frmSearchResults editable? Their AllowEdit, AllowDeletion, etc, properties are all set to Yes. The first two forms contain subforms, within which I would like to edit the information. The other form displays each of my records but does not let me edit...

On my database I would like to know how I can make the frmSearchResults editable. How can I alter information on this form? Also, on frmNz2 and frmNz3, how can I use the 2 command buttons to save the editted/deleted information on them? (I would also like to make these forms editable). Also how...

I have tried to use the coding on http://support.microsoft.com/default.aspx?scid=kb;en-us;209882 to run an automated mail merge on my database. Can anybody tell where I have gone wrong? I have attached the database, look at the MailMerge module and see if you can tell. Try testing it. I get an...

On my database system I have a View Directory form. On this form I have a 'Use Mail Merge Facility' button. I would like to be able to select companies from the subform and then click on this command button. I want this command button to then open up Microsoft Word Mail Merge so that a letter...

I have created 2 forms called frmNz2 and frmNz3. I would like to be able to press a command button that would save the editted/deleted information on both forms (in the subforms). How can I create them? Have a look at the attachment, the buttons are created but I don't know how to get them to work.

I have a form called frmNz. I have tried to make 2 copies of the form called frmNz2 and frmNz3. For these 2 forms I have made seperate queries and referenced these forms in them so that they work exactly like frmNz. However when I click on either of the copied forms' command buttons (Submit...

On the 'frmNz' form I would like the 'Use Mail Merge Facility' button to work. I would like to be able to select companies from the subform and then click on this button, which would then make Microsoft Word open up with the mail merge facility, creating a letter to be sent out to the selected...

The two copies of the frmNz form do not work. That is the problem.

On form frmNz I have changed the source object to frmSearchResults, and the source for this form is qryNew, not Query 2. The coding on the 'Submit Information for Search Button' is for Query 2, but the frmNz form still works the way that I want. If there is anything wrong with this please let me...

Replicas of a form On form frmNz I have changed the source object to frmSearchResults, and the source for this form is qryNew, not Query 2. The coding is for Query 2, but the frmNz form still works the way that I want. If there is anything wrong with this please let me know. Now that frmNz...

This is my latest file. I have copied the database to a new one. From another forum I was told that I should use filter coding and have done so for the 'Submit Information for Search' command button (On Click event). I have also changed the subforms source to 'UK Table'. However the coding that...

When I tried this first and then used the form it wasn't working properly. The form was not searching correctly.