Search results for query: *

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

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

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

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

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?

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.

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

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

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.

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.

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

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.

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

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

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

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

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.

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

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

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