I have a database of people's details on one table. I have other tables of information about those people eg Agency visited, assessments completed, training...

I have been trying without success to do the following in 2007: Count cells in a named range (Col."H" abt 300 out of 1000 lines containing data) that are =...

I am creating s form to view data and one to update the data - Is it possible to create 2 subforms using the same table and how do I link them? I need one...

How can I enter a non-breaking space between the two parts of a post code so the postcode doesn't split when merging info to another document

After three days I'm starting to beat my head against the desk....Here Goes! I have three tables 2 of which are linked to a third in a many-many...

I've inherited a database for tracking chemical standard inventory and want to expand it. Right now, we log all our pure standards (PS) into it. Each PS...

I have been banging around blindly in some Access 2003 VBA trying to figure something out. To say I am in over my head would be an understatement. Anyway, I...

I would like assistance with adding to table without having to type every record. I have data that's exactly the same in Excel and would like to import them...

Hi, sorry for the basic question, I’m really green at Access... I have 2 identical tables with identical headings with headings have no real...

I'm trying to create a contact database. This seems so basic, so thanks for your patience. I'm using a template for contacts which seemed to be working...

Hi again, I'm battled with creating a search form. What I'm trying to do is create a form with a drop down menu and two text boxes that can be used for...

I am new to Access, using Access 2002 set on 2000 version. I looked through the archives but could not find this: I have a form with various data fields and...

Hi, I have a table that contains a field called amount. I entre an amount paid by a client and the clients name within the table. I wish to count the...

I need help with office 2007

Could anyone tell me the basic difference between Linking and Splitting and which is the preffered option? Many thanks for any help

I have a table that lists all customers and when service was performed on their equipment. I built a Totals query that identifies all service performed in...

Is the Access 2000 membership template compatible and or works with Access 2007? I have Access 2007 and the following message appears upon download, "The...

I am using Access 2007 on Vista. I added an unbound object frame to my form. When the box pops up I then selected create new also Microsoft Office Excel...

I am new to Access. Using Office Access 2003. table1 = contractors information (name, address, etc.) table2 = order info with autonumber field (part 1, part...

I have a sub procedure in a report. I want to add to it, but it is now at 64K. Help says to break it into 2 or more smaller procedures. How do I do that?