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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hansretallick

    Problem with unique records

    1 = Email, 2 = Home phone, 3 = Work phone, 4 = Mobile phone Although this secondary table potentially could list any number of contact details (that was the thinking behind using a separate table) I only want to import the first four types of contact Thanks Hans
  2. hansretallick

    Problem with unique records

    I have a database which imports from another one using ODBC. In my database,the contacts table shows every detail of a contact as one record. The import database uses two tables for contacts, one which shows name, address etc, and a second table which uses the same key as the main contacts...
  3. hansretallick

    Access 2010 reports

    I've solved it - I've gone back to an earlier version, and changed the way the reports displayed (as "Report" rather than "Print Preview") and that has worked - a similar solution didn't work in the latest version for some reason. Many thanks Trevil for helping me - I'd still like to know what...
  4. hansretallick

    Access 2010 reports

    Oh dear, not that either. I'm racking my brains to see what the problem is, but so far no joy.
  5. hansretallick

    Access 2010 reports

    Sorry to be stupid, Trevil but I'm not very good with code. Do you mean where code "Option Compare Database" is , then follow this with "Option Explicit" on the next line, or replace that line?
  6. hansretallick

    Access 2010 reports

    Thanks Trevil, but I had already added in the trusted location - I have just checked in Trust Center and reset to allow everything, but still no result. The function buttons appear, but they can't be clicked in the reports.
  7. hansretallick

    Access 2010 reports

    I have placed buttons on my access 2010 reports to performs such functions as print PDF, close report etc, but they only function when I open the database holding the shift key down. I have tried switching things like Allow Full Menus, Allow Default Shotcut Menus, Display Status Bar, Enable...
  8. hansretallick

    Reports with multiple criteria

    I need to open the same report from different forms. Either form selects a filter (TenancyNo) and the query opened by the report needs to make this field the criteria for the result to be displayed. I have tried using an OR statement, which works OK, however, when opening the report, an error...
  9. hansretallick

    Go to new record on a form

    That was brilliant, TheAceMan1. Works perfectly now. Very many thanks for your help, and also to everyone else who tried to help me make sense of this.
  10. hansretallick

    Go to new record on a form

    Thanks for your reply, PHV. Unfortunately I get error message "Run-time error '2046': The command or action 'GoToRecord' isn't available now. I am using Access 2010 by the way.
  11. hansretallick

    Go to new record on a form

    Hi Randy700 and TheAceMan1. Many thanks for your replies. I must admit that I was in a rush and didn't explain properly what I am trying to do, and also made some mistakes in my original post. I'll start again. The form is used to open a report based on a record which is selected by means of...
  12. hansretallick

    Go to new record on a form

    I have just noticed that I stated "I have used the following command in the "on Close" event for the form" - I meant the Report rather than the Form.
  13. hansretallick

    Go to new record on a form

    I have a form which opens a report. When the report closes, I want to go to the next record on the underlying form which remains open while the report is generated. I have used the following command in the "on Close" event for the form, but I get an error "The command or action 'GoToRecord'...
  14. hansretallick

    Open form and show or hide controls depending on data

    Many thanks, Ace Man. That works perfectly. Kind regards Hans
  15. hansretallick

    Open form and show or hide controls depending on data

    I have some controls on a form open that are shown or hidden depending on whether or not there is data accessed by queries. I have decided to default to the controls being visible on form open, and if the query results in no data, the controls are then hidden. For some reason the controls are...
  16. hansretallick

    Populate sub form from main form

    Also many thanks, JB for your help with the code - not my strong point, I'm afraid.
  17. hansretallick

    Populate sub form from main form

    Many thanks. I did try that before, but it didn't work. It still didn't work with your code, but on looking at the sub form again, I discovered that it's record source had become bound (lovely Access "help" I guess. Unbound the form and it worked perfectly. Many thanks.
  18. hansretallick

    Populate sub form from main form

    I need to populate severeal fields in a sub form as an after update event procedure from a combo box. The main form sets fields as a result of the combo update - one example is CloseDate which I need to be inserted into a CloseDate field in a sub form. I have tried this code, but it doesn't...
  19. hansretallick

    Zero length strings

    Fantastic, PHV. Such a stupid thing and it now works perfectly. Best regards to you and to Paul for your help.
  20. hansretallick

    Zero length strings

    Thank you Paul for your suggestion. I have visited the link, and done what was suggested, but I now have #Name as error message in the relevant fields. I might have done something stupid, so please forgive me if I describe what I have done. I have created a module called nnz in the...

Part and Inventory Search

Back
Top