Search:

Type: Posts; User: garyfei; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    556

    Hi, I have thousands xml files in different...

    Hi,

    I have thousands xml files in different folders. I would like to import those xml files with the folder name to a excel worksheet. For instance, I have a folder call: Test1, inside of Test1...
  2. Replies
    8
    Views
    683

    Thanks, Tim.

    Thanks, Tim.
  3. Replies
    8
    Views
    683

    I am sorry, Tim. You are right. between 90%...

    I am sorry, Tim. You are right.

    between 90% and 94%, color is yellow.
    below 90%, color is red.

    Thanks,
  4. Replies
    8
    Views
    683

    Hi Tim, If the cell volume between 90% to...

    Hi Tim,

    If the cell volume between 90% to 94%, the color is yellow.
    If the cell volume below 94%, the color is red.

    No, the cell volume won't ever over 100%.

    Yes, all cell volumes...
  5. Replies
    8
    Views
    683

    Well, I can't format all cells to red since some...

    Well, I can't format all cells to red since some cells have volume for 0%. I will need it with no color.
  6. Replies
    8
    Views
    683

    Hi, I have more than three conditional...

    Hi,

    I have more than three conditional formatting need to setup, but I couldn't do it in excel 2003 because of the limitation. What codes can I use to put under Worksheet_Change event procedure,...
  7. Replies
    10
    Views
    998

    Yes, those are the numbers all begins with 0,...

    Yes, those are the numbers all begins with 0, then name.

    I have uploaded excel file with two separate worksheets, one is the format before the filter, and another one is what I want after filter....
  8. Replies
    10
    Views
    998

    Thank you so much for your help, Andrew. But...

    Thank you so much for your help, Andrew.

    But I have the last question regarding this filter request, I have another similar report that have to be filter. The only difference is it has the...
  9. Replies
    10
    Views
    998

    Thank you so much for your help, AKW. I just...

    Thank you so much for your help, AKW.

    I just find out the format I have on the report is a little different with what I listed before. I have attached it updated demo. How can I filter column C =...
  10. Replies
    10
    Views
    998

    Thanks, RG. Can also provide me the VBA...

    Thanks, RG.

    Can also provide me the VBA program to deliver what you suggest?

    Thanks in advance.
  11. Replies
    10
    Views
    998

    Hi, I have about 9000 records are exported...

    Hi,

    I have about 9000 records are exported from the database in the format that I attached. Now, I need find a way to filter all the ID records with type = 2.

    [attachment=88595:Filter.JPG]
    ...
  12. Replies
    2
    Views
    461

    Thanks, this works.

    Thanks, this works.
  13. Replies
    2
    Views
    461

    Hi, I have a crosstab query to count the...

    Hi,

    I have a crosstab query to count the value (Agree, Disagree, NoResponse) in "Responds" field. Then I have a report based on the crosstab query, which have three text boxes for Agree, Disagree...
  14. Replies
    1
    Views
    448

    Hi, How can I change the backcolor of the...

    Hi,

    How can I change the backcolor of the detail section by group in my report of Access 2003? Now I have different backcolor per row.

    Thanks in advance.
  15. Replies
    3
    Views
    519

    Thanks,. This works: put "Refer" or is null on...

    Thanks,. This works: put <> "Refer" or is null on the one line
  16. Replies
    3
    Views
    519

    Hi, I place "Refer" in the criteria of...

    Hi,

    I place <>"Refer" in the criteria of "Outcome" field of the query. Once I run the query, all null data in "Outcome" field disappeared. How can I see all data includes no null by excluding...
  17. Thread: Page Header

    by garyfei
    Replies
    4
    Views
    574

    Thanks. Just find the solution for my case. I...

    Thanks. Just find the solution for my case. I have added the following codes under "On Format" event of PageHeaderSection:

    If Me.Page = 3 or Me. Page = 6 then
    Me.PageHeaderSection.Visible =...
  18. Thread: Page Header

    by garyfei
    Replies
    4
    Views
    574

    Thanks. The simply question to address my issue...

    Thanks. The simply question to address my issue is: Is there a way to make a page header apply to a report without applying it to the third, six, nine page of the report?
  19. Thread: Page Header

    by garyfei
    Replies
    4
    Views
    574

    A report(ReportA) have a chart under page header...

    A report(ReportA) have a chart under page header in Access 2003 db. Now I want to add another report as subreport(subreportB) in the ReportA. How I can I make the page header of ReportA invisible...
  20. Replies
    1
    Views
    411

    Hi, How can I apply the codes to auto change...

    Hi,

    How can I apply the codes to auto change file color in a excel worksheet? I have a field call "Target", and the valume is 100%. I also have 12 fields which are "Jan" to "Dec." I would like...
  21. Replies
    2
    Views
    600

    This is likely to be a function of the verison of...

    This is likely to be a function of the verison of Access you are using, and the size of the text file. It is possible that the Transfer Text function locks the text file which would prevent UserB...
  22. Replies
    2
    Views
    600

    I am using the following codes to import a text...

    I am using the following codes to import a text file to a table in serveral databases:

    DoCmd.TransferText acImportDelim, "tblTest Import Specification", "tbl_List", "\\sharedrive\test.txt", True
    ...
  23. Macro, Visual Basic Editor greyed out in Outlook...

    Macro, Visual Basic Editor greyed out in Outlook 2007. How can I active it?

    Thanks in advance.

    Regards,
  24. Replies
    2
    Views
    480

    You need to replace the Control Source with a...

    You need to replace the Control Source with a conditiional expression something like:

    =IIF(isnull([Responds]),"No Responds At All","Have Responds")

    The builder can help you construct something...
  25. Replies
    2
    Views
    480

    I have a text box with Control Source "Responds"...

    I have a text box with Control Source "Responds" on one of my report. How can I have text box displays "No Responds At All" if the responds field is Null, and displays "Have responds" if the responds...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4