Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fbacchus

    An Update SQL

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

    An Update SQL

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

    WINDOWS XP NOT BOOTING CORRECTLY

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

    WINDOWS XP NOT BOOTING CORRECTLY

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

    USER ERROR OR MICROSOFT BUG ?

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

    USER ERROR OR MICROSOFT BUG ?

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

    SHAREPOINT COPY FOLDERS FROM LOCAL DRIVE

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

    OUTLOOK 2003 .BAK file

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

    Hiding Duplicates on Reporta

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

    Specialized Report Formatting at Print time

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

    FIND FUNCTION

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

    Seperating Last Name, First Name andl Telephone (TRIM, STRG)

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

    Seperating Last Name, First Name andl Telephone (TRIM, STRG)

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

    Different Information on Subreport - Summary and Footer

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

    Sizing Reports - SubReport and Main Report

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

    Sizing Reports - SubReport and Main Report

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

    IIF - not working

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

    COUNT in Report phase

    ...- SellerName - Trans-Count A - John B 100 - Mary J 120 - Joe S 140 ** Total No Sellers 3 -- Trans count 360 B - Frank C 150 - Mary J 220 -...
  19. fbacchus

    COUNT in Report phase

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

    Getting "Like" results from a Query

    Thanks. Appreciate it. fb

Part and Inventory Search

Back
Top