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: Harlequin007
  • Order by date
  1. Harlequin007

    Sources in Data Validation - Excel

    Morning BigPom Here goes: Data | Validation (Input Message) "Show Input Message When Cell Is Selected" This will show the below message when a user inserts the cursor (selects) the cell in question "Title" What you want the title bar of the message dialogue to display "Input Message"...
  2. Harlequin007

    PowerPoint Links

    Links to what Steve...? HTML files...? Batch Files...? Word Documents...? ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  3. Harlequin007

    Conditionally Formatting a Row Based on a Sibgle Cell's Contents

    Thanks PHV. I was selecting cells, nit the damn row. Many thanks for your patience [colorface] ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  4. Harlequin007

    Conditionally Formatting a Row Based on a Sibgle Cell's Contents

    Thanks for the quick response PHV. I went through the conditional formatting but there doesn't appear to be a rule to set the entire row. It looks in just one cell and formats that cell based on its own contents. I'm wondering if VBA can help here...? ---------------------------- Cogito...
  5. Harlequin007

    Conditionally Formatting a Row Based on a Sibgle Cell's Contents

    Morning Just wondering if it is possible to conditionally format a rwo of cells based on one cell's contents. The cell in question would have validation set to pick from predefined list. If user picks option "A" for example. Can I turn the entire row's BG color to red...? Hoping you can...
  6. Harlequin007

    Detecing 'Esc' Key pressed

    Cajun I'm just using the standfard Calendar control mate [colorface] ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  7. Harlequin007

    Automatically Generate Reports on Last Working Day Of Month

    Nabi. Thanks for that. I'll integrate it and it should do exactly what I want... ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  8. Harlequin007

    Automatically Generate Reports on Last Working Day Of Month

    Will that work for the last "working" day in a month Fancy...? I'd prefer to manage it from within the DB than put a setting on a specific user's PC. ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  9. Harlequin007

    Automatically Generate Reports on Last Working Day Of Month

    Morning guys. I have an issue with outputting data from Access to Excel you might be able to help with. What I have done is developed a macro (so designated users can edit it) that auto outputs a query to excel. I'd like to do this on the last working day of the month. preferably without...
  10. Harlequin007

    table formatting in html

    Justify...? ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  11. Harlequin007

    Css buttons

    Stunner I achevied the same by creating a CSS entry for tables then inserting hyperlinks in tables. That way the browser thinks they are using a nav bar. ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  12. Harlequin007

    FTP w/ IIS 6.0

    Gerbie Check out War-FTP. You basically disable IIS FTP and allow War to control access, rights, directories - the lot. ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  13. Harlequin007

    Automatically Open a Linked Excel Workbook

    Thanks PHV. Before Open eh...? I think I'll file that under "Ideas to keep to yourself" ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  14. Harlequin007

    Embed an Excel Spreadsheet from a Workbook Within HTML

    Kewl Jacob Worked a treat. I need to resize the excel chart or maybe the frame but I should have looked at using the IFRAME command sooner. Why on earth will it not display in a HTML page but in a frame...? Any ideas...? ---------------------------- Cogito Ergo Sum [jester2]...
  15. Harlequin007

    Embed an Excel Spreadsheet from a Workbook Within HTML

    Thanks Jacob I'll see if I can get that to work. Thanks for the response. ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  16. Harlequin007

    Popup question

    Or you couls simply call it out yourself: Hope that's of use [colorface] ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  17. Harlequin007

    IIS for installing FP Extensions on PC

    Dance TCP/IP should already be set-up mate if you are networked. Just get the FP Ext installed mate. ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------
  18. Harlequin007

    Access the Web through a hyperlink

    BHL. I had a similar problem presenting hyperlinks from a database in a FP website using the results region. Basically I converted the results field in question into a hyperlink and inserted a database column value in the result field. e.g: Database field is "Property" Linked this to...
  19. Harlequin007

    Automatically Open a Linked Excel Workbook

    Guys I'm sure there's a FAQ or post about this but couldn't find one. I need to have a workbook execute (open) another (linked) workbook on the "BeforeOpen" event. I just need some help with the syntax if possible... ---------------------------- Cogito Ergo Sum [jester2]...

Part and Inventory Search

Back
Top