Search results for query: *

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, 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!!

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

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

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 have a form with a subform showing a datasheet of overview information. I would like to be able to click on a line of the datasheet and open a new form with all the information from the clicked record that the user can edit. How do I do this? Thanks

Hi, I am trying to filter a subform based upon the selected entry in a combo box. I have a button that has the following code: Private Sub ButFilter_Click() Dim strFilter As String strFilter = "" If (Not IsNull(Me![CboSource])) Then strFilter = "([Source] = " & Str(Me![CboSource]) & ")"...

Hi, I have a table called Accounts and a table called Contacts. There are many contacts for each account so I would like a combo box with the Account names (selected from the Account Table) to populate a subform. All the data to be viewed is to be read only. I have created a form created an...