I apologize for the length of this post. I’m trying to give as much info the first time to help you understand what I need. I haven't done any design in...

How do i recover a database lost during compacting?

I created an Access database but i need to be able to have multiple peeps getting into it at the same time and adding tasks. How do I set it up that way. ...

Greetings, Are there any Access Templates that I can use to do some Stock analysis, scanning, and decision making for trading?

Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates...

I have a main table with about 5000 records of companies I may want to do business with. Now I've created another table showing the differences in the...

My first column is the key and ID number for each record. One of my users (before I locked the table) voided several of the records, and now the record...

I HAVE A DATABASE FOR 35 DISTRICTS. THERE ARE MASTERS WITH SPECIFIC NAMES WITH THE NAMES OF THE DISTRICTS AS PART OF THE NAME OF THE MASTERS. I WANT TO...

I have a multi page report which includes a field to calculate the *. I would like to have a sum shown at the bottom of each page and a grand total at the...

Hi there, I need to have a table to keep employees salaries, in which each employee may have many different salaries on different ranges of dates, with fields...

This is my first time working with Microsoft access; I am using the 2007 version. I need to make a validation rule that only allows me to input the number...

How can I get a list of the fields in an Access table into Word? I am working on a very misdesigned database where one table has over 100 fields and several...

when i try to create a MDE file i get the following error message. Can anyone help or point me to someone who can? Thanks This error is usually associated...

I have tried numerous ways of setting up this subform and each one has presented with shortcomings. Maybe someone has a suggestion of a better way of...

Im designing a database application that will be built using a SQL Server backend but I couldnt see a managed newsgroup for sql server table design so, as Im...

I am setting up a database of customers and I want to assign each customer a unique password. Can Access automatically generate this for me. I want...

I have been assigned a task to create a database and need some advice on the correct design. I am not new to Access, but nowhere near an advanced user. The...

I have a people table and company table. Each person and each company can have multiple telephone numbers. With respect to a telephone table(s), should I have...

Lynn Trapp asked me to post the actual SQL code so that it can be checked for error. The error is "Syntax error in FROM clause." SELECT Stock.Item,...

Hello, Is it possible, or a good practice, to have multiple Access databases, each with maybe one or two tables? I would be using Access 2000 and feel...