Search results for query: *

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

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

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

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.

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

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

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

I have made a form that works fine called frmNz. However each time, the query qryNew keeps on changing, either becoming blank or too complex. This keeps on happening. I keep changing it to the SQL coding that I wish but when I save it, after, I go back into it and it has changed and the form...

I have a form with textboxes that I have changed to comboboxes. I would like existing table information to appear when I begin to type into the comboboxes. E.g. for the Business Name combobox when I begin to type a Business Name, if company information already exists the name appears. For...

How can I get this to work on my form? Selecting some companies from the subform and then clicking on a "Mail Merge" command button to run the Microsoft Word application with mail merge and these companies' information? Gurdip.

On a form called frmNz I have added 2 checkboxes, Website? and Email? (i.e. is there a website and/or email?) I would like it so that if these are selected with ticks then website and email addresses can be entered into the below textboxes, otherwise the website and email address textboxes go...

On the "View Directory" form of my database I would like to allow the user to be able to fill in AT LEAST one piece of information about a company so that when he or she clicks on the "Submit Information for Search" command button, the table below shows the results that have been searched for...