MSGROUPS.NET | Post Question | Search | About | Groups | Contact | Register | Login



microsoft public excel misc (5739)

microsoft public outlook general (4862)

microsoft public excel programming (4237)

microsoft public word docmanagement (3546)

microsoft public excel worksheet functions (3212)

microsoft public access (3187)

microsoft public windowsxp general (2052)

microsoft public windows vista mail (1635)

microsoft public office misc (1581)

microsoft public windows vista general (1516)

microsoft public windows live mail desktop (1371)

microsoft public access queries (1333)

microsoft public powerpoint (1282)

microsoft public access formscoding (1215)

microsoft public mac office entourage (1208)

microsoft public dotnet languages csharp (1191)

microsoft public access forms (1169)

microsoft public internetexplorer general (1140)

microsoft public access modulesdaovba (1077)

microsoft public windows server sbs (1066)

microsoft public greatplains (1057)

microsoft public mac office word (1026)

microsoft public outlook calendaring (967)

microsoft public excel (938)

microsoft public sqlserver programming (911)

microsoft public project server (886)

microsoft public windowsupdate (827)

microsoft public windowsxp help and support (801)

microsoft public windowsmedia player (788)

microsoft public project (786)

microsoft public access reports (768)

microsoft public mac office excel (767)

microsoft public exchange admin (757)

microsoft public dotnet framework aspnet (747)

microsoft public sqlserver server (704)

microsoft public outlook (704)

microsoft public outlook contacts (681)

microsoft public dataprotectionmanager (665)

microsoft public word vba general (641)

microsoft public windows server general (632)

microsoft public windows server active directory (589)

microsoft public outlook installation (588)

microsoft public word newusers (565)

microsoft public publisher (518)

microsoft public excel newusers (510)

microsoft public excel charting (503)

microsoft public word pagelayout (498)

microsoft public dotnet languages vb (470)

microsoft public vb general discussion (461)

microsoft public development device drivers (448)

microsoft public word application errors (437)

microsoft public office setup (430)

microsoft public sharepoint general (427)

microsoft public windowsce platbuilder (414)

microsoft public access gettingstarted (412)

microsoft public windows powershell (409)

microsoft public onenote (399)

microsoft public frontpage client (393)

microsoft public sqlserver reportingsvcs (390)

microsoft public outlookexpress general (371)

microsoft public access tablesdbdesign (354)

microsoft public pos (354)

microsoft public vc mfc (347)

microsoft public outlook program vba (341)

microsoft public windows live messenger (325)

microsoft public money (310)

microsoft public windowsxp hardware (300)

microsoft public windows 64bit general (297)

microsoft public scripting vbscript (290)

microsoft public windowsxp basics (240)

microsoft public windows mediacenter (230)

microsoft public dotnet general (227)

microsoft public mac office (198)

microsoft public nntp test (195)

microsoft public windows inetexplorer ie6 outlookexpress (194)

microsoft public win98 gen discussion (155)

microsoft public windows vista music pictures video (154)

microsoft public sharepoint setup and administration (142)

microsoft public windows vista hardware devices (130)

microsoft public dotnet framework (105)

microsoft public windows vista performance maintenance (97)

microsoft public visio (90)

microsoft public access 3rdpartyusrgrp (73)

microsoft public dotnet xml (59)

microsoft public access conversion (56)

microsoft public pt windowsxp (36)

microsoft public windows live photogallery (32)

microsoft public access developers toolkitode (32)

microsoft public dotnet faqs (15)

microsoft public dotnet framework aspnet datagridcontrol (10)


microsoft.public.access.tablesdbdesign Post New
Items(354) /4 Next >> Last >|
Subject Posted Replies From
How do I setup a date field property that allows only Saturdays?

For example: 03/13/2010 would be fine, as that is a Saturday. 03/12/2010 would return an error message as it is a Friday. How would I create a field property for this, or would I use a different aspect of Access creation?

3/12/2010 2:44:01 AM 3 =?Utf-8?B?amF5bWFsZWE=?= <jayma...@discussions.microsoft.com>
Date Format

I'd like to create my own Date / Time format. The Excel Equivalent is MMM-YYYY (Mar-2010). How can I change/create a new date format that will be displayed MMM-YYYY? I want to be able to query this table and run criteria based on the date. Thanks. (B^>)-]=[

3/11/2010 3:14:54 PM 1 "WSR" <wsr-...@hotmail.com>
UNLOCK A SECURED CODE MODULE

Hi All. I need to send a "patch" to a remote user to replace a form in an Access 2007 application. The code behind the forms of that database has been locked with a password. In order to copy the new form into the place of the previous one I first need to unlock the code, copy the form and then relock the code. Everything is quite simple except I cannot get the code to unlock from the "patch" application. The password is known to me. Any pointers will be appreciated. -- Kepior Senso Fumor

3/11/2010 3:45:01 AM 2 =?Utf-8?B?QW5kcmV3REI=?= <Andre...@discussions.microsoft.com>
String with Varying Letter followed by Incremented Number

I'm new to Access and really don't even know how to ask what I need to know, but I'll give it a shot and maybe you brilliant folks can figure out what I mean. We have three classes with students. Each student is assigned an ID. The ID contains a letter which indicates which class the student attends (L G or F) and that letter is followed by a 7 digit number that increments with each student no matter which class they are in. So our list might look like L0000001 G0000002 F0000003 We're developing a database, but this information in our current system has been kept in one field

3/10/2010 5:10:50 PM 2 Tat <puddyta...@gmail.com>
sync combox boxes

I have seen this question for older versions and for use on forms, let me throw my twist into this. I have a table called student list with lname, first name, grade, student id. I have a second table that records student parking stickers and parking violations called action list. there are linked by a one to many relationship by student id. I created a simple form from studnet list that shows the fields for the action file table below it. My use will enter data directly to the fiedls there not thru a form. (he likes that). My question when I ge to the filed make I would like t

3/10/2010 4:29:02 PM 2 =?Utf-8?B?dG9ua2FwbGF5ZXI=?= <tonkapla...@discussions.microsoft.com>
Designing a patient management

Being a newbie to access, I have been given a task of creating a db for the patient management and tracking. This DB will have around 50 patients per year. It will contain the history of patient's contact info, pediatrician, case manager,Genetic center info, Insurance info and so on. I have created the tables. pls review them and suggest me your ideas to improve the DB, as mine maynot be best. tblPatients RegID - PK PatientID,FirstName,LastName,DOB,Gender,Hospital,MA,CaseStatus,Diagnosis,Address,City,Zip,county,MFirstName(mom),MLastName,MAddress,MCity,MState,MZip,MHomePhone,MCel

3/10/2010 4:10:01 PM 4 =?Utf-8?B?U2ltYmE=?= <Si...@discussions.microsoft.com>
Help - is this possible?

So - This is what I am trying to achieve: In our business, our orders are made up of products (pizzas actually!) to which the customer can add or remove toppings. Adding a topping costs $1.00. My AddAnOrderandDetailsform captures the customer. My OrderDetailsSubform captures the products (S Margherita, for example), the unit price, quantity, and extended price (yes calculated by multiplying Quantity ad UnitPrice). I then have my ItemDetailsSubform which I want to capture the additional toppings or toppings removed, eg + Pepperoni or - Pepperoni. Both my OrderDetailsSub

3/10/2010 4:23:01 AM 2 =?Utf-8?B?UmFjaGVs?= <Rac...@discussions.microsoft.com>
Sharing a database with multi-users

Hi I have created a database in Access 2007 which will be placed on a server. At the moment, the database will have 10 users at a single time. Is it possible for all 10 users to open the database at the same time? Not all will be adding information but some will be just viewing the information. When should I split the database? Is this necessary? Thank you in advance for your help.

3/10/2010 2:15:01 AM 2 =?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
Changing Template Design

I am using the personal ledger template. I want the "Actual Amount" section to show a running total per row. I don't just want the grand total at the bottom. That way I can see how each transaction affects my account so I can compare to my bank account. How can I change the function of this or add another box to this? -- Thanks

3/10/2010 1:48:01 AM 1 =?Utf-8?B?SGVscA==?= <H...@discussions.microsoft.com>
Relationships

I have to figure out a way to reperesent/enter camper activities. It seems to be a many to many... I have many campers who will be singing up for many activities. How do I get that to come up on the sub form correctly... The main form is setup with the TbleCamperInfo as the primary table, with tabs and subs forms for the other corresponding tables... Let me know if it looks good so far... Here is a brief (not every field, but you'll get the idea) of the tables in question. Most all of the form stuff works well, until I get down to camper activities. You'll see below: Tb

3/9/2010 2:01:01 PM 5 =?Utf-8?B?VGhlRG9u?= <The...@discussions.microsoft.com>
design access

Hello everyone, I have a table tblOrders CustomerName DateOrder RefNo Amount Status primary key: RefNo Field type: Status - check box I have a table tblPayments CustName Datepaid PaidRef AmntPaid primary key: PaidRef can anyone help me figure out how can I design my query and my form/subform that when in my tblPayment field name AmntPaid equals to tblOrder field name Amount, access will automaitcally set the field name Status to Yes. please can anyone help me. thanks in advance, i appreciate

3/9/2010 10:21:01 AM 4 =?Utf-8?B?UmV2bmVk?= <Rev...@discussions.microsoft.com>
access database

I am trying to come upwith a way to track equment work and the parts I use in them . I nees to be able to track the hours from last rebulid and the time and parts for each job. Can any one help me with this.

3/8/2010 11:23:01 PM 2 =?Utf-8?B?dzdt?= <...@knology.net>
Importing data from multiple sources

I need to import data of members from two different sources, and then compare the data. Is there an easy way of doing this? -- Ted in Chicago

3/8/2010 8:36:01 PM 2 =?Utf-8?B?VGVkQ2hpY2Fnbw==?= <twie...@hotmail.com.(donotspam)>
Help with creating database

I'm a recent college graduate at a new job. I am trying to help my company move a report that is currently done in Excel into Access. To help you better understand my goal I will try to describe my business and the nature of this report as briefly as possible. We are a clothing designer. All of our product is produced in factories overseas and delievered to our clients in the U.S. Our W.I.P. report is currently in Excel. It's purpose is to give us an up-to-date picture of what part of the production line our products are currently in. Information on this report includes Styl

3/8/2010 7:41:01 PM 3 =?Utf-8?B?UGhpbCBTLg==?= <Phil S.@discussions.microsoft.com>
Data Rules Violations

I have a table of 19,000 records with about 225 fields in each record. It is not an indexed table, just a table of educational transactions. Some how when I go to update the historical table seven (7) records have gotten some bad info in them. I know I can copy the table to another database and look at them one field at a time, but this will take forever. Does anyone know a quick method of finding the seven bad records? Thanks in Advance John Q

3/8/2010 6:00:01 PM 13 =?Utf-8?B?Sm9obiBRdWlubg==?= <JohnQu...@discussions.microsoft.com>
how do I insert a hyperlink in my access database design?

I am a new access user. I need to insert a hyperlink into a table. I am trying to find the correct spot to do this in design view, on the properties sheet. What are the steps to utilize a hyperlink in a table that will also show up when I run queries and create forms and reports? THANK YOU for your help! RKB

3/8/2010 5:53:01 PM 1 =?Utf-8?B?UktC?= <...@discussions.microsoft.com>
Access Services?? Accessing DB from web??

Could someone explain to be the workflow/possibilities of Sharepoint or other Access services? Please forgive me, in advance, if I do not get all my terminology right on this subject. I continue to read things about Sharepoint and Access Services that hint at what I would like to do, but I don't quite understand what they do or how they intergrate into Acess or if they will for sure be a solution. Do any of these services make it possible for users to access a database from the the internet? If not is there a way to do this without building a php or asp based website to acc

3/8/2010 3:41:02 PM 2 =?Utf-8?B?RG9jdG9y?= <Doc...@discussions.microsoft.com>
Adding a second employee to an event

I have built an Operations Log database. In the database I have built built the following tables. tblLab(Lab where testing will occur) tblCustomer(customer who will test) tblEquipment(each piece of equipment we operate) tblEvent(particulars of event, i.e. startdate, starttime, enddate, endtime, purpose, employeeID) tblEventDetails(set up like an order, where the customer "orders" each piece of equipmnet for the event) tblEmployees(all possible employees from my group) Relationships have been laid out and the database is functioning properly if I only use one employee per eve

3/8/2010 2:58:01 PM 2 =?Utf-8?B?cmlja3ptYW4=?= <rickz...@discussions.microsoft.com>
Keeping data private per User in a multi user database

Hello. I have an Accounting Access DB that I intend at some point to split into front-end (tables, forms, reports) and back-end (data), then I hope to deploy on the web. I will eventually have around 30 distributed users (only about 5 concurrent) – each inputs the same type of financial data but does business independent of the others and so must NEVER see the data entered by the other users. To make future releases and bug fixes as simple as possible, I intend to have a single instance of the front-end that each of the Users will access. However, as each User must NEVER see

3/8/2010 1:50:02 PM 3 =?Utf-8?B?UGV0ZXI=?= <pe...@discussions.microsoft.com>
help transition to access from excel

I am transitioning from excel to access for the reason of the spreadsheet is only getting igger and harder to use. I am an Insurance agent and I am trying to set up a new database using the templates as munc as I can. I want to have the ability to access the customers information (contact management) and their account or policys. The problem is I have customers with more than one auto policy and more than one one person in a house hold with policys ex. husbands auto, wifes auto, family homeowners, husbands auto, wifes life policy, husbands business policy, sons auto policy.

3/8/2010 1:46:01 PM 8 =?Utf-8?B?RXJuaWU=?= <Er...@discussions.microsoft.com>
Thanks to Allen Browne... and all MVPs.....

Thanks you very much... for reply and thoughts.. convayed.. will look site and read again million thanks.. Dr. Khalak

3/8/2010 5:04:09 AM 0 "Ahmed" <mukha...@hotmail.com>
Should this be one to Many or Many to Many.. Relationship

Hi, New to Access learning... I have Table 1.. Publisher Table 2.. Books I was wondering .. Should I create Transient Third Table e.g. BooksPublisher.. Or Should I put PublisherID key AS Foreign key into Books Table ? which would be Practical E.g Books Publishers BooksNPublishers Pk BookID Pk PublisherID PK BookPublisherID Fk BookID

3/8/2010 12:40:05 AM 1 "Ahmed" <mukha...@hotmail.com>
Relational Database Layout

What I would like to do is create a database to track sales, customer info and customer demographics using 3 separate tables: Customer Info(name, address, phone, etc.), Sale info(what was purchased, date, size, etc), and Demographics(Gender, age, income, etc). I have the three tables populated with the needed fields but I'm having a problem creating the relationship setup so that I can say look up a customer or product and see what product that customer purchased or select a product and see which customers have purchased it. This is a beginner question, which I am, but w

3/7/2010 5:20:01 PM 7 =?Utf-8?B?Um9iIEg=?= <R...@discussions.microsoft.com>
Superclass have only a autonumber.. is it possible?

Work with IT for many years, and have lately begun looking into DB and MS Access. So Im quite a rookie in this area. :) Ok, Got a superclass named table1. That class has only one attribute, an ID which is an auto number. Then I have to subclasses called table2 and table3. They have the foreign key to ID, and a couple of other attributes. When I add a instance to my table2, I want it to add a new auto number in my superclass, table1. eg a new instance in table1.Is this possible at all? It seems that I need to first add to table1, and after that use that id in table2 or

3/7/2010 1:28:01 PM 2 =?Utf-8?B?TWlja2VfXzE=?= <Mic...@discussions.microsoft.com>
Creating new row in other table

Dear All, Please teach me, how to make a new row/list in other table by entering number in other table. Sample, In the table A and in the field "Details", I put the number 2 and it automatically creates two rows in table B. Can this be done in MS Access? Thank you for your help. Regards, Maulwy

3/7/2010 12:46:01 PM 5 =?Utf-8?B?TWF1bHd5?= <Mau...@discussions.microsoft.com>
Can you help me make a simple database / template

I need help making a database to track all my financial account info. I want to keep track of all my accounts payable and receivable. I have already set up 2 tables. 1) The contact information for my accounts 2)The specific account information (Acct #, monthly payment amt, due dates, current/delinquent credit reporting status, account type) I still need a table for all the receipts I have, and a table for my job incomes. I want to be able to enter new information as needed, and also be able to search through the information. Such as all the accounts that I have at one plac

3/7/2010 4:20:01 AM 4 =?Utf-8?B?UExTaGVscE1F?= <PLShel...@discussions.microsoft.com>
unique record numbers

I am trying to create a unique PIN for members in a table (not the primary key) that will be 4 digits long, and would like each new entry to be incremental. I am very new, and would appreciate a detailed instruction (though I can get around access fair enough). Any help would be appreciated.

3/6/2010 3:19:44 AM 5 =?Utf-8?B?UmV2IERhdmlkIEJpc3Nhcw==?= <Rev David Bis...@discussions.microsoft.com>
database for tanning salon

I do all this by hand everyday----- can anyone help me do this???? What it needs it to do is- 1. Customers: personal information tanning packages sessions expiration (packages have 3 months) 1 month unlimited 2 week unlimited which bed they used how long was there session Sales history 2. Daily Sales (each day with date) a. packages b. single sessions c. purchases lotion bottle name of lotion price d. package or shot of lotion name of lotion price e. miscellaneous item a. what it is b. price c. which emp

3/5/2010 11:43:41 PM 2 =?Utf-8?B?bWVmMTIxNw==?= <mef1...@discussions.microsoft.com>
Form Design

I feel fairly confident that I have my tables and relationships decently set. My problem now is how to display it for my staff to work with. I need some help with form layout Here's my scoop. I am re-building a camp database that was laid out on one entire table!!! So many fields... So many empty fields too. Nonetheless, we are moving onward and here is what I have... I have a camp database that has the following tables now: tblcamperinfo demographic info that may change (primary table) tblparentinfo info on parents and addresses could be more than one tblcmprcntyr d

3/4/2010 10:45:01 PM 10 =?Utf-8?B?VGhlRG9u?= <The...@discussions.microsoft.com>
Compact & Repair Bug

After using the compact and repair function manually from the manage tab of Access 2007, a glitch occurs where i cannot rename, delete or cut any of my objects (tables, forms, queries, etc). The options are greyed-out when i right-click on the object in the left object pane. Any way to rectify this issue so i don't have to backtrack to an earlier back-up of my database?

3/4/2010 4:31:02 PM 2 =?Utf-8?B?em1lbHJveQ==?= <zmel...@discussions.microsoft.com>
Intermittent locking problem

Using Access 2003. I have two applications each with their own FE's and BE's and using .MDE's for user FE's. Each .MDB file is set to "Share", "No Locks" and "record-level" locking. Each app (FE and BE) is located in a separate directory with full directory access for users of the specific app. So not all users of app #1 have full directory access to app #2 and vice versa. App #2 has a comboBox that gets its recordsource using a query based on a linked table to App #1's BE. Usually the comboBox in App #2 is populated and works. But occaisonally when users are in App #1, a

3/4/2010 1:56:01 PM 2 =?Utf-8?B?U3R1?= <...@discussions.microsoft.com>
autonumber is it possible to link two fields

Hi, Iam trying to do a project for uni and i need to have a letter infront of the id number that is generated. pls help! I have 15 unique ids and 3 variables, the 3 variables are to specify if the game in question, a league, cup or friendly so i need a F,C or L infront of the id num, all three of the variables are in a list box hope that helps!

3/4/2010 12:01:01 AM 1 =?Utf-8?B?RHdsaW9uMTk4Nw==?= <Dwlion1...@discussions.microsoft.com>
Player availability list

I am trying to record players availability for team matches throughout a season. For example I have say a possible total of 50 players and there are say 40 matches throughout the season. So far about 30 players have advised me for which of the 40 matches they are available. I wish to record this availability in Access and then to be able to advise the match manager of the various games which players are available for the match for which he is responsible. I have so far created one table of matches - recording date of fixture, opposition, venue, match manager and a second table o

3/3/2010 11:44:01 PM 1 =?Utf-8?B?R2VvSA==?= <G...@discussions.microsoft.com>
Adding up days from Date/Time entered

I'm new to Access and have a Table where I'd like to put in a Beginning date that an item was sent out on rent, and then put a date where it was returned from being on rent. I'd like to set up a record that sums the number of days that item was out, based on the previous two records. I'm looking for this to be shown in the Form view, as a user is putting in the dates. Thank you

3/3/2010 12:22:14 AM 3 =?Utf-8?B?SmVmZnJleSBXaWxzb24=?= <Jeffrey Wil...@discussions.microsoft.com>
Set Mytable = MyDB.OpenRecordset

Help, I am not much of a programmer, but I have managed to build a fairly good tool. The original code was written in 2003 but upon the conversion to 2007, I get a Type Mismatch on the following code. Const ProductTable = "Products" Dim MyTable As Recordset Dim MyDB As Database Dim PNHolder As String Set MyDB = CurrentDb() Set MyTable = MyDB.OpenRecordset(ProductTable) ---�<<< Error appears here??

3/2/2010 10:41:06 PM 6 "Tom" <Tom.Weissger...@intel.com>
Is there an option to zoom a form in design view to say 200%

I'm trying to line up some cells and zoom to 200% would make it much easier. I've checked help and this forum but have not found an answer to this. Thanks

3/1/2010 9:56:14 PM 3 =?Utf-8?B?UGVnZ3k1Ng==?= <Pegg...@discussions.microsoft.com>
What does "tlkp" mean?

There's a "standarized" naming convention used in the design of a database...tbl, qry, rpt, etc. When I d/l a 2007 template, it uses the prefix "tlkp". It's a table. What is meant by this? Thanks.

3/1/2010 8:20:01 PM 5 =?Utf-8?B?VG9sbGVy?= <Tol...@discussions.microsoft.com>
AYS Link broken?

I am trying to find the link to the "AYS" file - the ones previously posted seem to be broken. Thanks for your help!

2/28/2010 4:20:01 PM 1 =?Utf-8?B?VGVyeWUgTg==?= <Ter...@discussions.microsoft.com>
Renewing member database design question.

Hi, 1. Background: I have a member database for a local community club. I’m in the process of adding membership renewal processing to the module. There are two types of membership; Life Time and Annual. The Life members pay a one time fee and are members for life. The Annual members pay a membership fee once a year. The renewal drive starts in November. In October, when we print the November newsletter, we include a reminder notice in the monthly news letter that is mailed each member. Members will then pay their renewal by either check or cash. I want to star

2/27/2010 11:18:01 PM 7 =?Utf-8?B?RGVubmlz?= <Den...@discussions.microsoft.com>
Auto Population of fields

I have created a db that tracks equipment repair/expense. I have been asked to create fields in an entry form that would auto-populate based on information entered in another field. If Equipment # = FL1 than Model # would be XM123 and Serial # is 654-321. I have this information in a current table but can not get the desired result. Help! -- Never stop learning!

2/26/2010 9:46:01 PM 1 =?Utf-8?B?RUo=?= <...@discussions.microsoft.com>
Switchboard buttons not creating

I am using Access 2007. When I add a button it does not appear on the switchboard. I did delete one button, but it was not working either. How do I create a button that will appear and work properly? Thanks in advance for your advice.

2/26/2010 8:41:02 PM 2 =?Utf-8?B?Sk1ELlBhcms=?= <JMDP...@discussions.microsoft.com>
Restated: "Fields are expensive, records are cheap"

Hi, First let me apolozie for the empty question below. I hit the Post button my mistake and it posted a blank question. Sorry. Hi, I am restating my question because based upon the responses I receive I obviously stated my question incorrectly. So please let me try again. Hopefully I will be a bit more sucessful this time around. In a previous question, I stated that I added 30 fields the membership table (one of many in the system). The initial implementation was SO successful, that the user requested quite a few enhancements resulting in the in a HUGE increas

2/25/2010 4:51:01 AM 17 =?Utf-8?B?RGVubmlz?= <Den...@discussions.microsoft.com>
header full line but page 2 rows

Hi I like to design a report header and page over the full width of A4 paper. But all the data in 2 coloums.

2/24/2010 11:45:01 PM 1 =?Utf-8?B?QnJ1bm8=?= <Br...@discussions.microsoft.com>
I was told "Fields are expensive, records are cheap"

Hi, I just have a self education question. In response to one of my questions I stated that I added a lot of fields (a lot was 30 fields) to my table. The initial implementation was so successful, the user requested quite a few more enhancements resulting in the addition of 30 additional fields. One MVP who responded stated "Fields are expensive, records are cheap". I'm currious about his statement. I'm new to Access (less than a year) but I have over 30 years experience with relational databased on multiple platforms. I've always been taught the exact opposite - that

2/24/2010 11:44:01 PM 34 =?Utf-8?B?RGVubmlz?= <Den...@discussions.microsoft.com>
Selective database splitting

Is there a way to select the specific tables you want to split for sharing across a network while other tables will remain local to each users system? I specifically want to keep a version control table local to the system rather than having it split with the other tables.

2/24/2010 9:24:06 PM 5 =?Utf-8?B?RGF2ZUZyYWc=?= <DaveF...@discussions.microsoft.com>
Make Query or Linked Table Read Only

In Access 03 & 07 I have tables linked via ODBC to a MySQL database. Due to many security, DB, and vendor issues, I do not have an option to change the MySQL permissions or change the ODBC driver. I need to find a way to make the linked tables read-only (preferred) or at least make queries to those tables read-only. Simply locking the form's controls is not sufficient. I had users accidentally delete data in the MySQL anyway. Any suggestions would be greatly appreciated. I'm bordering on having to scrap a 3 month project if I can't secure the data. Thanks!! -- Regar

2/24/2010 7:51:02 PM 3 =?Utf-8?B?TGFycnk=?= <La...@discussions.microsoft.com>
Church Database

Trying to put together a simple database for our church directory and records. We need contact info as well as DOB and group involvement etc. Make directories, labels, email groups and basic reports. Which I had no problems with. What I am having issues with is the family relationship thing. We often need to do mailings per household as well as individuals. What is the best way to "group" my families. And how should they be entered? I thought making a check box to designate a "head of household" and when entering choose a family. Or have a seperate form for "families" THEN e

2/24/2010 7:17:01 PM 22 =?Utf-8?B?TWlzc1RoaW5n?= <MissTh...@discussions.microsoft.com>
Conversion To Acc2007 or beyond Suggestions ?

I am currently still using Access 2000 for my database development. The Acc 2000 also works with no problem with Acc 2003. I have also made some minor changes to resolve some issues with Access 2007 and it works with Access 2007. There is a Office 2010 coming out soon and I assume the Access 2007 will work it with very minor issues if any. My question is when you do recommend that I convert my database from Access 2000 to Access 2007 or Access 2010 ??? I would like to delay this as long as possible, but I also realize that I must convert it over to Access 2003, then to A

2/24/2010 6:54:04 PM 1 =?Utf-8?B?R2FyeQ==?= <G...@discussions.microsoft.com>
Training database

Is there any way to put this into plain english I am much better at visual instruction, I to am trying to build a training data base that can generate reports of who has been trained and be able to assign certain training modules to certain job functions. Here is what I want. 1. A list of employees, what location they work at, what they have been trained on, what they still need to be trained on, who trained them, when they were trained, and when they are due to be retrained. It would be nice to be able to have several employees enrolled in every class. I have tables set up as follows

2/24/2010 5:26:27 PM 2 "safetyman1958 via AccessMonster.com" <u58...@uwe>
Assistance with Many-to-Many Relationships

I'm looking into correcting a previously developed database that was originally done and works like an excel spreadsheet (all fields are currently in one table). In looking at it, there appear to be many many-to-many relationships involved. This is used to keep records relating to force used against suspects by police. In one incident, there could be 1 or more suspects involved, 1 or more officers involved, 1 or more types of force involved (possibly different force by each officer involved), none/one/more charges placed on the suspect, and a final disposition on each suspect

2/24/2010 3:21:01 PM 6 =?Utf-8?B?TGVlIEFubg==?= <Lee...@discussions.microsoft.com>
Append Query and Autonumbering

Using Access 2007; have 2 student db last year and this year, using autonumber as identifier. when i append old student to new db so that they keep old number; it causes the new db to change the autonumber when i add a new record to the 1 plus the old number instead of using new new numbers; did not have this problem in access 2003. when i appended records it put the record in and kept old number and then when i added a new record, it gave them next number.

2/24/2010 2:38:01 PM 1 =?Utf-8?B?U2hhcm9u?= <Sha...@discussions.microsoft.com>
Auto Complete field

I am using Access 2010 and I have a datasheet which records Invoice data: Invoice number Client ID Client surname Invoice date Invoice amount Date paid Invoice number is the primary key and the table is linked to the Client datasheet. I would like to be able to enter the Client ID in the Invoice Datasheet and have Access auto complete the Client surname field. Is that possible? Would I need to build an expression or is there something in Design that can be used? All help appreciated. Steve

2/24/2010 1:35:53 AM 1 "StevePlym" <stevep...@tesco.net>
Remote control of tabls

I have a database tables on the back end and multiple versions of front end users. Is there a way to access the table from a remote location though the internet or upload the tables to the internet and have the front end access the information in a way that the updated tables will be available to all? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1

2/24/2010 12:37:05 AM 1 "quinto via AccessMonster.com" <u35...@uwe>
Modify existing table for more details?

I have a table of estimates. Each estimate can have multiple locations stored as a text field. New need: I want to store the sizes of each location. Example is -Old method: EstNo= 200 which has Location = bedroom, Location= Family room. New need is: EstNo 200, Location = bedroom with Size= 100 and Location= Family room size = 125. I assume I need to split the Location field into its own table with a Location ID field, Location field, location size field and EstNo field. Also, How would I go about correcting the existing estimates that have no location sizes entered. Hope I di

2/23/2010 8:21:36 PM 9 Shannon <shannon.ne...@gmail.com>
Efficient Table Design Questions

I'm working on a Project Manager DBase for our engineering department. One of the things they want to be able to record within each project is the Size, Length and Material of the pipes installed. They also want to be able to run reports that would provide them totals based upon region, year, etc. So I'm looking at sizes ranging from 1/2" to 48" (approx 20 different sizes) plus a wide range of possible materials for each size. Question 1: Since a project could have multiple materials of the same pipe size installed, do I create a field for each possible size & material combi

2/23/2010 4:15:01 PM 3 =?Utf-8?B?TW9uZXQgMTM4?= <Monet...@discussions.microsoft.com>
Number format issue Access 2007

Access 2007. I've created a database with a number input and I'm getting the following errors. I've formatted a field as Number Field Size: Single Format: Currency Decimal Places: 0 I'm getting the following results Input 2,065,000,000 but it's rounding it to 2,064,999,936 Input 2,682,000,000 but getting rounded to 2,681,999,872 Any ideas on the reason for this? Do I have that field formatted properly? You help is GREATLY appreciated! (B^>)-]=[

2/23/2010 12:54:17 PM 2 "WSR" <wsr-...@hotmail.com>
Access table data type selections

When creating a new database table I am not given an option for attachments in the drop down menu. Anyone know why and how I can correct it? I get the usuals "text, memo, date, number OLE object..." but no option for attachments????

2/23/2010 2:53:01 AM 1 =?Utf-8?B?SmltIFM=?= <J...@discussions.microsoft.com>
Set Controls Default Value from another Control

I am working on a form for data entry where the user enters many records that may have similar information, i am trying to create a tab that would have all of my "Default" values so that for example if the user was going to enter 40 items from a PO they could go to the Defaults tab and enter the PO# and every record they enter on the subform would by default have the PO number entered. I have done this before where my data entry textbox controls default value is =me![DefaultNotestext] where [DefaultNotesText] is on my Defaults Tab and it is bound to a 1 record table so the valu

2/22/2010 7:30:02 PM 3 =?Utf-8?B?QmFycnkgQSZQ?= <Barr...@discussions.microsoft.com>
Slow form, again

Okay I'm back again, with the same problem, and at a loss. This is my 2nd database, and same brick wall! The loading of my form takes upwards of 40 seconds to load. I've gone through steps offered at previous posts (http://www.granite.ab.ca/access/performancefaq.htm). I even downloaded a template database (sales pipeline) from Microsoft and once split it slowed down dramatically as well...takes a solid minute to load their form. Could that suggest that my database design is solely not the problem and perhaps the network doesn't help? Details of my database: My form p

2/22/2010 4:35:02 PM 29 =?Utf-8?B?amVubmlmZXJzcG5j?= <jennifers...@discussions.microsoft.com>
How do I change the order that my records appear in in Forms

I've entered all my data, but now I want it to be displayed in Forms in order by a specific field. How can I do that?

2/22/2010 12:42:01 AM 3 =?Utf-8?B?QmV0aGFueS5SeWFu?= <BethanyR...@discussions.microsoft.com>
ORGANIZATIONAL CHART

Hi All Anybody know of software that will use Access Database as data source that will show an organizational hierachy similar to that shown in Word 2007 SmartArt? -- Kepior Senso Fumor

2/21/2010 8:58:01 AM 9 =?Utf-8?B?QW5kcmV3REI=?= <Andre...@discussions.microsoft.com>
Re:

"Patricia S. Lee" <oscomeats@aol.com> wrote in message news:... >

2/20/2010 6:36:56 PM 0 "Patricia S. Lee" <oscome...@aol.com>
Dance Classes

Hi, I posted a couple of weeks ago regarding a simple DB for dance classes and received excellent advice. I�ve made good progress but have another question. I�ve been reading a lot and understand the tables are the most important part and would really appreciate help again. I want to record class payments and also bank deposits. All payments are deposits but not all deposits are class payments. Some deposits are for other various items and I can�t figure out how to relate the deposits to the class payments. I normally hand write deposit slips then I have to post checks for cla

2/20/2010 6:25:42 PM 20 "Nomy" <non...@nonsense.invalid>
1 to 5 relationship

I have 2 tables table "Person" and table "Team" with a 1-M relationship a person can be a member of 0 or 1 team but a team can have from 0 to 5 Persons at the moment i am enforcing this with code is there any way to enforce this with a constraint on table "Team" ?

2/20/2010 12:54:52 PM 6 "Loterken" <loter...@pandora.be>
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 32239

Contato: marvendas@gmail.com marvendas @ gmail.com marvendas no gmail.com Kit completo de solenoides para Volkswagem e Audi. O kit contem: 5 solenoides 2 Epc ( solenoides de pressao ) 1 Chicote Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M Pre�o: R$ 1900.00 Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar! Audi a3 automatico Audi a3 1.8 t automatico Audi a3 1.8 turbo automatico VW Golf gti automatico VW Golf 2.0 automatico VW Golf 1.8 turbo auto

2/20/2010 3:00:35 AM 0 kit solenoites audi solenoid.chicote<kit.solenoites.a...@solenoid.chicote.com>
changing formats

I need to change a column from "date" to "text" in an existing table. When I highlight the column, it does not give me any other options on the formatting, just different types of dates. How can I do this? -- Huggybear551 Maumelle, AR

2/19/2010 5:48:04 PM 1 =?Utf-8?B?aHVnZ3liZWFyNTUx?= <huggybear...@discussions.microsoft.com>
Primary and Foreign Keys

It's the end of the day and I'm second-guessing myself and need some clarification regarding Primary and Secondary Keys and which tables they should be in. In a one-to-many relationship, the primary key is on the "one" side and the foreign key is on the "many" side, right? I.e. an Individual can have many phone numbers. tblIndividual IndID (PK) FirstName LastName tblPhone PhoneID (PK) PhIndID (FK) phonenumber phonetype What about in a one-to-one relationship? Does it really matter which the foreign key goes in? Is there an acceptable/preferred practice? I have

2/18/2010 9:27:58 PM 12 "Kathy R." <wild_r...@graffiti.net>
Footer Totals

I have a form that uses a combo box to select which vendor I want to see. When you select the vendor, it shows the people that use that vendor. I want to add a text box to the footer that shows a total number of people using that vendor and the total amount of money being used. Can someone help me? Please!! Thanks

2/18/2010 9:10:02 PM 2 =?Utf-8?B?b3BlbiBhIGFkb2JlIGZpbGUgZnJvbSBhIGNvbW1hbmQgYnV0dG9u?= <openaadobefilefromacommandbut...@d
Tab Order for Multiple Entry Form. Vertical not horizontal tabbin

Hi there, Does anyone know how to make the tab order go vertically along columns in a multiple entry form? It seems like that tabs will always goes along a row, so you have to tab through every field in a row before it will tab to the next row. I have already tried to do this through the tab order button in the arrange tab, but it doesn't help.

2/18/2010 8:26:04 PM 1 =?Utf-8?B?Z2tjaG8=?= <gk...@discussions.microsoft.com>
Sharepoint

I am createing an application that may, one day, if all goes well be put on Sharepoint for multiple users in different locations to use. Do i just proceed as normal or are there certain steps i should take in the design in order to ensure success if we put it up on sharepoint? thanks.

2/18/2010 2:00:01 AM 0 =?Utf-8?B?SkQgTWNMZW9k?= <JDMcL...@discussions.microsoft.com>
Field format

I need to have a project number that forces ensures that the field has 5 parts: 1. Always the letter C 2. Last two years of Year 3. 3 digit number (sequential) 4. "-" 5.2 digit sequential (usually just 00) So the first Project in 2010 will be : C10000-00, 2nd will be C10001-00, 3rd C10002-00 and so on How do I enforce this in the field - both in the table and in the form... Thanks! -- Message posted via http://www.accessmonster.com

2/17/2010 5:15:42 PM 1 "szag via AccessMonster.com" <u2...@uwe>
Relationships

Hi I am trying to change the field type in a table, from text to Number, and I am getting an error message saying that I need to delete relationships first. When I look at the relationship window, and scroll left/right/up/down, there are no tables in the window. I have selected Show All and one table is displayed. However if I select Database documenter > relationships, it is showing that there is a relationship Can someone tell me what's happening? Tks

2/17/2010 3:59:31 PM 9 Alex Hammerstein <...@misnet.co.uk>
Calculating percentage from eneterd values within a table/form

Within my database I have a table where I will enter the fresh weight of an object in one field and the thawed weight of the object in another field. I then wish access to calculate the percentage weight loss by : (Fresh Weight-Thawed Weight)/Fresh Weight*100 I have attempted to do this as a default value of a field during the design of a table, but as data has not been entered into the weight fields access gets confused and won't allow this. Is there a way to do this without creating a query or doing it within a form? If I have to create a query or do it within the form, is the

2/17/2010 3:03:01 PM 1 =?Utf-8?B?QmV4ODU=?= <Be...@discussions.microsoft.com>
Switchboard is always covering other windows that open

I've created a switchboard. It constantly remains on top. Any other report, table, etc opens behind it. I've never had this happen with a switchboard before. Any ideas how to fix this? I've checked properties & such ... haven't had any luck.

2/17/2010 2:26:01 PM 1 =?Utf-8?B?U0NT?= <...@discussions.microsoft.com>
Access 97 won't save changes to form design view.

I make changes in design view but they will not save. If I close the program, it asks me if I want to save but clicking yes does nothing. The program will not close until I click no. This is a data base made in Access 95 that has been converted to 97 file extension. The database works fine as far as entering and finding data. Of course, the help files are of no use... Thanks in advance for any help. Bill

2/16/2010 7:03:02 PM 1 =?Utf-8?B?VG9wSGF0dGVy?= <TopHat...@discussions.microsoft.com>
pcnetsecurity@gmail.com =?UTF-8?B?QXNzaXN0w6puY2lhIFTDqWM=?= =?UTF-8?B?bmljYSAgbWFudXRlbsOnw6M=?= =?UTF-8?B?byBkZSBjb21wdXRhZG9y?= =?UTF-8?B?ZXMgaW5mb3JtYXRpY2Eg?= =?UTF-8?B?Vml0w7NyaWEtZXMgNTA3NTg=?=

Contato: pcnetsecurity@gmail.com Contato: pcnetsecurity @ gmail.com Planos a partir de R$ 250,00 . Assist�ncia T�cnica Prestamos assist�ncia t�cnica nos computadores de sua empresa ou resid�ncia, e tamb�m possu�mos uma equipe qualificada para fazer a manuten��o no pr�prio local. - Contratos de Suporte e Manuten��o Reduza os custos de sua empresa com solicita��es de visitas t�cnicas para seus computadores, elaboramos um contrato de manuten��o integrado para sua empresa onde disponibilizamos: t�cnicos, equipamentos de suporte e substitui��o, e atendimento no hor�rio comercial ou

2/16/2010 4:51:36 PM 0 Assitencia manutencao remocao de virus computador pc<manutencao.assiten...@computador.pc.com>
Access 2007 Table Issue

I have developed a investment input form with look-up lists to restrict the types of data to be entered. The look-up lists come from subtables in the database. When new records are saved the data is stored in a master table which I then use to run Reports, Pivot Charts, Queries etc. However, I'm finding that the master data table is in the same look-up list format as the subtables that are used to populate the form. In other words, the master data table has drop down choices for each record. I'm finding that when I try to run a report the investment information is lost.

2/16/2010 1:38:43 PM 3 "WSR" <wsr...@hughes.net>
Can we put two or three sets of data into one combobox?

In my database, I have Products table and Orders_Details table that contains Product_ID field and they have one to many relationship. On Orders_Details subform, I have a combobox Product_ID which is a bound control. From the pulldown list, I can have Product_ID, Product_Name and Price listed. After whichever product is selected, I want the combobox to display both Product_Name and Price but it can show only the Product_Name field. I’m also thinking of use another unbound field to display the price separately, but I have problem making it work. Can anyone make some suggestions

2/16/2010 7:21:29 AM 7 "guangdew via AccessMonster.com" <u58...@uwe>
Part and Product Database Help

I need help designing a database for parts and products. I'll give you a brief description of the scenario: There are thousands of parts, and hundreds of products. I want a database that has the following: -a list of the parts - with description, product number, color, length, etc. -a list of the products with the associated parts included in the product -If I change a description of a part, I want it to change in the products and all related aspects I know I need a part table, but I don't know how to incorporate the products - because the parts can be used

2/15/2010 6:25:01 PM 11 =?Utf-8?B?bWdsZzAx?= <mgl...@discussions.microsoft.com>
Unexpected Delete

I have a table with many existing records, and it uses an autonumber key. I recently added another table for additional information that only applies to some, not all, of the records in the first table. These tables have a one-to-one relationship, and the second table's primary key is supposed to match the first table's primary key. I add records to the second table by selecting from the first table via a combo box. My question is: What could cause Access to delete the record from the first table just because I delete the record in the second table? Directional: I have

2/15/2010 2:54:01 PM 6 =?Utf-8?B?b2xkYmxpbmRwZXc=?= <oldblind...@discussions.microsoft.com>
A REAL CHALLANGE

I need to (from within Access) 1. Open a document scanning software so that a document can be scanned; and then, after scanning, record the file name of the scanned document in a database without having to enter the file name by typing it. (The scanning software automatically enters a file name for the document in the "save as" dialogue box) As I see it the created file name needs to be copied to the clipboard when the document is saved; and then pasted to the correct field in the Access database. Anybody know if this can be done? -- Kepior Senso Fumor

2/15/2010 8:55:01 AM 2 =?Utf-8?B?QW5kcmV3REI=?= <Andre...@discussions.microsoft.com>
Duplicate Fields Problem in My Tables

I'm working on a DB for statistics for a small Hockey League. We've been using Excel, but it's getting more and more unwieldy. I've read elsewhere in this forum that Excel users usually have trouble switching to Access, and I'm here to tell you it is true! Oh, well, here's what I have so far. 1. A Members table for storing names, addresses, etc. 2. A Roster table for members who are actively playing in the current season, including team name, jersey number, etc. 3. A Stats table for saving the stats for each player for every game they play, goals, assists, team, game, etc.

2/14/2010 10:59:01 PM 16 =?Utf-8?B?RW5uZWFk?= <Enn...@discussions.microsoft.com>
Pen Mode in Access 2007

I've created database application to be used as EMR (Electronic Medical Records) in Access 2007 (OS- Win XP). The physicians will be using Tablet PC instead of Desktop to enter their visit notes on this EMR. The visit notes will be entered using a stylus pen on their PC tablet. What I'd like to do is create "Save" button to save that note outside access for editing. Can you tell me how I could do that? someone suggested I use OCR but I am not sure which one to use or how to do it? Our preference is to save that note as MS Word document since that would be the format of the final

2/14/2010 10:13:01 PM 6 =?Utf-8?B?Q2l0aXBvb2w=?= <Citip...@discussions.microsoft.com>
i want to know more about report

I want to know more about report to automate my database in msaccess. Presently my main problem is I don't know how to group in print output of invoice which I created. The reason is as I am aware I don't know what is group in msaccess report. Please comment.

2/13/2010 12:33:01 PM 1 =?Utf-8?B?S3V0dHk=?= <Ku...@discussions.microsoft.com>
No duplicates wanted in column except for default value...

Hi, Having a hard time trying to help myself with this one, so I am posting a question... I want to set a field in my table to have no duplicates allowed except for the Default Value I assign to it... I want to accept multiple entries of the default value, but only single entries for all else... Possible? Thanks in Advance...

2/13/2010 9:26:02 AM 1 =?Utf-8?B?Q29vbGJyZWV6ZQ==?= <Coolbre...@discussions.microsoft.com>
Extra relationship

In my database, I have a Suppliers table and a Product table. A main/sub form is made based on these two tables. Supplier_ID is the primary key in Suppliers table, Product table also contain this Supplier_ID field but not as primary key. My problem is that after I setup the relationship, MS Access produces another Supliers_1 table and setup a many to one relationship. I tried to delete it, but MS Access keeps on adding it. Any one has an idea about what's wrong? I tried to attach a screen shot of the relationship but don't know how to do it. I can email it to anyone if you ar

2/13/2010 8:07:26 AM 2 "guangdew via AccessMonster.com" <u58...@uwe>
Validating two fields

I am trying to create a database in which some of the fields should be mandatory only under certain conditions. For example: In my "Type of Injury" column, I want the user to be required to enter a value in this column, only if the value in the "Type of Document" column is "Nursing Report". Is this possible? I am only just beginning to teach myself Access, so please bear with me. Thank you.

2/13/2010 12:16:01 AM 3 =?Utf-8?B?Q29ycFRyYWluZXI1NzA=?= <CorpTrainer...@discussions.microsoft.com>
Web Database

I am looking to create a web database for my web site. My web host provides My SQL, can I use a Access database to store the data. Where can I find the steps to create a web database - my host provider isn't very helpful. They provide MySQL and Php MyAdmin. Where do I begin ? Thanks

2/12/2010 8:20:01 PM 8 =?Utf-8?B?R2Vvcmdl?= <Geo...@discussions.microsoft.com>
Radio buttons

Is it possible to ask a question in Acess and have the user click on a radio button for the correct answer beside one of four supplied answers (with radio buttons beside each answer) Thanks, Aidan.

2/12/2010 10:18:01 AM 1 =?Utf-8?B?QWlkYW4=?= <Ai...@discussions.microsoft.com>
Allowing both multiple values and list edits in Lookup field

In Access 2007 I am trying to make a table column utilize a combo box that allows both multiple values and list edits. However, when I set it to allow both features, it doesn't let me make any edits to the list in the table; the multiple values aspect works just fine. When I don't allow multiple values, I can edit it to my heart's content. Anyone know a way around this problem? I know that I'm doing it right (all you have to do is select "Yes"!) but it's jut not allowing me to have both allowances as it should.

2/12/2010 12:56:01 AM 3 =?Utf-8?B?SmVzcw==?= <J...@discussions.microsoft.com>
Design assistance requested

I apologize for the length of this post. I’m trying to give as much info the first time to help you understand what I need. I haven't done any design in some time so I feel weak on normalization. I am contemplating moving from Excel workbooks to an Access database for our equipment comparison data. I **think** it is worthwhile and need assistance/guidance with the best method for creating my tables. My questions are towards the end of this post. Our process to date … we have one regional standard (RS - consists of two sensors) and many travelling standards (TS – one sensor).

2/11/2010 10:18:01 PM 3 =?Utf-8?B?Q0I=?= <...@discussions.microsoft.com>
Filling in voids in the id number

My first column is the key and ID number for each record. One of my users (before I locked the table) voided several of the records, and now the record number and Id number no longer match. Is there a way to back fill the key-id number with dummy records so the rows line up. Thanks……

2/11/2010 8:33:01 PM 4 =?Utf-8?B?VEVT?= <...@discussions.microsoft.com>
Display Row Number in Datasheet View

Can someone tell me how I can display the row numbers in a datasheet view when a query is run? I have looked and looked and can not figure out where and how I can do that. I just want it to display like a spreadsheet would with the row and column numbers.

2/11/2010 8:07:02 PM 3 =?Utf-8?B?Z2FydmljODI=?= <garvi...@discussions.microsoft.com>
Website Integration

I need someone to point me in the right direction. I have an Access database that I created that is working perfectly. Now, I need to be able to integrate the database with a website, and require some direction and/or guidance. The database is simple: One table that contains contact information, one form to update the information, one query to search for a contact record, and two reports to display the data. What I need to do is this: I need a way for someone to be able to perform a search for a contact by using an HTML or XHTML web-page on our website. It would be an adidt

2/11/2010 5:17:01 PM 1 =?Utf-8?B?QnJpYW4gQmVja2Vycw==?= <bbeck...@nospam.com>
best way to archive records?

I am creating a membership database for a church. Individual information is in three basic tables: tblFamily FamLastName (for entire family) Address tblIndividual FirstName MiddleName LastName (takes care of hyphenated married names, or different names for children, etc.) BirthDate MarriageDate tblMembership JoinDate JoinManner TerminationDate TerminationManner and more... Once a person leaves the membership of the church I need to "archive" the information. It needs to be kept for our permanent records. What is the best way to do this? My two thoughts would

2/11/2010 3:59:29 PM 3 "Kathy R." <wild_r...@graffiti.net>
Table & Relationship Advice

Is it possible to post my tables and relationships for advice and to do so privately? I posted a couple questions on this DB and based on responses, I'm beginning to doubt my entire design. Unfortunately, this DB is of a sensitive nature and posting the entire information to be captured on an open forum is not an option. Thanks in advance.

2/11/2010 1:19:01 PM 5 =?Utf-8?B?TGVlIEFubg==?= <Lee...@discussions.microsoft.com>
Ten calendar harm one of the products

Ten calendar harm one of the products www.laptop-battery-inc.co.uk/spy-pen.htm

2/11/2010 9:18:29 AM 0 "Starain" <hxp...@vip.qq.com>
Relationship Layout

Access 2007 Where is the layout information for the Relationships window stored? Is it in an object and if so how do I reference it? Please note I am not talking about the relationships -- I know how to extract that. I would like to know how to extract the current layout in the Relationships window.

2/11/2010 5:41:16 AM 5 Stewart Berman <saber...@nospam.nospam>
Creating a membership database

I am trying to create a membership database for a church. I need to have all members entered into the database, then for the members I need to have their spouse name and anniversary, and the names of their children. I am trying to get a subform for each of these into the main form, but when I try to use it it just shows the spouse in the first spot as the spouse for every record. I need to lock or bind this information to each "Master" form. So that joe smith at 123 anyplace somewhere usa will show his spouse and children while joe smith at 456 somewhere anyplace usa will show h

2/11/2010 1:50:01 AM 5 =?Utf-8?B?SkQgU3RlaWdlcg==?= <JD Stei...@discussions.microsoft.com>
multiple back-ends

Hi, I have 3 or 4 databases developed separarely over the past couple of years covering different areas of company activities - project monitoring, support call monitoring, QHSE monitoring etc. The company has grown and I'm looking to consolidate and distribute these. I'd intended to split them into FE/BE so that the just the appropriate FEs could be installed on any user's PC and the back-ends would reside on the server. I'd thought at first that I could have a "core" BE with e.g. a staff and client table and activity specific BEs. But the activity tables have the core tabl

2/10/2010 6:50:01 PM 5 =?Utf-8?B?SXJlbmVfNTg=?= <Iren...@discussions.microsoft.com>

Pages: 2 3 4











Newest Articles

Different calendar sync counts on 2 clients
22 min. 51 sec. ago

help about outlook storage
23 min. 33 sec. ago

how to encrypt text in a diary entry when inviting a user?
23 min. 50 sec. ago

Time input in w/sheet #2
25 min. 50 sec. ago

I keep getting the error message 'not responding' with Outlook?
30 min. 47 sec. ago