Recent content by AUGuy

I'm guessing the listbox details are populated by a query? If that's the case, why not point the criteria for your two fields to the controls in the query. Simpler than writing VBA and easy to implement.

The way I've gone about handling multiple search criteria without unnecessary VBA is use the query to limit the information based on controls in the form. Lets say you have a form with TextBox1, TextBox2, and TextBox3. You have a listbox on that form tied to the query qry_FilteredData. Your...

I've found that calculated fields within the report itself run slower than doing the calculation with a query then displaying the results within the report. Additionally, if you're developing several reports off the main query, you could append those results to a temp table and then run your...

To get started, I'd suggest just browsing the sub-forums of what you're interested in learning about. There's lots of information to be had. Second, get a good reference book off Amazon. for VBA I use Access 2003 VBA Programmer's Reference by Cardoza, Hennnig, Seach, Stein.

Click on the command button, click on it's properties. goto Events, find the OnClick event and type in EmailFromQuery

Just noticed i forgot to throw the exit sub in front of the err handler. that would return a empty msg box every time it was run. I've modified the code above.

No problem. It worked for me when I tested it, but if you're still having problems let me know and I can dig into it further.

This should do what you need it to Sub EmailFromQuery() Dim rs As Recordset Dim strRecipients As String Dim strDocName As String strDocName = "rpt_Deferred_DTSR_List_By_Plant" On Error GoTo Err_Handler: 'open the query containing the email addresses as a recordset Set rs =...

I'm writing up a vbscript for you, for clarification, what is the field name that contains the email addresses you want to extract from the query?

Thanks again, Bob. I don't doubt you or this individual whatsoever. However, to sign off on the proposal with my boss I still would like to see some detailed reasoning as to why and how code can cause issues with data. Time for some good ole fashioned research. I'll report back with anything...

Thanks, Bob. Do you have any articles related to how the code can corrupt the data? I've not run across this but would like to know exactly what happens and why not to do it without making you write the article for me :)

I'm curious as to where the best place to run your daily procedures, whether it be the front-end or back-end or separate 'Control' database, is. We have several databases deployed in several departments that track all manner of things. Each of these databases update differently and using...

Maybe it's just me, but I'm not very clear on what you're looking for. Could you go into further detail on what it is you're doing as well as how the information gets into the table, etc?

Hi PhobiaBlu, Simplest way is to create a query. Since you didn't provide any table information on what you'll need to sum/count I'll create my own example. Assume you have a table (tbl_YourTable) with 2 fields: Account_Number, Account_Balance, To get a total count of the account numbers...

You should look at the On DoubleClick event in the properties for your list box. In the VBA for that event, you can open the form you're wanting to go to, set the current bookmark to the original listbox value (me.listboxNameHere is one way to get it) and now have it displayed on teh second...