Search results for query: *

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

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

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

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

I have a form which uses data from several subforms to populate a table. The subforms are based on several queries and other tables, but they all have one thing in common. When there is no data, the text boxes in the main form which look at the subforms display #Error. I have tried Nz and IIf...

I am trying to open a web page using four fields selected from a table as part of the URL. I think I have tied myself in knots with inverted commas, and I would be grateful if anyone can point me in the right direction. My VBA code is as follows: Dim MyHyperlink As String...

I have a spreadsheet in Excel 2003 which has a number of worksheets which each look up data from separate files in our company web site. Each of the originating spreadsheets is separately password protected, and when the master sheet is opened, it requests passwords in sequence from the...

I have an Access database which records data relating to company branches on a weekly basis. Some of this data has to be presented on a monthly basis, and I have extracted the 'month' integer from the date to faciltate this. My problem is with a couple of fields where I have to present the...