Lockergnome help - Access - Table Design

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

new table from same data as report

That would be a bonus Maybe a record of the invoice number that is tied to the client and project and date time of invoice along with your suggestion? What do you think? Scott Wha Jeff Boyce wrote: >Not sure what you mean by pointers to the data > >Would it be sufficient to capture the selection criteria used thereby >making it possible to re run the query and get the same da

Calculations in Access 2007 Reports

Cheri It s not easy to tell you exactly what to do without having more information However if you have 2 field let s call them Cost and Price that you sum in a group footer To get the difference of them summed up you would put a text box in the footer with the following control source =Sum [Cost] [Price] Feel free to post back with more information if this doesn

Need a little help with syntax

Plisvb Is OrderID a numeric field and is this the max field you want or is InvID the field you really want? Daryl S plisvb via AccessMonster com wrote: > Hi Guys > > Having a little problem with some code I m wondering if anyone with a keen > eye can point out my error > > Private Sub Transaction_Type_AfterUpdate > If Me NewRecord Then > Me invID =

replication to designated hub

Martin Hore wrote in news:2009114103228martin hore@suffolk gov uk: > I think I have the same problem as mckenned following a migration > of my design master and all my replicas from one server to > another I even got our server team to re open the old server from > which my design master and replicas had been migrated and I > migrated them back again but still no joy with synchronisa

Defining Relationships Primary Keys between two tables

In message Jerry Whittle writes >Are you receiving a not updateable error or message? It s very difficult >to update more than one table with the same query The best way to do this is >to create a relationship with Referential Integrity enabled Then use a form >and subform combination whe

Relationships bwtween more than one table

On Tue 27 Oct 2009 16:23:41 GMT f123 via AccessMonster com wrote: >am working now on one database where i have 5 tables each record from one >table is related to one another in other table with One to Many Relation > >in other words each record from one table may has many records on the next >table > >Example: > >Tbl 1 Project >Tbl 2 Activity >Tbl 3 Desc

Table validation rule allow only one occurence in a field

I do not hink you can do it in a table but in a form If DSum <>0 then message and not allow change of checkbox Build a little test a little jaworski_m wrote: > > You do realize that with this rule enforced at table level you can only have > > two records in your table right? one Yes and one No > > Yes correct But I would like to have Many records not only

Query Speed

In message Manuel writes >Hi > >I have a database which contains tables which are linked via ODBC to >tables in my company s data warehouse The tables vary in size and number of >records but the larger tables can contain upwards of 2 Million records > >When I query the data particularly whe

Share a Db

1 All users of the database must have at least read write create delete or modify privileges to the folder holding the database file Not just the database mdb file but the entire folder I m betting that this is the problem 2 Open the database and go to Tools Options and Advanced Tab Set the Default Open mode to Shared and the Default Record Locking to Edited Record

Database Design help Newer user

You populate foreign keys by making selections in combo boxes on forms bound to your tables queries Lookups are good and necessary just not defined as lookup fields in tables Duane Hookom Microsoft Access MVP nathanelz wrote: > Wow this is really helpful Steve Thanks for taking the time to look into > this for me I still don t quite understand the best way to po

database bloat size

John I don t have any experience with whether formatting query output bloats the db ?feel like experimenting in your copious free time ? 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 constitute endorsement thereof

Code to gather information

I m still having some trouble visualizing the data structure You posted in the newsgroup dedicated to supporting table structure and db design would you please post a description of your table see my previous response for an example ? Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post Men

Access keeps rounding down my numbers in a number field

On Sat 10 Oct 2009 17:11:01 0700 tsmith0125 wrote: >I have created a database for a non profit that must show at least 75 >participation When an attendee meets 4 of 6 hour attendance the program >rounds down to 4 from 4 5 I have tried all formats and only currency shows >4 5 but of course that is with a HELP The format is alm

Please Help?? Split Database Refering to backend

Duane I want to split my db for other reason than to share with tons of people and I want the backend on the local machine The db front and backend will be distributed as a packaged solution to a singler user The user will install the access runtime as well as the db s When I try to split the db called My Jewelry Project and place the backend in a folder called My Jewelry Data u

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.