Lockergnome help - Access

Displaying a single field or two fields together

It is getting more complicated Try this one > Expr1: IIf Len [Field 2] > > and > > I just found records that don t use either field Can I get it to display > N A if neither field is used? > > thanks again > JJ

Group ungroup Objects in Access 2007

How do I group objects such as text boxes on a report in Access 2007? I thought that was something I could do in 2003 and it seems to have disappeared Any suggestions?

Increase number in table by 1

On Mon 23 Nov 2009 14:10:02 0800 PPCO wrote: >What this is for is a delivery route with the deliveries listed in the order >they ll be serviced What I was hoping was when we start delivering to a new >customer we could insert that customer in the order they should appear on >the route I was thinking of ordering the customer sequence with a number

Order 7446453 Christmas Ornamwents Personalized

Lisa I was so sorry to hear of your loss I received an e mail from paypal refunding the amount of my order Does this mean that you are not able to fill my order I hope that you can fill my order because I looked a long time before I found the perfect wooden ornaments I give my nieces nephews and all of my kids snowman ornaments every year for Chrismas and it is getting to be

Using a database created in Access 03 in Access 97

Access 97 cannot read the Access 2000 file format Doug Steele Microsoft Access MVP http: I Am DougSteele no e mails please Dorian wrote in message news:E8A1204B 156D 446E 8490 2B6B5B448868@microsoft com > Well I recommend using the same version at home and at work but if you > cannot you need to save your Access 2003 database in

new table from same data as report

So you re saying you would NOT need to recreate the invoice only to remember that invoice as belonging to a given client project and date time? That sounds like a table 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 con

ARCHIVING FILES

On Mon 23 Nov 2009 07:09:01 0800 Pat wrote: >I have yearly HR files from 2001 which I need to save but would like to >reduce the number of visible files upon opening Is there a way to move them >to a folder but keep them active like you can in word and or excel? I see that you mean tables and queries but in a properly designed database you w

Memo Field needs to include field name within field

That worked great Thank you Tom van Stiphout wrote: > 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 su

access 2003 sp3 The program stops responding

Hodde wrote: >When I change something i a form design view the program stops responding >for while Not used network connection are disconnected Check your table links You might have some tables pointing to a network share Tony Tony Toews Microsoft Access MVP Tony s Main MS Access pages http: www granite ab ca accsmstr htm Tony

Question for school

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

Custom Tailoring An Access Report to fit an Existing Form

I work for a State Correctional Facility as the Mailroom Supervisor and Computer Help Desk Representative While Inmate receipts are still being written by hand there is a Stand Alone Computer Receipt System consisting of a Stand Alone Computer Okaidata 321 Impact Printer 3 color part copy form fed preprinted number receipt form and Lotus Approach Software that generates Inmate rec

BE Storage and Remote Access via FE

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

Address book access problem

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

Ms Access Rpt Change prior detail line format

Maybe a 117;nion query like this SELECT Null AS Field1 Null AS Fiwld2 TOT AS Area Sum tbl_PE P1 AS P1_ Sum tbl_PE P2 AS P2_ Sum tbl_PE P3 AS P3_ FROM tbl_PE GROUP BY Field1 Field2 TOT 85;NION ALL SELECT Null AS Field1 Null AS Field2 Area IIF Sum tbl_PE P1 = 0 N A Sum tbl_PE P1 AS P1_ IIF Sum tbl_PE P2 = 0 N A Sum tbl_PE P2 AS P2_ IIF Sum tbl

Make a text box border color change with conditional forma

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

How to Handle Remote Tech Support

chris@lockergnome.com (Chris Pirillo) — Mon, 13 Jul 2009 06:30:00 GMT

Using GoToAssist 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.

Network Tools for Windows

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

You need these network tools, no matter which operating systems and networks you have to support. SolarWinds ipMonitor: 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. Download your free trial today. Or, try their totally free tools! And, through 2/29, save 20% when you purchase ipMonitor 9.0.

Get Your Own Web Site

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

Starting at just $3.99/month, web hosting from GoDaddy 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 code CP2 at checkout, and save an additional 10% on any order.

Plus, as a friend of Chris Pirillo, enter code CHRIS7, 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 GoDaddy.com.

VMware and Parallels for Virtual Machines

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

It doesn't matter if you're running on Windows or Mac OS X - every power user needs either Parallels or VMware (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 VMware and/or Parallels.

Coupons for Online Shopping

chris@lockergnome.com (Chris Pirillo) — Sat, 12 Jul 2008 07:56:13 GMT

This feed is fueled by Lockergnome Online Shopping and Coupon Codes

Before you shop next time, see if we have a coupon first.