Getting Started

Finding Duplicates in Table
Hey Got a situation where I need to provide a list of Software Descriptions (swSoftwareDesc) for each asset (swAsset) where there is more than 1 Version (swVersion) An e.g. would be Abode Reader V4 & Adobe Reader V5 found on Freds PC. Any suggestions. I'm a bit of a newbe at this so easy is good :) Pete ... 22 Feb 2007 04:08

Trying to create a similar database
I'm brand new to Access, and I only have Access 2000. I work for a large roofing company. We would like to track our bids to general contractors, municipal entities, etc. by using an Access database. One of our estimators brought with him, from his former job, a database utilized similarly at his old job. I... 27 Feb 2007 15:25

Linking Databases
Hey guys! In access, I have (1) Account List Database and (2) a Trade Details Database. On both Databases, they have two fields that are distinct. The account number and the plan sponsor field. Now....The trade details database has every single trade listed by account number and has a field for Plan Sponso... 21 Feb 2007 10:38

Find a record using a specific field on a form or table
I am very new to access, the only knowledge i have is that that i learned from the net. My question is how do i search for a record based on a specifice field on a form and then have the specifice record opened when i click a specified button? ... 20 Feb 2007 13:16

I need to create a database search form
I have created a database for the 130 properties that i manage in one table with general info, staff, emergency contact, and sales and leasing information. I want to create some sort of search box (not using the cntrl+F find feature) where my receptionists can quickly enter the name of the property a customer is c... 21 Feb 2007 23:03

Forgot some Basics
Got a real easy one. I have this huge table with over a million records of inventory. The table contains several fields like; Serial#, Model#, Condition Cd#, etc,. I want to create a form that will show all records based on Serial # (which the user would input) or based on Model # (again, user will input) also,... 20 Feb 2007 12:44

New user needs help displaying data on the net.
Hello, I know basic use of Access, but I need to be able to have other people access my data on the internet. I want them to be able to select the variables they want to see in a crosstab and/or graph chart. Can anyone point me in the direction of a tutorial or make suggestions about how to do it? Thanks ... 20 Feb 2007 11:10

Access Simpleton: making complex tables
Bit of an odd request here, but something we tried this year for our school data analysis worked well, but took a long time because it was done manually. I'm now trying to work out if we can do something electronically to make it easier. I want to start with a column set of data about pupils achievements in ... 20 Feb 2007 15:22

Conditional paragraphs in a report
How can I get conditional paragraphs in a report. Depending on the value of a field in a record, I need a paragraph to be selected and printed in the report. Thanks Mike ... 20 Feb 2007 02:07

stop new record from being created if previous record not clos
Thanks George, that did it. "George Nicholson" wrote: I'm guessing you simply have a timing issue. Looks like you used: http://support.microsoft.com/kb/210504/en-us Referring to a field in the Previous or Next record That will work on existing records (like a report), but I don't think it ... 19 Feb 2007 21:27