Search results for query: *

Hi - Thanks for the post. The folders are definatley in my archive.pst file (under Archive Folders in my folders list). As I say the file itself is really big and what I can see is a fraction of that size. I'm really stuck.

Hi, I recently had to recreate my outlook 2002 profile as my old one had become corrupt. When I tried to connect my old archive file (archive.pst) to my folder view it only displays a few of the many folders I had saved. The file is over 250MB in size and clearly what I can see in outlook is...

Hi - Thanks for your post. I was able to add new hardware and the Ports (COM & LPT) appeared in my device manager again. However, COM1 and COM3 are missing and instead there is just a COM4 with an Excalmation mark next to it and I still can't dial out. Any suggestions? Thanks again. Nosh

Hi, I started having problems with my modem and realised that the Ports were missing from my Device Manager. I have recieved some advice that says to add them back manually but I have no clue how to do this. I've had a look in the BIOS and can see nowhere to do it. Can anyone help please? Ta...

Hi Guys, I started having some problems with my modem and after some investigation I found that Ports are not listed in my Windows device manager. Does anyone know how I can get them back? Thanks Nosh

Hi Guys, My boss has asked me to look at a spreadsheet he uses to highlight issues. He wants to type the Value "HR" into a cell and for the background to go Red and for the text in the cell to change to say "H". Using conditional Formatting I can get the background Red but I can't change the...

Hi Guys, I have been given these two questions in a test prior to an interview. I'm not a DB2 DBA but a programmer so I don't know why these questions are in there! Can anyone help with the answers please? Other than using SET NULL, how would you place the NULL values in table columns from a...

Hi, I have used Excel for many years and have come accross a problem that I don't understand. In one of my worksheets I have tried to input the following refernce that refers to a text cell: =N7 Instead of resolving to the Value in N7 the value of the cell is "=N7". Has anyone come across...

Hello, I am using this code to export data to an Excel spreadsheet. It was working fine when I hard coded a file name ("Prospects.xls") but falls over when I try to make the filename equal to the current time + Prospects.xls (e.g. 21:43:23Prospects.xls). Can anyone tell me what I'm doing...

Hi Guys, I have a subform with a datasheet. I use the following line of code to output the data to an Excel spreadsheet. DoCmd.OutputTo acOutputForm, "subProspects", acFormatXLS, "prospects.xls", True This copies all data from the subform into Excel. What I would like to do is export only...

Hiya, I have a database that links to tables on my J: drive. Other users need to access this data but have mapped the same drive to their G: drive. How can I link a table to a drive name (eg //solits1/database.mdb) rather than a drive letter?? Any and all help gratefully received!!

Thanks both

Hi, I have a form with several text boxes. When I click the save button I'd like to run some code to check that if the status field is set to "C" that the closed details are also populated. I have the following IF statement: If Me.Status = "C" Then If Me.cboClosedCode = Null Then...

With your combo box you need to go the data tab of the properties and set the Limit to List property to YES. Make the Row Source Type = Value List and set the Row Source to "Mr";"Mrs";"Miss" (plus any others you want). This will limit users to picking only those values in the list for the combo...

Sorry - it's a form with several text box controls on it. On some of the controls if I go to the Tab Index property and click the three dots (...) I get a list of available controls to sort. For some reason this list doesn't contain all of the controls. When I click on one of the controls that...

Hi, I have a form that has several fields. I want to tab down the list to enable quick data entry. However I seem to have two tab lists one one form. One list has most of the controls and the other list has some other controls that I added recently. How can I get all of the controls on that...

Oh I see. Thanks for your help. You have saved me a LOT of headaches!!

Fantastic!! - It worked. Tell me all... Thanks

Hi guys, I am trying to filter a subform to list only those records that have an Action Date less than todays date. I am running the following code: Private Sub butOverdue_Click() Dim strFilter As String strFilter = "" strFilter = "[Action Date] < #" & Format$(Date, "dd/mm/yyyy") & "#"...

I don't believe this... and I thought it was all sorted! I thought that the date search was working but it isn't. The filter shows all rows where the date field is not blank and all other dates even those that are greater than todays date. The help in Access is rubbish - I really didn't want...