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
    526

    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
    657

    Thanks, Tim.

    Thanks, Tim.
  3. Replies
    8
    Views
    657

    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
    657

    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
    657

    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
    657

    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
    951

    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
    951

    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
    951

    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
    951

    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
    951

    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
    430

    Thanks, this works.

    Thanks, this works.
  13. Replies
    2
    Views
    430

    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
    419

    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
    491

    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
    491

    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
    544

    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
    544

    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
    544

    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
    383

    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
    583

    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
    583

    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
    449

    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
    449

    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