http://help.lockergnome.com/office2/General-Discussions-forum-1.html Latest 15 Messages on help.lockergnome.com http://help.lockergnome.com/office2/school--ftopict803601.html#2509194 What is the pupose of setting a default value for a field? a Data integrity; users are not allowed to enter any other value b Saves time; the default value is automatically entered in new records c Data entry simplification; the default value is easily entered by double clicking or d none of the above http://help.lockergnome.com/office2/Storage-Remote-Access-FE--ftopict800616.html#2509185 i want to thank everone who responded to my questions sorry it took two years to do so i ve learned a lot since then mostly from this forum as to the application mentioned in this post i did actually complete the project terminal server sessions was the solution worked great and exactly as needed i could not have done it without all the info from you all i am now ba http://help.lockergnome.com/office2/Memo-Field-include-field-field--ftopict803596.html#2509184 On Sat 21 Nov 2009 06:51:17 0500 Douglas J Steele wrote: Yes that s possible I did mine as an expression in the ControlSource of the control on the report and I did get the full memo text not just the first 255 chars Tom Microsoft Access MVP >I suspect that the OP had Note: [Note] in the query that s used >as the report http://help.lockergnome.com/office2/Address-book-access-problem--ftopict803598.html#2509183 Sorry but this newsgroup is for questions about Access the database product that s part of Office Professional You d be best off reposting to a newsgroup related to whatever e mail client you re using or one related to Windows Doug Steele Microsoft Access MVP http: I Am DougSteele no private e mails please pecan@bigpond com <pecanbigpondcom@discussions microsof http://help.lockergnome.com/office2/Make-text-box-border-color-change-conditional-formatting--ftopict803557.html#2509173 Glen wrote in message news:5DF91AB5 CF92 464B A8DF 382753A858B4@microsoft com > I d hate to tell you this but the code makes no difference I inputted > it > exactly as shown > > Maybe I forgot to mention something or was not clear Here is a recap: I > have a table which contains a field named Staff_Section Some fields > have > a sta http://help.lockergnome.com/office2/Date-Format--ftopict723198.html#2509169 RPage Thanks that was extrememly helpful thank you RPage wrote: > Fel > I m new to Access but I had the same need as you After a lot of tinkering > I think I got all of the dates to work with the following You ll have to add > the space and the month after this but this gets the days displaying > correctly > > =IIf Format fncOrdinal [ShippedDate] > > > AS Da http://help.lockergnome.com/office2/double-indent-paragraph--ftopict803594.html#2509166 This newsgroup supports MS Access the relational database Post your question to a newsgroup supporting MS Word by the way how depends on what what version of Word? Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post Mention and or description of a product or service herein does not co http://help.lockergnome.com/office2/Web-based-news-browser--ftopict803576.html#2509161 Dale Fye wrote: > Don t know what has happened lately but the the MS web based news browser > functionality has decreased lately > > Up until recently searching on my name in a particular group or in the > groups parent microsoft public access would return those posts that I made > or replied to on the current date at the top of the list of posts It no > longer does that http://help.lockergnome.com/office2/cd-pictures-load-windows--ftopict803590.html#2509159 Bobby Lou Two issues here 1 This is a newsgroup for Microsft Access a database software I would suggest you contact your camera Vendor or post in the Windows newsgroup 2 Use the big white space to post your question not a reference to go read the Subject Line The Subject Line is only so long and mine cuts off so anyone reading it will not get the entire issue you ar http://help.lockergnome.com/office2/Reference-controls-subform--ftopict803592.html#2509158 You need two VBA code steps to do this the first to set focus on the control that holds the subform the second to set focus on the control in the subform: Me NameOfSubformControl SetFocus Me NameOfSubformControl Form NameOfControlOnSubform SetFocus A macro action can be used instead if you want using the SetFocus action But you still need two steps Ken Snell http://help.lockergnome.com/office2/display-date-edit-database-report--ftopict803579.html#2509145 You could easily get the modification date for the db file This would be the same date time that s displayed in Windows Explorer As long as your db is split and you get the file date for the backend you can be sure it has not been written to since that date Nona wrote in message news:D0A28153 784A 4B0B 8FB9 D3B462F18BA5@microsoft com > Thank http://help.lockergnome.com/office2/start-runtime-2007--ftopict803587.html#2509142 Thanks DanielI apparently have the wrong concept If I understand you correctly: If I want someone who does not have Access to run my program I would send them or have them download the free microsoft AccessRuntme exe file for installation on their computer This isn t clear on microsoft s notices though I guess it is obvious to those with some software knowledge I have seen http://help.lockergnome.com/office2/Recordset-updatable--ftopict803586.html#2509135 In my subform table I have the following macro to open frmDetails when user double clicks a record Im using Macro Generator: Action: OpenForm Form Name: frmDetails View: Form Where Condition: = [WName]= [WName] Dirk Goldgar wrote: > GSB wrote in message > news:87C8CBA2 E841 4BC8 B447 39154F90FBA2@microsoft com > > Hi I http://help.lockergnome.com/office2/Move-Table-ACCESS-Sharepoint--ftopict803583.html#2509132 See if this article helps regarding the info on linking http: office microsoft com en us access HA101314631033 aspx If not i am sorry Richard wrote: > Hi > > Is there a way to move ONE table from an ACCESS database to Sharepoint and > link the table and the resulted Sharepoint list? It seems either I have to > move all the tables using Move to SharePoint or I can http://help.lockergnome.com/office2/Access-2000-Windows--ftopict803578.html#2509100 Hi I have an Access 2000 program that I package using Developer 2000 and Access Run time Does anyone know if this package will install and run under Windows 7? Thanks Phill <em>Using <a href="http://www.gotoassist.com/chris">GoToAssist</a> is the easiest way to view and control another person's computer online. Use it to provide instant technical support to family, friends and customers. Start a session with just one click, and instantly connect with the other party. </em> chris@lockergnome.com (Chris Pirillo) Partner Mon, 13 Jul 2009 06:30:00 GMT http://gotoassist.com/chris/ http://gotoassist.com/chris/ You need these network tools, no matter which operating systems and networks you have to support. <a href="http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome">SolarWinds ipMonitor</a>: Affordable Network Monitoring for SMBs. Get turnkey network, server and application availability monitoring with SolarWinds ipMonitor v9.0. This easy-to-use, reliable solution for SMBs delivers out-of-the-box availability monitoring so you always know exactly what's up with Active Directory, DNS, Exchange, FTP, Web, IMAP, MS SQL Server, and SMTP. <a href="http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome">Download your free trial today</a>. Or, try their <a href="http://www.solarwinds.com/products/freetools/">totally free tools</a>! And, through 2/29, save 20% when you purchase <a href="http://store.solarwinds.com/s.nl/sc.16/.f">ipMonitor 9.0</a>. chris@lockergnome.com (Chris Pirillo) Partner Mon, 25 Feb 2008 06:30:00 GMT http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome Starting at just $3.99/month, web hosting from <a href="http://www.godaddy.com/gdshop/default.asp?isc=cp2">GoDaddy</a> includes 99.9% uptime, 24/7 support and free access to GoDaddy Hosting Connection, THE place to install over 30 FREE applications sure to help you get the most from your hosting plan and Web site. Enter <a href="http://www.godaddy.com/gdshop/default.asp?isc=cp2">code CP2</a> at checkout, and save an additional 10% on any order. <p>Plus, as a friend of Chris Pirillo, enter code <a href="http://www.godaddy.com/gdshop/default.asp?isc=chris7">CHRIS7</a>, that's C-H-R-I-S and the number 7, when you check out, and save an additional 10% on any order. Get your piece of the internet at <a href="http://www.godaddy.com/gdshop/default.asp?isc=chris7">GoDaddy.com</a>.</p> chris@lockergnome.com (Chris Pirillo) Partner Mon, 25 Feb 2008 06:30:00 GMT http://www.godaddy.com/gdshop/default.asp?isc=cp1 http://www.godaddy.com/gdshop/default.asp?isc=cp1 It doesn't matter if you're running on Windows or Mac OS X - every power user needs either <a href="http://send.onenetworkdirect.net/z/13766/rn_a32755/">Parallels</a> or <a href="http://send.onenetworkdirect.net/z/17081/rn_a32755/">VMware</a> (or both). There's never been an easier way to test software without destroying your primary operating system's stability. Think of how many times you wish you could press a 'reverse' button on your computer. Plus, there's no easier way to try new Linux distributions - see what all the fuss is about. Run Windows in OS X, run Linux in Windows, but the best way to do either is with <a href="http://send.onenetworkdirect.net/z/17081/rn_a32755/">VMware</a> and/or <a href="http://send.onenetworkdirect.net/z/13766/rn_a32755/">Parallels</a>. chris@lockergnome.com (Chris Pirillo) Partner Mon, 25 Feb 2008 06:30:00 GMT http://chris.pirillo.com/2008/02/19/parallels-or-vmware/ http://chris.pirillo.com/2008/02/19/parallels-or-vmware/ <p style="color: red">This feed is fueled by Lockergnome <a href="http://www.lockergnome.com/buy/">Online Shopping and Coupon Codes</a></p> <p> Before you shop next time, see if we have <a href="http://coupons.lockergnome.com/">a coupon</a> first. </p> chris@lockergnome.com (Chris Pirillo) Partner Sat, 12 Jul 2008 07:56:13 GMT http://coupons.lockergnome.com/ http://coupons.lockergnome.com/