We have an Access 2000 database that we would like to convert to Access 2007 to take advantage of the new rich text data type, but we need user level...

If I would like to store a person's age as a column in a table, could I calculate the value of the column based off of the Birthdate field? I was trying to do...

Thank you for your time and patience. This board has been a wealth of information and knowledge. I hope you can help me with my latest Access challenge. ...

I have a table that I would like to occasionally add rows to. I need to add 28 rows at a time and three of the columns would all contain the same data. If...

I have tables and queries that reside on a sql server with an odbc connection to Access 2003. When I need to open one of those tables or queries, I log in. I...

I am still trying to design my database (keep getting given extra info which changes things). It is all to do with sites for housing developments. Each site...

how do I enter a value into field using a check box if the insurance check box is checked I want to enter $7.50 into the insurance field if the box is not...

I am a bit confused by my relationships and primary keys. My database contains customer details and each customer can have one or many maintenance...

I found this old thread for fundraising template. I don't know if you still have it or an updated version you are willing to share but I just started...

"Granite Janet" wrote: Is there a simple template which could be used as a fundraising database, either for Access or Excel. Somewhich would record basic...

Hello all, I am building a 'simple' invoicing db. I need to be able to create quotes/estimates as well as actual purchase invoices. Should they all be in...

Hello, My question is : How can I replace a primary key of type nvarchar width 65 by something smaller ou more rapid ? I'm using SQL server 2005 Express...

The form and subform are based off two seperate tables. The record source for the form is a query of the two tables using the query builder under the...

I understand the maximum data storage size for Access 2007 is 2GB. I have a database to store video clips, photographs and sound as you can imagine this will...

what's the trick to printing just the current record in a form? -- binny

I have created a school nursing database for 32 schools. I have a main menu and a form with a lookup box for student names. I have a form and a sub form....

When scrolling through a memo field, and then clicking on any other field, the memo field goes back to displaying the text at the very top of the memo field....

Scenario: If I type in a city, how do I have the Zip Code automatically entered in the appropriate field?

I am trying to create a database where students can select course seminars. I have one table containing all the information of the different seminars, and...

When an Access front end DB is stored on a shared network directory, is there a way to redirect the lock files so they are created and managed on the users...