Search results for query: *

Hi All: I haven't used Access in a while, so bear with me. I am working with 2 files (1) TableA (an Access 2000 format database) and (2) FileB (an Excel file). I am trying to write an update SQL that would update TableA-Field-1 with FileB-Field-1 only if TableA-Field-1 is blank or is Nulls and...

Hi: I have an issue with my Windows XP (Home Edition) booting up correctly. The system boots up fine but after it says that is s loading "Personal Settings", it starts powering down (saving your personal settings, closing connections etc.) and then reboots. It's stays in this loop and doesn't...

I am using Outlook 2007 and did a test to see if I can export duplicate emails into a new pst file. I created a pst file (called test1) and placed several emails in the Inbox. I copies the same e-mails again into the same Inbox (in essence I ended up with duplicate emails in test1.pst inbox). I...

Hi: I have several folders on my local drive which contain many sub-folders and many files, within the main folder. How can I copy the entire folder without having to copy the individual files ? thank fb

I have a .bak Outlook 2003 file which I would like to revert back to a .pst file. How can I do this? Thanks in advance. fb

Hi: I have a report with the following columns in the detail section (the report consist of a Page Header, Detail section, Page Footer and Report Footer. Her are the fields going across the page: Division, Name, Job Title, Location Document Code and Count. I would like to supress multiple...

Hi All: I am printing a report (consisting of a summary and a sub-detail report) which I would like to enhance the formating based on the condition of a specific field on the report. So, "On Format" if the value of the field (DOC_TYPE) is "FM" I would like to Bold and change the font color to...

Hi: The FIND function provided th location of the seach string within another string. For example if I was look for the position of "7" in a string containing NNQXI, FSRTZ 718-555-1212, the result would be 14 based on the following: =FIND("7",A1, 1) - assuming that my data was in A1. How do...

Hi: I have a cell containing Last and First Name. In most cases the Lastname and Firstname are seperated by a comma. Also in this same field there is a telephone number which can be in several different formats (e.g (718-xxx-xxxx) or 718-xxx-xxxx)). I would like to extract the phone number...

Hi: Background: I am running a report containing a sub-report. The Main report displays the details of the sub-report. The summary displays first followed by the main (detail)report. In the sub-report (summary), I display several transactions types with associated total number of users...

Hi: I have been producing a report in landscape mode on regular 8.5 X 11 paper and it was fine. Now I need to change the report to print on LEGAL paper because I am adding additional fields across the top of the report. The report contains a top summary report (subreport) and the details in...

I am trying to construct an IIF statement that checks if the Location Name is null then use the district name, but if the district name is null use the location code instead. I have created : FULLLOCATION: IIf(IsNull([Location Name], [District_Name], IIf(IsNull ([District_Name]...

In my report, I have several fields including "Transaction Kind" and a "Seller's Name". I am sorting the report by Location (another field in the report then by "Transaction Type". At the end of each transaction type, I display a count of sellers for that transaction type. For this I use...

Hi: I have never seen this behavior in Windows XP - when open "My Computer" the regular "My Computer" windows show up. Then I click on my "C Drive" icon. I then get the "Search Results" pop-up window with the search criteria and the other buttons to do a seaech on the C Drive. Normally I would...

Hi: I am sure that this question is not new but I could not find a reference in this forum, but here it is: I have two tables (TABLE A and TABLE B). TABLE A contains a list if school names and TABLE B also contains school names and other school information. Unfortunately, TABLE A's school name...

Hi: I have an Access Database with a 'full name' field. Unfortunately, the actual name (the data) is sometimes, also appended with a ten digit phone number. Thus I have, in the name field, "full name phone". Phone is always a number. There is also another field called "phone" where the phone...

Hi: I am trying to list the items recorded in the bios. Does anyone know of a script with I can run to get information from the BIOS? Appreciate it. fb

After starting up my Windows 2000 system, I am getting the following message: The application or DLL C:\program Files\Common Files\Microsoft Shared|office10|mso.dll is not a valid Windows Image. Please check this against you installation disk. Does anyone have any suggestion how I resolve this...

When I enter the a web site name IE takes me to the correct page. If I click on a button, on the page, which attempts to go to an https:// page (eg. www.fleet.com then "Log In"), I get "PAGE CANNOT BE DISPLAYED". This only occurs on one machine, running W2K. Is there a setting in the Options...

Background Information When internet explorer is invoked a default page shows up based on the setting under "tools, internet options, homepage". Under this setting you can select your default page by typing in the URL address and pressing the "apply" button. This information is stored in the...