I have a field with currency format. I would like all numbers entered in this field to have a negative value. any tips thanks!

I have created a database with 5 tables and three forms. My relationships are made as well as my primary keys. When I enter data though, the data does not...

I have a memo field that the user can insert markers that will be replaced with data in a query process. Example: Dear {1} where the {1} will be replaced with...

Is there a keyboard shortcut you can use to copy or duplicate all the fields from the last record into the current record? I know you can use Ctrl + ' to...

I was trying to come up with a setup for a Petty Cash table. The things it must do the following: Date Money spent Where it was spent What is was spent...

how do i setup up my access internet page to show a blank form when it is opened

The box for details in design view is transparent so is the properties box in design view in quiereies how do I change?

Hi: I'm setting up a table in an ACCESS 2003 ADP project. I don't want to assign a primary key because the data I'll be importing contains duplicate values in...

I have an Access Project which has several combo box fields that have a lookup table. In SQL server, I have a Data Transformation (DTS) routine to convert...

How can you have an Access application dial a TAPI phone interface instead of a modem?

I have a table where I want a field to have values from a lookup table - but I would like to limit the list based on the record I am filling in... E.g. select...

I have set up one to many relationship between an order table (master/one) and a order details table (slave/many) using the related field orderID . This...

I made an access database where there is one main form and two subforms. In two subforms, 2 different methods are used to get 2 fields of data (common for both...

Hello, I am desiging a database that will host information about employees. The problem is that there are about 5 different types of employees (hourly...

Hi, I am new to the world of databases, relational, flat, and any others. I have been at my part-time job for a year now, thrown into the world of an existing...

I have a number field. I want to enter data into as a percentage of commission (2.25). I have tried every number combination and when I enter 2.25 it enters...

We have an HR dbase with salary info. Is it possible to allow access to the dbase without seeing the salary field? I don't think there's a way to password...

Is it possible to have a field recieve calculated values from two other fields? I tried it with a form (which does the math) but it doesn't actually add...

I am designing my own patient record database. I have a form for entering patient data. The table from this form has a one to many relationship to a table...

Hello, I have started the design for a new project where financial advisors can store the customer info. The problem is , there have to be stored about 100...