Recent content by mscraig

Russ, What you are talking about is possible. It is rather involved. Your idea of a table of contents is Ok, but I found that making BookMarks on the fly was a slicker solution than a Table of contents. You'll need to manipulate the Post Script code in your .ps files. Check out Pdfmarkex.ps...

Generally speaking, Ken Getz is the author you need. The books Ed listed from Sybex I think are Ken Getz books.

Try this minor variation: Function ActiveEmployeeName() As String Dim rstError As Recordset Dim db as DataBase Dim str as String Set db = CurrentDb Set rstError = db.OpenRecordset("qrySelectCountofActiveEmployees") With rstError Do Until .EOF str = !LastName ActiveEmployeeName =...

Try using in your code. db1.Close or db2.Close Compact can also be accomplished as part of the opening command associated with a desk top Icon. Look for "Start up CommandLine Options" in Help. "\cmd"

I don't think what you are looking for is available in a one step method. I usually handle this by importing the spreadsheet in it's predefined layout, then I do a maketable query of the imported sheet to put it in the layout/mapping I need.

Try: Dim Db as DataBase Dim Db2 as DataBase Set Db = CurrentDb() Set Db2= DBEngine.Workspaces(0).OpenDatabase ("G:\reinledg\Midnight\697LPC\LPCCashImport.mdb") 'The Set statement is all on one line.

You might be able to query the information (List of Reports) for the hidden system table MSysObjects. The "Type" field seems to have unique numeric identifiers for each type of object. The names of the reports ar also listed.

I believe what your looking for is an ActiveX Object which is not availabe in standard Access. Developers edition probably has it. You can also usually get the object by installing the Library package from one of the Microsoft Visual languages such as VB6. I noticed that when I installed VB6...

As best I can tell, those function are not allowed in Access. You might try simply linking to the worksheet and perform your calcs in the excel worksheet. The link is dynamic.

Try - Is Not Null - instead of <> null. Sometimes Access doesn't interpret <> null correctly. Also continue to use <> &quot; &quot; in your criteria. Sometimes - Not Like &quot; &quot; - works.

There are some Help files available for Graph8 (the resident Access graph package) in the ValuePack available in Service Pack 1. If you have access to the MS Office CD look for Valupack\Valupk8.hlp, double click and a master help file opens. Choose &quot;Additional Help Files&quot;. The info...

I've done some work of this kind before and the two ways I found to accomplish the task were: Assign the values of the text boxes to text variables. 1. Have chart data supplied by a Query which has criteria using the variables in a SQL string. 2. Put the text box variables into a table...

In your report in the object (ex. textbox) try something like: =iif(Count() is null,0,Count()) Some variation on this idea should solve your problem.

In your report in the object (ex. textbox) try something like: =iif(Count() is null,0,Count()) Some variation on this idea should solve your problem.

You might try putting your UNION SQL into a Query Definition. Then use the query definition as the record source (like a table) for your Append/Insert SQL. Union statements generally don't allow much going on other than the Union other than something like an Order By.