<?xml version="1.0" encoding="UTF-8"?>

<rss version="2.0">

<channel>
<title><![CDATA[BoardTracker - VBA]]></title>
<link>http://www.boardtracker.com/all/290/1/</link>
<description><![CDATA[Latest threads from "VBA"]]></description>
<pubDate>Wed, 03 Dec 2008 08:17:18 GMT</pubDate>
<lastBuildDate>Wed, 03 Dec 2008 08:17:18 GMT</lastBuildDate>
<item>
<title><![CDATA[zero length string...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747062</link>
<description><![CDATA[ Please can someone help with what i thought would be a simple problem but has turned out to be very annoying. I have a form bound to a table with about ten textboxes with the first one (accoun...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747062</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[VBA SQL Query of Multiple Databases...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747065</link>
<description><![CDATA[ Hello: I have done some VBA coding in the past, but this is my first time working with the DAO 3.6 object model. The HMI software I'm using for a distributed control system incorporates VBA. In ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747065</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Help ME Pls...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747068</link>
<description><![CDATA[ Hi all, I am new in access and visual basic. Please help me. I have query where I am getting result fine, but it repeating value (Please see attachment). However, I dont wanna repeat value. Can y...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747068</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[ADO recordset not working. What's wrong with this code?...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747076</link>
<description><![CDATA[ I have used ADO regularly to access my data with not many problems. But I have been having some problems, with this code in particular: Code: Public Function ErrorExist() As Boolean Dim SkuE...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747076</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Code Boxes...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747079</link>
<description><![CDATA[ I’m not totally familiar with all the gadgets this site has to offer. In particularly I am interested in adding, what it seems everyone knows but me, the boxes with vertical and horizontal scroll ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747079</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Command button to send all clients email through outlook...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747084</link>
<description><![CDATA[ I have a table contacts with field email which hold contacts email addresses. How do i create a command button on my Organisations form so that on click it takes all the email address from the con...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747084</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[VBA code for matching Records in DAP...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747081</link>
<description><![CDATA[ I am having problem with the code below in my Data Access Page. My record source is a table and the search field is numeric. The user enters an employee id in the textbox and it should search for ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747081</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Listbox Column Head...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747082</link>
<description><![CDATA[ I have the following SQL code: Code: SELECT tblCustomers.customerID AS ID FROM tblCustomers WHERE (((tblCustomers.customerID)=1)); The select query is the row source of a listbox. How...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747082</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[SQL and VB...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747070</link>
<description><![CDATA[ Hi. I have a database with a table called Agents. In this table are the agents Username, Password, Name, Address etc I want a form so they can login using this data. So for example in my table i w...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747070</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Button Always Appends 8 Rows Instead of 1...]]></title>
<link>http://www.boardtracker.com/rss/thread/65747086</link>
<description><![CDATA[ Hi, I have created a form with a text box. Under the text box is a button with a command to open an append query and enter the contents of the text box along with two other fields into a table. Th...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747086</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Need some help....]]></title>
<link>http://www.boardtracker.com/rss/thread/65747087</link>
<description><![CDATA[ I'm pretty sure this goes in here but if not admins please move to Access General Discussion. So we all know access has conditional formating but it only allows 3 and I've looked all over for ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65747087</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Inserting maintable's autonumber to subtable field...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736237</link>
<description><![CDATA[ Hi, i am writing an onclick event vba which insert values in my form to 2 different tables in one click. A main table and a subtable. The subtable is linked to the main table by a field called Mai...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736237</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Object error on a DLookup...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736253</link>
<description><![CDATA[ Hello, This is my first time posting so please excuse my ignorance. What I am trying to do is upon updating a form I need to check what was selected in the [FormTitle] “without space” combo box o...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736253</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Bitwise comparison and optional criteria...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736242</link>
<description><![CDATA[ As you may know, we can do a bitwise comparison for criteria or flags. This works well if all criteria are required; so if we required 'a, b and d', we can ask thus: Code: If (MyCriteri...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736242</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Error handling: report bombs at VBA function when query returns no records...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736258</link>
<description><![CDATA[ Can someone supply basic error handling needed for the following situation? Background: (a) A parameter query supplies records to a Report (b) A Report detail section text box gets its dat...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736258</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[tax problem...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736255</link>
<description><![CDATA[ i have this situation something like the following a control on a form gets income value from a table i want anther control should calculate the tax for each income value for each record the...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736255</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[3 conditions to be met by 2 different fields...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736248</link>
<description><![CDATA[ I really don't know where to start. I am trying to query a table from a form. The form has 2 text boxes - one is for the Start date and the other is the End date. I need the query to search 9 dif...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736248</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[UNC path vs. IP Address...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736268</link>
<description><![CDATA[ This is in regards to one of my previous posts but this question is a bit more generic. We’ve noticed that when coding a mapped drive or UNC path, the routine fails. However, if we use the IP...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736268</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Quick Calculation/Formula Help...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736271</link>
<description><![CDATA[ Hi All, I'm using Access 2003. I have a continious form (that allows additions) with 5 fields where the record is retrieved by searching an Acct# field. The field I want to make a formula...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736271</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[email address from access to outlook...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736276</link>
<description><![CDATA[ I have a table contacts with field email which hold contacts email addresses. How do i create a command button so that on click it takes all the email address from the contacts tables and transfer...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736276</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Get XML data from webservice...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736262</link>
<description><![CDATA[ Hi, For a project i'm working on I need to get data from a real time interface which uses web services and returns XML. I have managed to connect to the web service and get a DOM NodeList but ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736262</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Form and queries w/parameters...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736273</link>
<description><![CDATA[ I have a query (actually several joined into a single query) that has parameters (actually three parameters in two different joined queries). I want to base my form on the query but I want t...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736273</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Working Days but different condition...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736281</link>
<description><![CDATA[ Hi, I'm pretty new here. A newbie on VBA as well. I just need some help on a form i'm working on. My scenario: Date Request Raised SLA for Days = with values of 1,5,7,10,20,30 (this is in a comb...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736281</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Opening form to slow...]]></title>
<link>http://www.boardtracker.com/rss/thread/65736278</link>
<description><![CDATA[ Hello, after checking a password I use the following code: DoCmd.Echo False DoCmd.OpenForm &quot;FrmUitloggen&quot;, acNormal [Forms]![frmUitloggen].Visible = False DoCmd.OpenF...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736278</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[How do we connect mainframe with hummingbird software....]]></title>
<link>http://www.boardtracker.com/rss/thread/65736243</link>
<description><![CDATA[ Hi all, I'm working on mainframe automation using VBA. Now i want to use humming bird software in it. How do we connect hummingbird for mainframe in VBA.what is the role and functionality of hum...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65736243</guid>
<pubDate>Mon, 01 Dec 2008 00:00:00 GMT</pubDate>
</item>

</channel>
</rss>
