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

<rss version="2.0">

<channel>
<title><![CDATA[BoardTracker - MS Access]]></title>
<link>http://www.boardtracker.com/all/264/1/</link>
<description><![CDATA[Latest threads from "MS Access"]]></description>
<pubDate>Wed, 03 Dec 2008 08:16:22 GMT</pubDate>
<lastBuildDate>Wed, 03 Dec 2008 08:16:22 GMT</lastBuildDate>
<item>
<title><![CDATA[Allowing a Null date...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750463</link>
<description><![CDATA[ Hi Access Forum, I have a select query that joins two tables. Table A has all records and Table B has dates relating to some records of Table A. When I use criteria to select dates =Date()-365 I g...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750463</guid>
<pubDate>Wed, 03 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Query with multiple Criteria...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750467</link>
<description><![CDATA[ I have a table that collects data for different branches' communications (branches are identified by the location) , the fields in this tables are: txtFileNo, datDateRec, datDueDate, txtLocation,...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750467</guid>
<pubDate>Wed, 03 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Form Icon...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748201</link>
<description><![CDATA[ Is there a way to change the icon of your database to something nicer then Access? Something that would make your project stand out? ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748201</guid>
<pubDate>Wed, 03 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[s-l-o-w query looking up records in same table (also difference between rows)...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750471</link>
<description><![CDATA[ I have a table and query that looks up previous records in. It works, but its really slow. Any suggestions to speed it up? Table t_detail fields: Code: id date stock qty brand 1 1/1/2008 1 1...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750471</guid>
<pubDate>Wed, 03 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Control Not Updating Table...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748183</link>
<description><![CDATA[ I have a form to record employees training progress to a Log table. I am in the midst of updating this entire process and at one time had this problem solved (I thought). The user selects and empl...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748183</guid>
<pubDate>Wed, 03 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Query with Between Criteria without Today's Data...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750480</link>
<description><![CDATA[ Hello Everyone! I'm working on a query that will generate records from a table using a Between [Start Date] and [End Date] criteria, however I want to avoid a user from pulling Today's Data beca...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750480</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Problem retrieving data from a subform...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748210</link>
<description><![CDATA[ Hello there,I’m working on an application that will be used to register people. The app is somewhat complicated so first I’ll explain what the app does (or is supposed to do) and then I’ll explain...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748210</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Crosstab Query Column Headings...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750485</link>
<description><![CDATA[ I have a crosstab query with 6 row heading fields and then the field [FTE_DATE_YM] as the column heading and the field [Hours] as value which is a sum. The FTE_DATE_YM field is a series of 12 mon...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750485</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Pivotchart: months with no data...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750492</link>
<description><![CDATA[ I (a total noob, i know) am trying to generate a pivotchart in a query that shows [quantity shipped] v. [month] relationship for each [product] in our database. However, the months in which no shi...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750492</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Problem with adding data to a subform...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748190</link>
<description><![CDATA[ Hello! I just found this site... I'm fairly new to Access and I'm trying to build an application for our business to create orders. The way its set up now, when someone selects from the ProductID ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748190</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Counting records...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750489</link>
<description><![CDATA[ Hey all, I am trying to create a database will which work out the total percentage of job being completed with 10 mins of them being reported for a given time period by the user. I have made a qu...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750489</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[This expression is typed incorrectly, or it is too complex......]]></title>
<link>http://www.boardtracker.com/rss/thread/65748227</link>
<description><![CDATA[ ...to be evaluated. for example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. This has been...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748227</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[hymnal form populating coding...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748216</link>
<description><![CDATA[ I have a DB with three fields song Hymnal/cd song Media Type I want them to populate I have the coding, So it I pick a song, it only displays the cd's or hymnals from that song ...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748216</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Criteria in a query...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750496</link>
<description><![CDATA[ Using Access 07 I have a query that has 2 different criterias using the OR command. When this query runs I get a parameter box asking for 1 set of criteria WHY? OR means either this one OR that on...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750496</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Textbox Control - City, State Zip Code...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748235</link>
<description><![CDATA[ I am trying to add a textbox to my form that will show the string --- City, State ZipCode. I am using the expression builder and cannot seem to get what I want. I am using =[City],&amp;' '&amp;[...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748235</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[string fields...]]></title>
<link>http://www.boardtracker.com/rss/thread/65750501</link>
<description><![CDATA[ Hi all, I'm having a problem on string field, the value is &quot;7081 - Paul Rooney&quot; how can I apply the str() or any alternative function just to get the 4 numbers on the string. Say I wan...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65750501</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Show / Hide Form Button...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748233</link>
<description><![CDATA[ I have a form that I want to act somewhat like a Switchboard. If a user has records they need to audit, I want a button to show that they can click on to display the records. If they don't have a...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748233</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Auto populate Text box from Combo....]]></title>
<link>http://www.boardtracker.com/rss/thread/65748239</link>
<description><![CDATA[ Hi, thanks in advance for any advice or support. I have an Access database with two tables: tblProducts tblDataEntry In the tblProducts table there are two fields ProductCode and Pro...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748239</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[taking text from 1 form to open data in another form...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748205</link>
<description><![CDATA[ All, I have a login form where the user types in their username and password. It looks up these from tbl_users. If the username and password match what is in here then the button loads another f...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748205</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[One query--three subforms...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748225</link>
<description><![CDATA[ Good morning, I have one query (based on primary key from my main table, plus another table). I need to make three subforms (on one tab/page) based on this one query. I have had several problems...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748225</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Help with form...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748243</link>
<description><![CDATA[ Hi, I have been asked at work to put together an access database. It will be used for purchase orders. I am OK with database and can do the basics. i have the bones of the database put together an...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748243</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Limiting access to forms...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748254</link>
<description><![CDATA[ I have a form created in my access database and was wondering if there is anyway to write a macro, or anything else to limit access of just the form to a specific group of people. The database con...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748254</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Search form doesn't allow edits, Combo box not allowed to be used...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748247</link>
<description><![CDATA[ HI Guys, I'm using Access 2003. I have a continious form that is searched by a UNSPSC code. This form allows additions, but not edits, deletions or filters. With this form, I have a comb...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748247</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Textbox value = all subform records...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748196</link>
<description><![CDATA[ First off, good day to all! I've been searching for a solution to this for weeks, can anybody here help me?... I'm a bit too novice to get my head round it I have a form (CustomerForm) that c...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748196</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>
<item>
<title><![CDATA[Scroll wheels...]]></title>
<link>http://www.boardtracker.com/rss/thread/65748221</link>
<description><![CDATA[ Hi just a quickie (I Hope) I have a form showing different courses with a subform for adding students to the courses.my problem is that people are using the scroll wheel on the mouse to add stud...]]></description>
<guid isPermaLink="true">http://www.boardtracker.com/rss/thread/65748221</guid>
<pubDate>Tue, 02 Dec 2008 00:00:00 GMT</pubDate>
</item>

</channel>
</rss>
