Search results for query: *

Thanks MajP. I am assuming that in your example, tblOne is my TableA and tblTwo is my FileB. Correct? thanks fb

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

Linney: Thanks for the information. I was able to follow some Microsoft instructions to delete some of the configuration files (security, software, and others) and re-copied them from a backup location. This worked fine and the looping stopped. The problem I am encountering now is, after I...

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

58sniper, I retried the copy and past and the creation date remained the same in the two records. I am not sure the differences. fb

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

Thank you all for your responses. As Skip requested, here is an example of the data: COSTA, PLAYS 212-574-1861 ABC, SMITH JONES TOM (345) 555-1212 INGRID LUMS, (888)555-1203, EXT 105 SMITH, ZINA 764 281-807 JONAS BIL 345 555 7208 Also, Nicolai, I couldn't find any information on the "fixed...

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

Thanks Alex. I checked but couldn't find anything other that what I saw. Is there a way to calculate the number of controls in a section ? fb

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

mikey69: Thank you for the response. My report is set-up the way you are suggesting and am getting the location counts. The problem is (explained below), given the example below: Location A: Trans-type - SellerName - Trans-Count A - John B 100 - Mary...

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

Thanks. Appreciate it. fb