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!

  • Congratulations SkipVought 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: *

  • Users: achau
  • Order by date
  1. achau

    Design view gone AWOL

    When I am in the code & design view, I can see all the codes, but the design view panel is blank (ie I cannot see the layout of the page at all) - the page can be displayed in browser preview without any problems. I tried relaunching DW and opening a page from another site that I could see the...
  2. achau

    Clone stamp not working?

    I was trying to avoid re-installing it but it looks like I have no choice. :-(
  3. achau

    Clone stamp not working?

    The caps lock is off.
  4. achau

    Clone stamp not working?

    Thanks. I've just tried it, and no, it still doesn't work. Any other suggestions?
  5. achau

    Clone stamp not working?

    I try to use the clone stamp in PS7 but when I press the alt button, instead of getting a little stamp icon, I get an icon that looks like a target viewfinder (2 circles with a plus sign in there), and the clone function doesn't work at all. This is happening for the healing tool also. It...
  6. achau

    I have created a query via the data

    I have created a query via the database results wizard in FP to obtain data from Access. One of the search criteria is for the field "City"---- I already have a data table in Access for storing a list of cities. How can I change the free text box (create by FP DB results wizard, code...
  7. achau

    Macro to modify Excel Menubar

    I don't seem to be able to find a way to modify existing Excel menubars. What I'd want to do is to disable the "Save" and "SaveAs" in the "File" menu but leave the other menu commands intact when a user opens a specific file. I have already got a macro that runs...
  8. achau

    Run Excel macro and suppress toolbars on opening file

    Dsi, Many thanks for your help! It works beautifully now! Al
  9. achau

    Run Excel macro and suppress toolbars on opening file

    Still a problem with that line of code. I get an error message: Run-time error '-2147467259 (80004005)': Method 'Visible' of object 'CommandBar' failed. Presumably the codes in Auto_Close are used to restore the user's setting of the toolbars to their original states.
  10. achau

    Run Excel macro and suppress toolbars on opening file

    dsi, Thanks..... But now the next line doesn't work :-( (Sorry but I am not good at VB codes). Looks like it's something to do with cmdbarname(iIdx) not defined. Thanks once again. Al
  11. achau

    Run Excel macro and suppress toolbars on opening file

    dsi, Thanks for the code. I have tried the auto_open part (with the modifications) and it worked great!! However, when I try to close the workbook, I get an error message about the type mismatch in the line: If sCmdBarName <> &quot;&quot; Then..... Al.
  12. achau

    HOW TO PRINT THE DATA FILE DESCRIPTION

    You can use PROC CONTENTS to view the variable names and length of all the variables once your data are in SAS.
  13. achau

    Blank Space after table

    Is there a way to stop Frontpage automatically inserts a blank space (nbsp) after a table (if the table is at the end of the page)? I have tried deleting it in normal view but FP adds it back afterwards.
  14. achau

    Run Excel macro and suppress toolbars on opening file

    How can I create an Excel macro that will run automatically on opening the file as non-read-only? (I don't want to run it if it's open as read only). Also is there a way to suppress the toolbars when the file is open, or does that depend on the user's setting? Thanks in advance for help. Al
  15. achau

    Connecting to Access using FP Wizard

    I've been trying to connect to an Access database from FP2000. However, I got the following error message when I try to view the .asp page: This problem can occur if: * the connection has been removed from the web * the file 'global.asa' is missing or contains errors * the root folder does not...
  16. achau

    System scan triggered while online

    Recently I notice that when I am using the internet on a standalone PC at home, the McAfee virus scan/Vshield (version 5.21) starts the system scan when I visit some of the websites (usually ones with dynamically-generated pages), even though when I click on the system scan properties, it says...
  17. achau

    Refresh data automatically in Excel Pivottable

    Is there a way to refresh the data in a pivot table (in a different worksheet from the raw data sheet) automatically in Excel? What I'd like to do is to allow the users to modify the numbers in the raw data sheet and then the numbers in the pivot table will be re-calculated automatically so that...
  18. achau

    Specifying Variable Order in the Output table???

    Without having access to SAS at this very moment, I cannot check out why my previous solution didn't work (sorry about that). Another solution is to try PROC SQL and specify your variable order in there. PROC SQL; CREATE TABLE Y AS SELECT item_num, category, description FROM...
  19. achau

    Specifying Variable Order in the Output table???

    To create a SAS dataset with variables in a certain order, I find it easier to do it using the retain statement in the data step.... eg: data y; set practice.xmas_in_out_checklist_2001; retain item_num category description; run; If you do a PROC PRINT on dataset Y you should see the...
  20. achau

    DB corruption due to same set of records being edited

    I have an Access DB that is split into frontend and backend, with backend being the Jet DB. If two users open the same rows of records in a form but actually edit different records (ie records 1-20 are displayed on both users' PCs, but person A only edits records 1-5 and person B only edits...

Part and Inventory Search

Back
Top