I've searched through these forums and read alot of discussions regarding not using a lookup in a table. Instead, one should put that information in another...

Hello, I see that the BE database keep bigger in size. My question is if we setup the option to be " Compact on Close" on each Front End of the users, does...

I have 2 tables, one containing information about the staff of an office (names, address, tel, etc.), and the other one containing their salary history...

I'm using Chinese windows 2000 with sp4, and English office 2000 with sp1. I design a table with creating 1 text field and 1 date field, and have "phone"...

I am designing an Access database that will eventually be moved to a SQL server and be web-enabled. I would like to be able to track login times for users who...

I need to revise the structure of a data base application that I have developed, so that the application can be "validated". One part is that I need a way to...

Just starting out in access. I am trying to create a database for work that shows: 1. Events (upcoming and past) 2. Attendees I also do travel arrangements...

I would like some experts-advice ... I have: Developed a database in lotus-approach (97), wich is alive and kicking. Unfortunaly, this application runs only...

I inherited a 10,000 record EXCEL worksheet that I will convert to an ACCESS table. The EXCEL worksheet contains about 10,000 lines (each line is one record)...

I have split my database. I have four users that will be using the front end. I've read that each user should have the front end on their local systems. What...

HI I apology since this may not be the best group to ask this question: I have excel spreadsheets that I am trying import into tables to be able to utilize...

I am using Access 2007. When I add a button it does not appear on the switchboard. I did delete one button, but it was not working either. How do I create a...

I know how to make a column prevent duplicate values with an index; however, I have a column where many values are null which is OK, but I can't use an index...

I am working on a form for data entry where the user enters many records that may have similar information, i am trying to create a tab that would have all...

Dear All, Please teach me, how to make a new row/list in other table by entering number in other table. Sample, In the table A and in the field "Details", I...

Work with IT for many years, and have lately begun looking into DB and MS Access. So Im quite a rookie in this area. :) Ok, Got a superclass named table1....

I have imported ASCII data into an Access table. All of the fields show a 255 size. None of the data being imported is larger than 50 in field size. For...

Hello, I have been importing .csv files into Access using a Macro which works great. Unfortunately, the task has become more intense. I now have 20-50 csv...

Hi, I am wondering about proper or accepted practise for ID'ing records in a relational database. My question is this... If I have a table with a unique...

Hello, I tried to quickly scan most of the posts out here but found bits and pieces of what I needed to ask. I'm curious if anyone knows about some kind of...