Search results

What is the Parent/Child Relationship set to on the subform (You can see this when you have the Parent/Main form open and you select the subform object)

See this post http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59249&highlight=Comboboxes

So then it looks like you have no say in the design of the structure. Then you have two options. 1. IIF (and Embedded IIF) 2. Create A Public Function IIF (Assumes only one can be true) Query Field =IIF([Chk25]=True,25,IIF([Chk15]=True,15,IIF([Chk10]=True,10,0))) (Assumes any could be...

Have you tried renaming the "Summary" report to "rptSummary" or something else?

What is 'Summary'? Is it an Access Table? Query? Is it a Linked Excel SpreadSheet? Has it been moved or does it still exist in the path it was linked to?

See Access 2000 ADO Traps Watch out for these ADO inconsistencies. By Ken Getz, Technical Editor

Check out this article "Retrieving the User's Default Email Address" on this site http://vbnet.mvps.org/

HOWTO: Create a Table with Primary Key Through ADOX

My version of Access (2000 and 97) don't have an OpenArgs property for Reports. In fact the docmd.OpenReports is structured as follows Docmd.OpenReport ReportName,View As AcView,FilterName,WhereCondition You could do this by using a Global Variable, setting the value of a Hidden Text box on...

I believe MicroSoft did it this way to add a way to notify you that your email may be hyjacked. This allows you just enough time to reach behind your PC and yank your internet connection :D

Which line does this Occur on? If you don't know, add a Break Point in the SUB and use the F8 key to step through the code. Generally when this error occurs it is because a reference is not set or is corrupted.

The best method would be to use an Installer. Such as the Package and Deployment wizard that comes in the Developers TookKit or InstallShield. By using this you will be able to "Install" the needed references to the directory you choose (Such as App Path). This will also register the needed...

Where did you declare the KEEPHOLD variable? Class Module behind the Form? Or in a Module in the Modules Tab? If you put it in a Class Module behind the Form this variable will be lost once the form closes. Put the variable in a New Module in the Modules tab. This will make it public for...

Just as a hint for future use: You can create an RTF file (Using MicroSoft Word) and then open it using the NotePad application. This will return the code behind the RTF so that you can return the formating that you are looking for. In this case Bold is \b & "Request Dated:" &...

Grab the RecordSetClone of the SubForm and Loop through it. DIM rst as DAO.RecordSet Set rst = Me.Form.[SubForms Name].RecordSetClone Do While Not rst.EOF '<Your Script Here setting the strComputer=to Recordset's equivalant> rst.MoveNext Loop

Your recordset has an AbsolutePostion property. For ADO the first records AbsolutePostion = 0 For DAO the first records AbsolutePostion = 1 Param Name="List" & rst.AbsolutePostion '+1 if using ADO

See this Article ACC: Creating and Testing Add-ins Paper Available in Download Center

You can use Excel Automation to do this: MS Knowledge Base

See this article

MS Knowledge Base Article based on Public Sub ListReports() Dim db As DAO.Database, doc As Document, con As Container Set db = CurrentDb() Set con = db.Containers("Reports") For Each doc In con.Documents Debug.Print doc.Name Next End Sub You can then compare the...