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...

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...

Hi, I'm designing a new table to replace an existing table that is populated with data for the current application. The old table uses an AutoNumber...

I am trying to populate a text box on a bound subdatasheet with the most appropriate value for the user to see.. Based on wether the component has a value...

Sorry for the previous post - it had two post mixed up... I have a database on Projects. I have PROJECTS that can have many participants, and PERSONS that...

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...

Help! Driving myself crazy trying to write an expression that will give me the value of a date from a table field + seven days. I have rewitten this a...

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...

In our Data Base - automatically between the City and the Province there is a comma - in bulk mailing the Post Office wants us to NOT have the comma - is...

First, the overall objective. A few others and I work in a dispatch office in a homeless shelter. (I will just be upfront about it.) We are responsible...

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...

I am looking to create a web database for my web site. My web host provides My SQL, can I use a Access database to store the data. Where can I find the steps...

Is there any way to put this into plain english I am much better at visual instruction, I to am trying to build a training data base that can generate reports...

I am using Access 2007. I have a table ACCOUNTS, with fields for account number, account description, and account balance. There are 12 other fields for...

I need help with design of a database I am writing to keep track of procedures that I do on patients. For each patient, one or more procedures can be done....

Sometimes when I close Access 2007 and re-open a strange field has been added and my previous field information is gone and replaced with numbers. When I go...

Why round(1.125,2) gives 1.12 on Access Functions and 1.13 on Xls functions?

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...

I designed a small database system and implemented in access 2002 as a 2000 database. after the design i removed the made a few changes on the startup dialog...

Anyone Seting up db to record race times and results for local swim club. How do I format the time cell? Need it to have minutes, seconds, tenths and...