Tables
in [Access]
|
Relationship Question I have a field called tblPeople. It has an AutoNumber field as its PK, it has a field called ID which is a text field, indexed (no dupes). I have another table called tblEvents. In tblEvents I have amongst others, two fields, Manager and Director. I am trying to create relationships between tblEvents.Manager a... 3 Dec 2009 12:37
Brain Cramp Db design - stevie pimps again "Steve" <notmyemail(a)address.com> wrote in message news:uYFY6ascKHA.800(a)TK2MSFTNGP05.phx.gbl... I would like to offer to help you. I provide fee-based basic help with Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. ... 1 Dec 2009 16:10
Brain Cramp Db design I am building a new db from excel spreadsheets. One spreadsheet has gauge information: (each row/record is a different gauge) gauge serial number - calibration date - load range - location The second spreadsheet ahs gauge readings by date: (each row/record is a different date containg data from all gauges) date... 1 Dec 2009 21:48
New to the whole DB world I am a desktop support person and I have a vbscript to inventory all the computers on the network. I use the script to gather information like username, memory, hard drive space, and I am thinking about getting installed software. I have the script writing to an excel file, which is ok for now. I would like to ... 3 Dec 2009 22:44
Have I reached MS Access Limitations? I have been working with MS Access for about five years. I have been able to grow my solutions from a simple mdb with a couple of hundred records to adp with sql backend with a couple of hundred thousand records. I always had a controlled audience and all my users have MS office but I am seeing myself coming to a c... 1 Dec 2009 21:48
multivalued lookup columns The "Do you want to store multiple values for this lookup?" option does not come up when I try to create a lookup column. Any ideas? Thanks. ... 29 Nov 2009 15:43
new db with 25 items w/ different types of amounts I have a database I'm trying to setup, it shouldn't be that difficult, but I'm having a problem figuring out the best way to set it up. The fields are Item, ItemType, Amount, and Year. For me the problem is the Amount field. The Amount values differ, they include types of number, percent, hours, and currency.... 26 Nov 2009 23:04
Collecting form data offline I've created a simple CRM database suing Access 2007 on our companies share drive. We have a small office with only 5 people using the database. Is it possible to collect from data off line while visiting a client and sync to the database when I'm back in the office? ... 26 Nov 2009 14:16
Setting up Observation Database I am trying to create something of a survey database. I have seen the sample database "At Your Survey", but I am not sure how to tweak it to what I need. I have a form that is for safety observations. Supervisors will observe procedures and mark them as "safe" or "at-risk". I have a list of things they can obs... 5 Dec 2009 17:23
How big a record size is too big from a performance standpoint Jeff, The database has been normalized to 3rd normal form. There is just a lot of data. I was more concerned about the size of the record being too big for decent performance on Access. According to specs, No of chars in record (excluding Memo and OLE) with Unicode Compression property set to Yes is 4,00... 30 Nov 2009 12:30 |