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 where I can add new data. How can I change this form so that it does not show the rest of the...

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...

I would also like to make frmNz2 and frmNz3 editable.

On my database I would like to know how I can make the frmSearchResults editable. How can I alter information on this form?(It is a standard form like those you can create with the form wizard.) Also, on frmNz2 and frmNz3, how can I use the 2 command buttons on them to save the editted/deleted...

Im using Word 2002. I have changed the coding now anyway.

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. It doesn't work. Tried testing it. I get an error. My aim is to be able to use the 'frmNz' form to select businesses from the subform and then click...

It is okay now, I have fixed it.

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 command buttons that would save the editted/deleted information on both forms (in the subforms). How can I create them? The buttons are created but I don't know how to get them to work.

I have done this but an error still appears when running either of the copies with the same command button. It says: Run-time error '438': Object doesn't support this property or method. This happens even when creating 2 new queries for each new form.

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...

I have tried these methods but the copies are not exact. i.e. they do not do exactly what frmNz does.

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...