Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by soorags

  1. soorags

    Cancelling changes in a form Version: 2003 (11.0)

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

    Adding new information via a form

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

    What does the... & "*"... represent in the following statement?

    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 &...
  4. soorags

    Making forms editable!! Mail merge!!

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

    Editting/ Saving Information on forms and a mail merge command button

    I would also like to make frmNz2 and frmNz3 editable.
  6. soorags

    Editting/ Saving Information on forms and a mail merge command button

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

    Mail Merge Module

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

    Mail Merge Module

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

    Replicas of a form.

    It is okay now, I have fixed it.
  10. soorags

    Mail merge command button and adding new business information.

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

    Saving Edited/Deleted Information on Subforms (forms)

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

    Replicas of a form.

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

    Mail Merge

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

    Replicas of a form.

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

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

Part and Inventory Search

Back
Top