| Thread | Last Post | Replies |
|
| Access Database and SP2 | 26 Jan 2005 20:02 GMT | 1 |
We have recently put Service Pack 2 on our computers. Now when we try to preview a report in one of our Access Databases (doesn't matter what version), it will just sit there. Doesn't give us an error or anything. There is
|
| Form/Table Question | 26 Jan 2005 19:53 GMT | 6 |
I have a form (frmCustomer) based on a table (tblCustomer). I will use the form to add new customers to my table and a separate form to modify existing records. How can I get my form to default to the next record to add rather than displaying the first record in the table when it ...
|
| Proper way to both display and save text data in consistent format | 26 Jan 2005 18:55 GMT | 3 |
As an Access neophyte (but a longtime dbms developer), I would like to experiment with improvements to my personal address list database (my one and only Access database), which couldn't possibly be more primitive. For starters, I'd like to know how to force field data (like ...
|
| CPR-nummer | 26 Jan 2005 18:54 GMT | 1 |
Hvilket format skal jeg angive for at registrere CPR-numre 111111-1111, og samtidigt sikre at et foranstillet nul (011111-1111) bevares?
|
| Best way to point to different linked tables? | 26 Jan 2005 18:00 GMT | 2 |
I have an application with a separate backend database. As one would predict, I would very much like the application to run against different databases with different names and locations. I'd appreciate suggestions about ways to accomplish this.
|
| Change Memo data type to Text data type | 26 Jan 2005 16:57 GMT | 1 |
A table within the data warehouse that I get my data from, contains a field I need to use in "memo" data type. I need to use some of the data from this table to make another local table. Performing the make-table query is no problem. But when I go to use
|
| How do I allow user input within Access? | 26 Jan 2005 15:31 GMT | 3 |
When a user clicks on a particular cell within Access (2003), I would like it to give them a choice of entering say, A, B, or C. How do I do that in Access? signed
|
| many to many relationships | 26 Jan 2005 14:01 GMT | 1 |
I have two tables, one called Country with one field, country ID (e.g. Philippines), the other called Province with several fields, but the primary key is ProvinceID (e.g FIS which stands for South Philippines). But a country can have two provinces, e.g. Philippines has FIS and ...
|
| SQL question: confused about dates | 26 Jan 2005 13:31 GMT | 3 |
I'm creating an Access db for a student project, but I've hit a snag. I have to use SQL insert statements. I have defined the 2nd and 3rd fields in a table as a DATE data type. Here is my statement:
|
| how do I show & | 26 Jan 2005 12:25 GMT | 2 |
How do I show the ampersand (&) in a label?
|
| Mixed up with Relationships..help! | 26 Jan 2005 04:05 GMT | 3 |
Ok, I have managed to get myself completely confused. I have a table, called tblstudent, which has a series of questions in it, as in data entry for a questionnaire. I have read some books about relationships and the trouble i have is that
|
| Linked tables | 26 Jan 2005 01:32 GMT | 1 |
I have a splited database, which has front-end and back- end. Front-end is stored table named COMMUNICATION.( The database is at H drive) I have another database which also has table named
|
| Append new records only | 25 Jan 2005 23:10 GMT | 7 |
Hi I have a table (TblPatients) that I wish to append new records to. The source is a linked (TXT) table called (PASImport) that I have already created. So far I have created an append query that successfully appends all records
|
| Trigger an automatic calculation when data is entered. | 25 Jan 2005 20:47 GMT | 4 |
I have a table with the following three fields: Begin_Date End_Date Duration I would like to automatically calculate duration when data for Begin_date and End_date are entered. Is there a way to do this?
|
| HOW DO I RESTORE MY DATA BASE TO THE "FORM VIEW"?AFTER I CLICKED". | 25 Jan 2005 20:45 GMT | 1 |
I WORKING ON A 16KB DATA FILE AND HAD THE"FORM VIEW" FILE OPEN. FROM THE TOOL BAR,I SELECTED "RECORDS" THEN AT THE BOTTOM OF THIS DROP DOWN BOX, I CLICKED "DATA ENTRY". I AM NOW UNABLE, TO DISPLAY IN THE DATA IN MY FILE. EXCEL WILL OPEN THE
|