Search results

This is normally caused by a broken reference. Go to one of the machines that this is occuring on and check the references. If none of the references show as being missing then remove the DAO or ADO reference, close down the reference screen, open the references again and add the DAO or ADO...

What Happens when you select the record and press the delete Key?

Glad I could help.:)

Go to this article: ACC2000: Microsoft Access Security FAQ Available in Download Center

Use the Docmd.OutputTo function: DoCmd.OutputTo acOutputReport, "rptName", acFormatRTF, "fileName", True You will need to move the Filter code that you have to the the Reports Open Event. (you will need to change the ME to Forms![FormName]

What does this do? WorkLogEntry "Message - Delete", [FileNo], lblClient.Caption, "ID No: " & [DataID] It looks like a Sub Procedure

Please post your code. Without knowing what you are using to email it makes it hard to help. You could be using Office Automation, SendObject, MAPI or any number of ActiveX Controls on the Market.

I'm very unclear of what you are trying to do. Are you trying to create a Word Document from a report? Or Are you trying to use "Word" to create the Report? Maybe a Step-By-Step of what you want accomplished may be needed.

Web pages don't normally contain Data, they are front ends to the data. XML documents are data storage pages that have schemas that can be used to read the data contained within. Without knowing the structure of the pages the only way you can strip data from a Web page (without having the...

Look at this previous post. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53808&highlight=Word

I used this code and I got Null for each case, so I'm not sure what the problem is, as the help file seems to be correct here. Public Sub StrCompTest() Dim x1 As Variant Dim x2 As Variant Dim x3 As Variant x2 = "ABC": x3 = Null x1 = StrComp(x2, x3, vbBinaryCompare) Debug.Print x1...

What is ment is more Tongue-In-Cheek. At one time this function was going to be able to do this, but now it's not.

While the Help File states there are four Enum Options vbUseCompareOption = -1 vbBinaryCompare = 0 vbTextCompare = 1 vbDatabaseCompare = 2 The Enumeration of the function only shows three of them (0 - 2) As a test I printed out the value of vbUseCompareOption and low a behold it is empty...

Change this: Dim rstClone as DAO.recordset rstClone=Forms![Bid - Master Form]![Bid - Quote].RecordsetClone rstClone.MoveFirst Do While Not rstClone.EOF If rstClone!QuoteID=intQuoteID then Forms![Bid - Master Form]![Bid - Quote].Recordset.BookMark=rstClone!BookMark Exit Do...

If there does not seem to be any broken references and you are still getting an intrinsic command highlighted then remove any of the references and add it back in (make sure you leave the reference screen between the remove and add processes) this will cause the MDB to refresh its references.

What version of Access are you using? Do you have the DAO 3.6 Reference in your MDB file?

Odds are you have a broken reference. Check the MDB version and see if a reference is broken.

[code] 'copy record to new Quote record intQuoteID = Forms![Bid - Master Form]![Bid - Quote]!

1. Two network cards, Network cables and a hub :D 2. Place these three tables into a seperate mdb file and link them to the Main/Front Office MDB file. This would allow you to do a simple copy of the MDB, you won't have to export/import. 3. Look into replication of the Main MDB.

Check the RecordSource of the "PDFamil_frm". does it include the GPnumber field? does it have a different name? (i.e. Expr1)