| Thread | Last Post | Replies |
|
| Count tables and adding records | 30 Sep 2008 23:20 GMT | 3 |
Ok, I have created a count-table to create records for journals that are received where I work (Approx 42 different journals each month). The aim of the database it to keep a record of when journals are due and what date they
|
| Creating Expression for Sum of two fields | 30 Sep 2008 19:22 GMT | 8 |
I am new userof access and I am creating a for where I have two fields. Ex. Score A (Combobox - 0, 1 or 2) Score B (Combobox - 0, 1 or 2) Total Score (Text Box) - (I want to create expression here so total score
|
| Auto Numbering | 29 Sep 2008 22:57 GMT | 6 |
I have almost completed my database, but I am having problems with the auto numbering. It's a project database which is assigned a unique project number each time a new project is added. On testing the database I added in some test records which I subsequently deleted, I now want ...
|
| "The value you entered isn't valid for this field" error | 29 Sep 2008 21:08 GMT | 1 |
I created a form using the wizard. One of the field is a combo box that has values from another table. I've gone through the properties for both tables several times yet I still get this error message: "The value you entered isn't valid for this field. For example you may have
|
| Formula for pulling information | 29 Sep 2008 20:49 GMT | 3 |
I need help on pulling information from a spacific day back. For example, I need information from 9/1/08 back.
|
| relationship between 2 databases | 29 Sep 2008 12:08 GMT | 3 |
I have one front end application which links to 2 different backend databases. I wanted to create a relationship between 2 tables which belongs different databases.
|
| Populating a field Automatically | 29 Sep 2008 12:01 GMT | 2 |
Hello, I am in the process of setting up a project database in access and need some help. I have set up 2 tables linked through the site id. One table holds the project info and the other lists the site id and site name. (1 to many)
|
| All tools not visible | 29 Sep 2008 07:39 GMT | 1 |
When I open my database (.mdb) in design mode. Many tools are invisible or disabled. When I click on the Office button, up in left corner, I only see "Close database" and "Close access". Thanks in behalf for any help.
|
| Does Compact on close wprk for the Back End? | 29 Sep 2008 05:08 GMT | 8 |
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 it work to compact the backend?. How can it be while the other users is closing, while the others are still using, how will it ...
|
| Trackinng Volunteer Hours | 29 Sep 2008 02:01 GMT | 11 |
I am the Treasurer for a Habitat for Humanity affiliate. I am trying to create a database to track the hours worked by our volunteers. I have already creaed the Volunteers table, but am unsure of next step. Can anyone help?
|
| Can Access do this? | 28 Sep 2008 04:22 GMT | 3 |
We have sales opportunities in which we are “teamed” with other companies for the same project. The goal is to know how many projects we “win” but also which “team” we tend to “win” with the most or some analysis of that sort. Another consideration is that we may have several ...
|
| Elapsed time field | 28 Sep 2008 03:54 GMT | 1 |
I am trying to create a Training Log database for running and do not know how to format the runnin gtimes. I want a field that can store elapsed time in minutes:second, but do not know the format to use in the Table
|
| Unique index not recognizing null | 26 Sep 2008 20:28 GMT | 17 |
I am probably missing something, and it's easier to explain by example. In Acess 2003: 1. Create a table with three fields (I've named it Table1): Field: ID Autonumber, Primary Key
|
| How to set the default field on a form | 26 Sep 2008 19:33 GMT | 1 |
I am creating a data entry form. I would like to have the cursor automatically appear in the first field on the form when the "New Record" button is clicked. How do a set a field as the default or tell the form/database where to put the cursor when a new record is being ...
|
| Locking certain records in a table | 26 Sep 2008 19:25 GMT | 4 |
Is there a way to lock certain records within a table? For example, if I wanted to lock records entered prior to September 19, 2008, is there a way to do that? Also, is there a way to force users out of a database? If I need to make design changes and someone is idly in the ...
|