Search results for query: *

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...

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...

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

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....

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

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...

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...

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...

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...

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....

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...

Got it ! Thanks Bud !!

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

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...

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...

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...

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>...

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>...

Thanks a Lot.

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...