Search results for query: *

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

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

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

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

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

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

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

I have a textbox on worksheet(1) called txt1. Is there anything wrong with the following as i can't get it work: strC = "txt1" debug.print worksheets(1)(strC) or debug.print worksheets(1).strC the error produced is 438 'object does not support this property or method..' Thanks

I have 2 controls on a spreadsheet. The first is a textbox the second is a listbox using multi select. When i exit excel and reopen, the value in the textbox is retained but the value is lost in the listbox, am i missing something obvious?

I have a spreadsheet that uses a custom menu bar to navigate to worksheets (tabs are hidden). It uses the sheet number to identify it e.g the first worksheet is 1 the second is 2 and so on...The problem is if a user changes the order of the worksheets the navigation menu becomes screwed up!I've...

The following codes takes data from an Access database and dumps into a table and form field of Word. The run time error occurs at the select case statement - case f17, which is trying to put the data into the word table. Any ideas what's wrong?? please. Dim varX, varForm1900, varDB1900 As...

How do you tell which page is being displayed in an access report, via code. I want to be able to have a different text value in the footer for each page displayed/printer. e.g page 1 = Part A-1, page 2 = Part A-2 etc. Thanks

I have an unprotected word document with form fields, when i protect the form the data is lost. I know that the 'Reset FormField' button on the forms toolbar will undo this but i need to be able to do it programmatically via code - does anybody know how to do this?

Is it possible to link to tables in another database that are themselves linked to another database. They don't appear in the linked table manager. Thanks

I have a number of linked tables in my database. The user needs to be able to delete the contents of any of these tables when required. Is it possible to pass the name of a selected table to SQL? I've tried the following but it does not work: Table name is selected from a list box and stored as...

Hi The database i have written (Access 2003)runs on Windows XP. It process large amounts of data of a monthly basis (approx 750,000.00 additional records each month!). Everthing runs fine on my platform/envrionment however the user i have written the system for has started to get the error 3052...

How do you stop the detail in the page footer from appearing on the 1st page of a report?