http://help.wugnet.com/office2/forum-c1.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office2/Storage-Remote-Access-FE-ftopict800563.html#2681672 By: david s. - 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.... http://help.wugnet.com/office2/Display-colors-text-box-ftopict848170.html#2681669 By: Megaton - This works too, although it indent numbers a bit. Thanks a lot "fredg" wrote: > On Fri, 20 Nov 2009 18:56:02 -0800, Megaton wrote: > > > This may sound crazy. If I want to display red for negative numbers and > > yellow for positive numbers on the same text box on a report, is it possible? > > > > Thanks > > Set the control's Format property to: > # [Yellow];-# ... http://help.wugnet.com/office2/Cell-Counting-call-ftopict848169.html#2681663 By: Douglas J. Steele - Sounds as though you're talking about Excel. 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 Excel. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "urlocaljeweler" ... http://help.wugnet.com/office2/Age-Case-closure-ftopict848155.html#2681661 By: KenSheridan via AccessMon - OK, lets go back to basics: 1. The GetAgeWithMonths function is the code I sent you in my first post, from the line: Public Function GetAgeWithMonths(varDoB, varClosedate) As String down to the line: End Function You need to add this function to your database by putting the code in any standard module. As it already appears from your earlier po... http://help.wugnet.com/office2/Date-Format-ftopict723198.html#2681659 By: ms saintclair - 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([Shipped... http://help.wugnet.com/office2/Report-problem-ftopict848168.html#2681657 By: Duane Hookom - I think you have a normalization issue. "9 different jobs" should create at least 9 different records in a related table. -- Duane Hookom Microsoft Access MVP "Jen" wrote: > > > "Jen" wrote: > > > Hi Guys, > > I have a form where you can enter employee details. Each employee has to > > be trained on 9 different jobs so there were too many controls ... http://help.wugnet.com/office2/Debugging-work-Access-2007-ftopict848159.html#2681654 By: Tom van Stiphout - On Thu, 19 Nov 2009 08:25:31 -0800, "John Ruff" wrote: Is your database in a Trusted Location? Check the help file on this topic. -Tom. Microsoft Access MVP >The inventory db was initially created in Access 2003 and when debugging, >everything worked as expected. Code stopped at stop commands, code stopped >at a line of code that... http://help.wugnet.com/office2/Free-Download-FLV-VOB-3GP-MPEG-MP4-DVD-Video-Cutter-Soft-ftopict848166.html#2681651 By: steven605 - http://www.itouchconverterformac.com/vob-to-itouch-converter-for-mac/itouch-converter-for-mac.jpg 2.Click"Add Files" http://www.itouchconverterformac.com/vob-to-itouch-converter-for-mac/add-file.jpgto input the video you need to convert. http://www.itouchconverterformac.com/vob-to-itouch-converter-for-mac/add-files.jpg 3.Check the proper iPod Touch output profile format ... http://help.wugnet.com/office2/Free-Download-flash-flv-DIVX-M2TS-VOB-iPod-touch-Mac-ftopict848165.html#2681650 By: steven605 - http://www.itouchconverterformac.com/vob-to-itouch-converter-for-mac/itouch-converter-for-mac.jpg 2.Click"Add Files" http://www.itouchconverterformac.com/vob-to-itouch-converter-for-mac/add-file.jpgto input the video you need to convert. http://www.itouchconverterformac.com/vob-to-itouch-converter-for-mac/add-files.jpg 3.Check the proper iPod Touch output profile format ... http://help.wugnet.com/office2/default-ftopict848151.html#2681642 By: chris.nebinger - My recommendation would be to look at their software and purchase it if it meets your needs. It'll probably be alot cheaper than building it yourself. Chris On Nov 17, 12:09pm, vpmedia wrote: > I think I posted this in the wrong group before.... > Where I work they have asked me if I can try to make this for the company..... http://help.wugnet.com/office2/Hiding-values-report-ftopict848146.html#2681640 By: BruceM via AccessMonster. - When you see something with "AS" it means there is an alias for the field: Nz(---,0) , criteria >0 >SQL show below:- > >SELECT Products.ID AS [Product ID], Products.[Product Name], Products. >[Product Code], Nz([Quantity Purchased],0) AS [Qty Purchased], Nz([Quantity >Sold],0) AS [Qty Sold], Nz([Quantity On Hold],0) AS [Qty On Hold], [Qty >Purchased]-[Qt... http://help.wugnet.com/office2/share-ftopict825920.html#2681635 By: Rafiq Aziz - (1) copy your database & pest 2nd computer (2) Open 2nd db & Delet all TABLE (3) Link all Table From 1st computer db Thankyou rafiqmpl.it@gmail.com Yousof wrote: share 13-Apr-08 Hi, all I want to share one data base file with two computers, may file contains query, forms & reports. So please I want help step by step to create this sharing and how it wil... http://help.wugnet.com/office2/soumission-ftopict848158.html#2681633 By: marco c - salut http://help.wugnet.com/office2/becky-comming-ftopict848157.html#2681631 By: Frankie Harbison - Becky is comming on sat at 1:00pm-- We will have supper here at 4pm . I would like as many as can to come and at least stop in. Slao baout Xmas I think we need to keep it at 7PM on Xmas after Jimmy gets off. Than no one will have to ask off work and those that can come early and we will have finger food so you can eat when you want. The presents will start ar... http://help.wugnet.com/office2/add-code-rptInvoice-compute-interest-amount-ftopict848156.html#2681629 By: Allen Browne - It is possible to put a calculated field on a report, e.g. a charge 7.25% on the Amount field would be: =[Amount] * .0725 However, what you are proposing is probably to complex to do in that way. If you are planning to add charges at specific times (e.g. end of each month), at specific rates (which may change over time), based on the daily balance (not merely ... http://help.wugnet.com/office2/Making-query-creates-base-table-ftopict848154.html#2681627 By: erika gomez - en realidad no me hagais mucho caso porque he perdido un poco la intuicion y yo siempre me he guiado por mis instintos o mi intuicion tendre que volver a desarrollarla ahora me guio por la inteligencia que es lo que me queda pero espero que trateis bien a mi familia porque no se merecen que les hagan dao ok besos erika "james" escri...