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

    Automating export to Excel file and formatting thru' Macro

    I have an Access database, with a query (query1) or report (report1) that I export to an Excel file (excel1.xls). I have written a macro (macro1) that formats my excel1 file the way I want it. [This part is all done] I would like automate this whole sequence of running query1 or report1...
  2. CSHANKY

    Creating formatted Excel File from a Query Output

    I have a Access query (query1) that I export to an Excel file (excel1.xls). I run a macro (macro1) that formats my excel1 file the way I want it. [This part is all done] I would like automate this whole sequence of running query1 , opening the file excel1 and running macro1, through...
  3. CSHANKY

    On-timer Code doesn't work

    Thanks ! :) Much appreciate it.... However, would you know how I could modify it so that: It closes the application silently (no warnings, nothing) afet 5 minutes of inactivity. Rgds Shanky
  4. CSHANKY

    On-timer Code doesn't work

    I got it. So what I needed to do was name the yes/no field in Table1 as "LogOff" and it works. Thanks a PILE Mr. V....for helping the hoplessly lost lesser mortals (read non-programmers).... I owe big time to the folks in Tek-tips....
  5. CSHANKY

    On-timer Code doesn't work

    Did that ! Now it says: Runtime erro "3265" Opening the debugger highlights: LogOff = LO!LogOff
  6. CSHANKY

    On-timer Code doesn't work

    Hi ! Sorry - I am quite unfamiliar with programming. I do not know how to: "set a reference to the Microsoft DAO 3.# Object Library (in any module Tools | References)" Could you give me a step-by-step guide ? I did however change: Dim db As DAO.Database Dim LO As DAO.Recordset...
  7. CSHANKY

    On-timer Code doesn't work

    I have created this little database and hosted it on a network drive. Since its a multi-user db, many users open it and conviniently forget to close it. Needless to add, this slows the system and no admin stuff can be done, if needed. Can I make the system automatically figure out it hasn't...
  8. CSHANKY

    Timeout / Close a database upon non-use ?

    I tried the solution # posted on Thread702-627282 which, alas, did not work for me. Where did I go wrong ?? :(( Disclaimer: I have very little programming knowledge and my IQ is in the semi-moron range. However, I get by with a little help and am committed to making my little application work...
  9. CSHANKY

    Timeout / Close a database upon non-use ?

    I have created this nice little database and hosted it on a network drive. Since its a multi-user db, many users open the darn thing and conviniently forget to close it. Needless to add, this slows the system and no admin stuff can be done, if needed. Is it possible that, say, I the typical...
  10. CSHANKY

    Form Size on Opening - Can I specify it ?

    Essentially, I have this contnuous form (lets call it Form1), which I want to open as a pop-up. By pop-up I mean, it should be small (3 inches x 5 inches) size form, that does NOT hog-up the whole screen. Is there any way I can specify this ? Thanks a lot in advance....
  11. CSHANKY

    Excel - Cell Conditional Formatting

    Say I have an Excel Sheet with two columns A & B. How do I format Cell B based on the TEXT contained in Cell A ? I repeat: Cell B contains Text - not number. Example: If Cell A1 contains text "Complete", Cell B1 should be shaded Blue. I know how to condition-format a cell...
  12. CSHANKY

    Opeining a Form Maximized

    Got it ! Thanks Bud !!
  13. CSHANKY

    Opeining a Form Maximized

    Error Message Pops up - Microsodt access can't find the macro 'docmd'. What could be the problem ?
  14. CSHANKY

    Opeining a Form Maximized

    OK - so I got this DB with Form1 that opens on startup, using the Tools/Startup feature. How do I ensure that the Form1 opens Maximized when it comes up ? My users hate it when the darn thing comes up hanging half opened and they have to make that extra herculean effort (*sigh* users...
  15. CSHANKY

    Formatting without Conditional Formatting (Access 97)

    I requested a solution to this problem some weeks ago. The replies did not quite address what I wanted. Would someone take a fresh look and provide sample code? I have a Access 97 database with Table1 with fields Complete1, Text1, Text2, Text3, which appear on a CONTNUOUS Form1. How do I make...
  16. CSHANKY

    Query Date Output Fomatting Problem

    I have a table with 3 fields: 1. [del_complete] is a yes/no field 2. [due_dt] is a date field, medium date format 3. [status] is a text field I created a query using the 3 fields and added "X" which is a calculated field and coded it as: X...
  17. CSHANKY

    Access - Simple Query - Logical Field...Pls Help !

    Guru's please help this novice.... Ok - so I have this table with 2 fields - Yes/No1 and Text1. I want a query with both the fields AND a calculated/logical field OUTPUT which should work as follows: Yes/No1 Text1 OUTPUT -------- ------ ------- Yes <some text>...
  18. CSHANKY

    Simple Query Design - Logical Field - Help !

    Guru's please help this novice.... Ok - so I have this table with 2 fields - Yes/No1 and Text1. I want a query with both the fields AND a calculated/logical field OUTPUT which should work as follows: Yes/No1 Text1 OUTPUT -------- ------ ------- Yes <some text>...
  19. CSHANKY

    Halpp ! Form conditional formatting.....

    Thanks a Lot.
  20. CSHANKY

    Halpp ! Form conditional formatting.....

    I have a simple problem - but my career sort of depends on it. 1. I have a database with Table1 with fields Yes/No1, Text1, Text2, Text3, which appear on Form1. How do I make the fields Text1, Text2, Text3 boxes appear shaded light-blue when Yes/No1 is &quot;yes&quot; ? 2. I have a...

Part and Inventory Search

Back
Top