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...
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.
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...
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...
TheAceMan1, I have tried that coding but it does not work. I enter information into the form and submit but no results show. Do you mean for me to put a primary key textbox onto the form?
The system is to be designed so that company data can be retrieved easily, just by typing the Name or...
JoeAtWork, I am trying to create a form on which I can enter some data about a business in any of the fields and then press a search button. This will then retrieve the data for the business and display it. I am looking to get the data to be displayed on the same form so that it can be used from...
This is the coding in the new query, is this what you mean?
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...
The UK Table has a primary key called Business ID. The data type for the primary key is autonumber. Do you mean I should use this code for the criteria of the primary key field in the query? Do you mean I should use this code for the primary key field's criteria alone?
Gurdip.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.