Please help me to establish a relationship. I have one query that has different account numbers with different information, the account number is not the key...

Hi all , I'm a new access user and i nead to know how can i creat a high secure database for a college library . what kind of data i should putinto it and how...

Our insurance/financial advisor agency currently uses ACT 6.0 as our CRM to keep track of our customers, marketing to new customers, and reports for how many...

Hi, I have a large number of related PDF documents that are currently hyperlinked as a means of access and searching. I would like to develop a access...

Hi, I realize a bunch of people posting do not like lookup up columns, but i really have never had a problem with them...until today. We are creating tables...

I have a database where the front end and back end are both on a network server. I will eventually put the front end on each users desktop. Right now I am...

I need to have a column that only numbers 1-20, with a repeat numerical system of 1 - 20 for a database of 200. The project: breaking down 200 employees into...

Hi, In Access 2007 you are able to right-click on the "Click to add" column in Datasheet view of a table and hide it so that it's removed from view. Cannot...

I suggest you create a fix for file conversions; meaning that not all conversions are able to be read. I suggest a chart or table stating what each of the...

i want to convert the number into words for ex: if i store the value of a currency field as "425.65" and i need the result as "dollar four hundred twenty five...

FOR EX IF MY CURRENCY FIELD HAVE "245.90" IT HAS TO BE CONVERTED INTO WORDINGS AS "DOLLAR TWO HUNDRED FORTY FIVE AND NINTY CENTS" AND SAVING IN THE TEXT FIELD...

Access 2003: I am looking for a Template for a Truck Maintence database that will keep my mechanic up to date on all issues with the trucks and due dates...

I wonder if anyone can help me with this. I have a table which has a form attached to input data. I've just found out that I can't copy and paste this table...

I want to specify elapsed time format that one can find in MS Excel. Specifically, I want to use :ss. The Access format did not allow me. Is there an...

I've been working with a database and I recently added a Check Box that I want to be exclusive to each record. However, when I click the Check Box for ONE...

For a student database you need two addresses, term and home - generally both are the same so it is easier if the second is automatically copied from the first...

I have the following problem. In a database, I want to keep records as historic, before making any changes to them (historic in the same table). One of these...

When I go into print preview I always have to change the view from fit to 100%. I would like it if it would always show it at 100% rather than fit.

Hi My understanding about foreign keys is that they are generally a primary key in foreign table. The primary table primary key would be unique. In fact I...

Hi I have created a table and have created web pages pulling the information from the table however.....how do I create a link to pictures in the design of...