| Thread | Last Post | Replies |
|
| Six one to one related tables: question | 28 May 2005 09:50 GMT | 5 |
My project has six table that are related "one to one" What is the proper way to combine them so I can use them for my form. Currently If I try to combine them in a query I get the "ambigous outer joins" error message
|
| Access does not recognize =DATE() | 28 May 2005 04:02 GMT | 1 |
Everything was working fine, and all of the sudden Access stopped recognizing the DATE() function. All of my previously working formulas stopped working. I repaired the database, and later I reinstalled the program. But NOTHING.
|
| Custom Formats | 28 May 2005 02:50 GMT | 2 |
Can anyone help me create a custom format for address fields - I would like to be able to enter the address and it automatically change to Sentence Case - easy for one word but can't seem to find the answer if there are two or three words - such as Apple Tree Road
|
| Tables no longer link | 28 May 2005 02:21 GMT | 1 |
We have 3 computers on a LAN, one a Sales Call Recording Access database (Phone is tied to computer with a modem interface) and two manager units that are linked and share the files for salesperson performance review. After a salesperson completes a sales call and clicks on ...
|
| Cemetery Table Question | 28 May 2005 02:06 GMT | 5 |
I still working on my funeral home program!?! The first table (Vitals) is used on every case...the next table (Cemetery) is used approx 50% of the time...they are ralated one to one.
|
| Tables Relationsship | 27 May 2005 22:14 GMT | 10 |
I have two table; TableA and Table B. Both have a key field named Item. When I add a record in TableA, I would like it to add to TableB automatically. How do I do it?
|
| how can I create an Input interface in Access ? | 27 May 2005 21:56 GMT | 3 |
I need that someone can type Input information and saved in a Access data base. How can I create a friendly interface in access? that alow me to input data like name telephone reason to call.. etc etc
|
| Two table database input problems | 27 May 2005 18:30 GMT | 3 |
I am creating a db to copy the information from a job application form. There are two tables in this db. The first table contains a unique identifier that is an auto generated number and will be assigned to the job application. The second table has as its primary key the persons ...
|
| Access Pivot Table INTERACTIVE Help!!! | 27 May 2005 16:26 GMT | 10 |
> There doesn't seem to be much information around about Access Pivot Tables, > and I don't do much in Excel. I'm specifically looking for how to do this > interactively, using the Access Pivot table interface, so the users can > develop their own reports. I've developed routines ... |
| Database DEsign Nightmare | 27 May 2005 15:01 GMT | 4 |
Ok, I'm trying to design a database for work and need to know if (A) it is possible and (B) how to do it. Heres the general idea. -Employees login to the database from various places around the country
|
| SMS TO MOBILE PHONE | 27 May 2005 13:02 GMT | 2 |
Can I send a SMS for my computer via access to anopther mobile phone?
|
| Duplicating a Database Design | 27 May 2005 12:20 GMT | 3 |
How can I duplicate the design of an existing database for a second similar database -- and still be able to start all over with record #1 instead of starting the record numbers with the next number from the original database? The database design I want to copy is an elaborate ...
|
| Limit Auto Number | 26 May 2005 19:42 GMT | 5 |
Is there a way to limit an Auto Number field to 3 places (999) and then start over at (001). The field size that I am exporting to is only 3 places. Or can I format to only 3 places.
|
| how to add text for each single record | 26 May 2005 19:28 GMT | 2 |
when creating a free form text description box...the data typed bleeds in to the next added record....how does text remain in a single record....i have the text box created and can create text for the record but this info repeats in each record text box...it needs to stay with ...
|
| Importing records into a table | 26 May 2005 19:13 GMT | 2 |
Can you give some advice on the following. I've got a database that is used by folk across an office network. Some folk key records to the database and others use the keyed information to send faxes to clients. I've been asked about importing some further
|