Search results

I assume the error might be caused by the fact that reports don't have such a property. It is infact a property belonging to the recordsource object in forms.

has the debug mode highlighted the same line?

Unfortunately I only know how to do that in 2007 as that's what I use. I'm pretty sure almighty Google can help you with that though. Lookup "Library reference Office 2010". Still, I smell a missing reference error, but I don't know for sure.

I think you may need a better record management interface if this is the case. It would be wise to show the partial results on a listbox (the recordsource of which would be your temp table), and allowing the user to select records (i.e.: e-mail addresses) from it and possibly delete and/or...

Well the first thing that comes to my mind is pictures in forms

Are you referencing either the ADO or DAO libraries in your project? read more about that here: http://www.accessmvp.com/twickerath/articles/adodao.htm

Normally you wouldn't use a table for data entry. Tables are only for data storage, and should never be used for anything else. You want all the operations on records and tables to be controlled by forms and therefore reducing the risk of data loss or corruption. I might be wrong, but I think...

Well wouldn't it be as simple as using an sql "delete" statement?

Maybe I got you wrong but what you're saying is you expect going into "debug mode" be normal behavior? That is, when you're running your application you want it to generate errors and bring you to the vba console?

I assume you have your table/s properly set-up to accept data of the kind you're expecting to. It all depends on how you want to discriminate among, say, who provided that data after an import. You're not providing much information as to how to help you. You need to circumstantiate, provide...

no but I'm starting to sense it might be irony-related?

if you start mixing religion and sets of belief the line becomes far too sketched. Consider the variety of religions there is, some "started" even in recent times, it is pointless to try and analyze each slight difference among them. When you're building over a book (or another) that, like has...

Hello all, I ticked the first answer. My take on the matter is more individualistic. Science sells better to me: I find it easier and more compelling to listen to some people who spend their lives investigating with whatever means they have the world and universe around them, by a mixed use of...

You would use the Recordset Object in VBA to pull all the addresses and assemble them in one string. See the following code for reference: Private Sub cmdListEmails_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim mailinglist As String Set db = CurrentDb() Set rs =...

How about this: - create a temp table; - populate it with all the addresses; - query it to be the rowsource of the box in your form for displaying purposes; - delete it after the data has been exported to the "To:" field in the mail application?

Ok, here goes. Private Sub cmdFillOutForm_Click() Dim appWord As Word.Application ' Dim doc As Word.Document ' ''''''''''''''''''''''''''''''''''''' Dim db As DAO.Database ' Dim rs As DAO.Recordset ' ''''''''''''''''''''''''''''''''''''' Dim strsql...

Also, it is good practice when working with recordsets, to check for EOF to make sure the recordset you're opening does contain any records. Therefore: If Not RstInv.EOF Then RstInv.MoveFirst 'do stuff you need here End If

I fixed it, just needed some intensive debugging. Can post clean code if anyone needs to perform the same task, just reply to this thread.

Hello all, I've set up a routine that fills out several different .docx word documents from an access console, based on the answers of .accde questionnaires. It all works except for the part where I have an On Error GoTo statement that I prefer to keep commented so to make sure everything runs...

You need to familiarise with forms, form controls, SQL and VBA. A drop down menu, within access, is a control named combobox: try and mess around with it and its properties so you get the hang of it. Probably its most important feature is the row source, which determines what kind of data is...