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

<rss version="2.0">

<channel>
<title><![CDATA[BoardTracker - Databases]]></title>
<link>http://www.boardtracker.com/all/117/1/</link>
<description><![CDATA[Latest threads from "Databases"]]></description>
<pubDate>Sun, 06 Jul 2008 22:08:54 GMT</pubDate>
<lastBuildDate>Sun, 06 Jul 2008 22:08:54 GMT</lastBuildDate>
<item>
<title><![CDATA[A Question about making forms EDITABLE...]]></title>
<link>http://www.boardtracker.com/rss/thread/63321124</link>
<description><![CDATA[ Hi I have currently have Private Sub Form_Load() Me.Form.AllowEdits = False End Sub But this locks the whole form including my Search Box, and doesn't let me type anything in here How can i exclu...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63321124</guid>
<pubDate>Sun, 06 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Problem with Auto-Updating a Date Field...]]></title>
<link>http://www.boardtracker.com/rss/thread/63321133</link>
<description><![CDATA[ I have a database that has data input on one main form that contains various sub-forms for different data types in various tables, all connected via an ID code. On one of the sub-forms, I want...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63321133</guid>
<pubDate>Sun, 06 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Macro to run a Delete Query...]]></title>
<link>http://www.boardtracker.com/rss/thread/63318723</link>
<description><![CDATA[ Hi, I wasn't sure whether to put this in the query section or Macro section of the forums, so forgive if not in the right one. I have a macro that runs a delete query, and that works ok, but ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63318723</guid>
<pubDate>Sun, 06 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Change field value depending on Combo box selection...]]></title>
<link>http://www.boardtracker.com/rss/thread/63321129</link>
<description><![CDATA[ Hi, I am stuck into a situation where i need to update a value in a field of a table. The situation is like this. I have a table &quot;Device&quot; and &quot;tblassignment&quot; with one to many r...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63321129</guid>
<pubDate>Sun, 06 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Is it SetTempVar problem? not work in *.mdb?...]]></title>
<link>http://www.boardtracker.com/rss/thread/63321136</link>
<description><![CDATA[ Hi, I have a Customer Form that is used as the 'List Items Edit Form' in the customer field of a Main Form, and I embed SetTempVar at Customer Form. In access 2007, If the customer name that I ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63321136</guid>
<pubDate>Sun, 06 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[report displays multilist ID but not associated value...]]></title>
<link>http://www.boardtracker.com/rss/thread/63318705</link>
<description><![CDATA[ I have a report based off a query. The query includes a table field that is collected from a multilist on a form (e.g. check all that apply). The multilist is based off another table that includ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63318705</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Append Query from MS Excel File...]]></title>
<link>http://www.boardtracker.com/rss/thread/63312127</link>
<description><![CDATA[ Hello Everyone, I have an existing MS Access Database and I need to create an append query that will look at a MS Excel file and add only certain specific columns to the DataTable of my MS Acces...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63312127</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Strange Behavior in Combo Box - HELP!...]]></title>
<link>http://www.boardtracker.com/rss/thread/63312702</link>
<description><![CDATA[ Greetings all, I'm a newbie to this forum and was looking for some help on an issue. I have a combo box on a form that is based on a query. The combo box is setup to show six fields of the query....]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63312702</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Sum(IIf(IsNull(query1dates.fdate),0,[fhours])) AS Sumfhours...]]></title>
<link>http://www.boardtracker.com/rss/thread/63312123</link>
<description><![CDATA[ The formula below did not show a zero in the resultant field Sum(IIf(IsNull(query1dates.fdate),0,[fhours])) AS Sumfhours I had to use Int and Nz to achieve this Sum(Int(nz(IIf(IsNull(quer...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63312123</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Comments In Queries...]]></title>
<link>http://www.boardtracker.com/rss/thread/63312120</link>
<description><![CDATA[ I know I have seen this on this site but cannot find it by search. I quite often bring SQL from SQL Server ( 2K &amp; 2K+5 ) into Access. Usually it runs clean with only minor changes like COAL...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63312120</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[How to Disable Editing SQL Server Linked Recordsets and Encrypt it?...]]></title>
<link>http://www.boardtracker.com/rss/thread/63303913</link>
<description><![CDATA[ I am developing a system using the MS Access 2003 tool. The backend is SQL Server MSDE2000. I want: - Disable the user from directly editing the SQL Server Linked tables objects in the database wi...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63303913</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Split Form Totals or Average etc for Datasheet...]]></title>
<link>http://www.boardtracker.com/rss/thread/63301230</link>
<description><![CDATA[ I have downloaded a very useful template from the Microsoft Template site to handle my accounts, and on the main Form, which is a split form, there is a most useful and helpful addition to the spr...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63301230</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[E-Reference Library subscription discount offer from Microsoft Press...]]></title>
<link>http://www.boardtracker.com/rss/thread/63303906</link>
<description><![CDATA[ Microsoft Press has created an exclusive discount URL for the E-Reference Library that MVPs can pass along to the broader community without any limitations or restrictions. To create a trial ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63303906</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Simple but dont have any idea how to do it......]]></title>
<link>http://www.boardtracker.com/rss/thread/63301232</link>
<description><![CDATA[ I have a simple issue im trying to sum to numbers and then put the result in total textbox but the major problems is that the table is not receiving this number, i just want to know how to get my ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63301232</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Need Help w/ PAC Database...]]></title>
<link>http://www.boardtracker.com/rss/thread/63312130</link>
<description><![CDATA[ For a little background, I have created a database for my company's political action committee (PAC), which among other things, list the contributions received by the PAC as well as the disburseme...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63312130</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[changing field format based on variable value of another field...]]></title>
<link>http://www.boardtracker.com/rss/thread/63301233</link>
<description><![CDATA[ I just spent an hour searching on this and didn't see anything - sorry if it's a duplicate! I have a form and subform. The form has basic info related to a client, one field is &quot;total volun...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63301233</guid>
<pubDate>Sat, 05 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Query Question...]]></title>
<link>http://www.boardtracker.com/rss/thread/63312132</link>
<description><![CDATA[ Hi I have two tables (tMachine, tMachineTime) in a query, they are linked so there is a one-to-many link between the tables (tMachine as the one and tMachineTime as Many). In tMachine there is a l...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63312132</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Retrieving data from Pivot Table View...]]></title>
<link>http://www.boardtracker.com/rss/thread/63301237</link>
<description><![CDATA[ Hi guys, Googled everywhere for this... When you've got a form open in pivot table view and you click on different areas of the view, is it possible to grab any data from this view e.g. em...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63301237</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Permissions and Tabbed control...]]></title>
<link>http://www.boardtracker.com/rss/thread/63303926</link>
<description><![CDATA[ May be an elementary question but I would appreciate any help available. I have a startup form made with a tabbed control, with separate tabs giving access to different facilities. Can I apply dif...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63303926</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[How do I store hyperlink? Newbie question...]]></title>
<link>http://www.boardtracker.com/rss/thread/63304144</link>
<description><![CDATA[ How can I store the pdf files so that when I move the whole folder to another drive I wouldn't have to change all the hyperlinks in Access? Please help ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63304144</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Problem in getting count of distinct values!!!!!...]]></title>
<link>http://www.boardtracker.com/rss/thread/63292017</link>
<description><![CDATA[ Hi all, I have a query that is retrieving values from a table, the result of the query is State RepCode Count AB AA 3 AB AA 4 BC BB 2 BC...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63292017</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Advice for structure...]]></title>
<link>http://www.boardtracker.com/rss/thread/63304136</link>
<description><![CDATA[ I have a database that was started in the mid 1980's using dBase IV. At some point it was converted to Access and modified several times. It contains biographies of more or less famous peopl...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63304136</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Displaying all rows of query results on a Form...]]></title>
<link>http://www.boardtracker.com/rss/thread/63301241</link>
<description><![CDATA[ Hi Everyone, How can I display the full set of a query's results on a form. Example: My query returns n records: OrgID, First, Last, Address, City, State, Zip I would like to be able to display t...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63301241</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Query in Access...]]></title>
<link>http://www.boardtracker.com/rss/thread/63292022</link>
<description><![CDATA[ Hallo, I have a table called sess_tbl with two fields, A1 and A2. Both fields have full description in text format. They should be similar, however some fields are not the same. How can I write...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63292022</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Lookup &amp; return for two fields...]]></title>
<link>http://www.boardtracker.com/rss/thread/63304156</link>
<description><![CDATA[ Hi Please can you help me. I have created two Table 1. Vessel Names 2. Shift details In shift details I have two fields that are the same as in Vessel names a. Vessel name b Vessel Number In my v...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/63304156</guid>
<pubDate>Fri, 04 Jul 2008 00:00:00 GMT</pubDate>
</item>

</channel>
</rss>
