Search results for query: *

Thanks for the suggestions. I opted for the 5 x 5 matrix using the INDEX and MATCH, which worked a treat!

Hi Is there a limit to the number of logical tests that can be applied to a function in an excel cell, for example the following stops after the 6th logical test i.e IF(AND(C14="L",E14="VL"),2...

Hi Im trying to install outlook 2003 on to a laptop containing Windows 7. I've entered the correct incoming and outgoing server details i'e pop3.virginmedia.com and smtp.virginmedia.com and used the correct port details according to my ISP, however it wont connect. Is there something i'm...

Is it possible to put more than one hyperlinks into a single cell in excel?

I want the pivot tables in an Excel 97 spreadsheet to refresh automatically when a user makes a change. The code used on save(from a recorded macro) is : [Worksheets("Sheet1").select Worksheets("Sheet1").PivotTables(1).PivotTable "", xlDataAndLabel...

Thanks not used that before. Returns the correct information, just got to work out how i use it in VBA?

I have a unique value on an Excel form. How can i use that value to look up the row number on another worksheet where that value is also stored. Thanks

Thanks for your help

yes, using the scroll bar to move through the records until i reach a new blank row. i was wondering if there was a keyboard shortcut such as moving to the last row e.g. contol + down arrow

is there a quick way to move to a new row in Excel?

Thanks for the advice, i'll try and get my head around it or wait until the user upgrades their version of Access!

The database i have written is split via a Front End(FE) and Back End(BE). I have used the Class FileDialog to give the user the option to search and relink the files if the BE moves. This I believe is a member of the Microsoft Office 10.0 Object Library. The problem is the user does not have...

NB: Remember to reset the filter - Me.Filter = "" after the report has run

ok, solved it, just added Me.Filter into the criterion.

I have a form that displays all the records from a table. On this form i have a button that runs a report displaying the same records. What i want to do is apply a filter to the form and then run the report displaying only the filtered records from the form.Is this possible? I assume i have to...

Yea, that's it. The Forms! was missing. Thanks for your help.

I've tried both ways. By putting the & before and after [frmDeleteBaseData]![cboRecord]the query prompts me for a value even though the form is open and a value has been selected from the drop down box cboRecord.

I'm trying to delete the records where part of a field will = the value in a drop down box e.g. DELETE tblReminder.*, tblReminder.memReminder, tblReminder.blnSystemGen FROM tblReminder WHERE (((tblReminder.memReminder) Like '*[frmDeleteBaseData]![cboRecord]*') AND...

Yea, i thinks thats done it - use file instead of folder. Thanks

The following should pop up the file dialog folder picker Dim fd As FileDialog Dim varSelectedItems As Variant Set fd = Application.FileDialog(msoFileDialogFolderPicker) With fd .Title = "Link CATSData file" .InitialFileName = "CATSData" .InitialView =...