Search results

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

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

How can I make 2 exact copies of the frmNz form that I have with the exact same coding working for the copies. I have tried to make copies but have been unsuccessful. It is attached. Gurdip.

I have a form called frmNz in which I would like already existing data to appear in the comboboxes. For example, in the Business Name combobox I begin to type Can... and "Canalside Ltd" appears, ready to be selected. Or, in the Country combobox I begin to type Unite... and "United Kingdom"...

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, including these companies' information? There is an attachment. Gurdip.

On the frmNz form 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 grey...

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