I am having problems linking tables in a hosted SQL 2005 database on GearHost.com. I have Vista with Access 2007. I am linking via ODBC DSN. The DSN test is...

Hi All, I have two related tables that are updated via a form. I need an item of data in the second to be mandatory i.e.. Default Value only populates...

I want one of my forms that I'm going to be using as a switchboard to be the item that one sees upon opening the database in Access. We have another...

I have a database in which I want to autonumber a Field based on the number of occurances. Say I have a database that holds calls for a client. (Table...

My combo box shows fiscal month choices and autofills another field with the date the fiscal month ends. This works. But, when I make my choice, save, and...

Hi I have an access 2000 database with some linked SQL server 2000 tables. Everytime i open the database it always asks for the SQL user and password. This...

I am having such a frustrating problem and would appreciate any advice. I have a split database and have approximately 15 front ends. All of a sudden, i am...

I've been tasked to revise an existing slide show that uses Access and Powerpoint. This show is displayed weekly to a large audience and covers many...

Hi, Can we set few properties (as we have NLS in Oracle) at database level in ACCESS 2003? Most important is setting a date format for the whole database...

(My session seems to have timed out, so I am reposting. I apologize if this is a duplicate.) I have a database I used all last year. One of the primary...

I have created a database that stores information and then on a click of a button, based on the users selections from a main page (form) queries the data...

I am setting up a database to track and report the finish/specification schedule for projects that will allow the info to be sorted in a couple of different...

I am trying to design a db (Access 2003 SP2) and do not know the best approach to take. I have a paper form for which the Access db will be based. I will...

I downloaded the Orders Management Database Template from the Microsoft Website. When I entered in the price, it didn't add up the total cost of the item price...

I've linked an Excel table, but cannot create a lookupfrom another table. I keep getting the message, "you entered an expression that has an invalid...

Thanks for the help in my past posts. Here I go again. This is what I need to do. I need to look at a certain cell in the first record of a set I queried...

I set a field in a table to lookup values in another. I set the lookup table, the display widths, number of columns to show, etc. I tested the lookup by...

I have a field on a form that is "Date." I have the Date field set to =Now(). There is another field that is a check box called "Adverse Event." Currently...

Barely an Access user, hacking away at creating a database. I confused myself, and am hoping someone can help un-confuse me. ;-) Let me try to explain: I...

I am looking for input on modifying a design to improve performance. Version 2003 - All property split and linked. Mde on all front ends. Using DAO. Each...