I would like to create two cells (in ACCESS) from one EXCEL cell . For example, I inherited a 10,000 record EXCEL worksheet that I will convert to an ACCESS...

Is there a way to prevent a user from choosing (or even seeing) a value in a table in a form? For instance: I have 7 software version entries in a table that...

Hi Is it possible in a table to filter data by setting two columns. My table contains two columns containing data as shown: Site Name Block Name site1 ...

how do I change the display in contacts in addresses, eg show business numbers and cellular phone numbers

What are the advantages of using a Primary Key exactly AND/OR Relationships? I'm trying to keep a table updated (with duplicates) as the info is entered via a...

Just thought I'd repost this and see if anyone can give me some advice.... I have one table Compl_Main_Tbl with unique Inspec_ID. We have a number of "sites"...

When I define custom colors through a form's property sheet (by assigning values to Red/Green/Blue and choosing "Add To Custom Colors"), the custom colors are...

how do I get names from a table to appear on another table. I need to have names from an employee roster to appear, and be updated on a table with additional...

I have an existing table, that I can't alter. I need the names, and some other information from that table in a new table which tracks other information. I...

I'd like to increase a field size to allow input of 16 characters versus the current 11, but I have a message that says I can't do it because of linked tables....

Dear all, Could anybody tell me that how I can allow user to edit BUT NOT delete the records in a view? I know there are only 3 options when opening a...

How to insert power point presentation that automatically start in a form by using activeX control or any methods and run smoothly? Thanks.

I have 3 table that are linked in this order: Loan info (main), Collateral - linked to Loan Info (1 to many, loan info is the 1 and this is the many) Real...

How can i make a datefield only show Date and Month, like a birthsdate ie. 12-02.

My obvious newbie-ness and total lack of understanding will probably make the MVPs in here want to gag. Disclaimer: My apologies for any upchuck action I may...

I am building a data base of equipment across several manufacturing facilities. There are several pieces of equipment in each facility. I have a table that...

I need to bring a lot of financial data from several different tables where they all have the same job number. I really have no idea where to start. Join query...

I am trying to return all the records from two different tables with an intermediate "join" connector line on a common field to both tables. I realize some...

I was told in the General Forum that there is no auto-save function in Access that will allow setting time increments, but instead, there exists a...

I need help with creating a database. I have taught myself the rudimentary basics of Access through trial and error over the last 4 years. However, I am...