| Thread | Last Post | Replies |
|
| Convention Attendees Design | 30 Jun 2008 21:36 GMT | 2 |
I am needing some suggestions in creating a database to track attendees for two conventions. I need to track the attendees, conact info, lodging arrangements, which convention they are attending, and which branch they are affiliated with. Also, I need to provide the ...
|
| Working with many-to-many relationships in Access 2007 | 30 Jun 2008 20:34 GMT | 8 |
Hi, I'm new to Access but have been studiously using the help, tutorials, and forums. I seem to have the tables laid out but am now stuck at getting the relationships worked out. Basically, I have 3 tables: 1-Contacts (people), 2-Programs , and 3- Organizations. Each contact ...
|
| How to add a column to an existing table via code? | 30 Jun 2008 19:16 GMT | 3 |
I have an existing table in a .mdb database and I want to add a text column that is not required. I can add the text column but when I tried to set it to allow nulls I get the error "Multiple-step OLE DB operations generated errors.", error messasge. My code is shown below.
|
| decimal points | 30 Jun 2008 11:56 GMT | 2 |
My problem is that i have to fields in my databse that will hold values like .240. needs to hold all three decimal places including 0. I can not get the field to show the value when it prints. In the datasheet it holds the correct vuale but the form displays only .24.
|
| reservationsystem for tickets | 28 Jun 2008 18:37 GMT | 5 |
I have a circus and need a database to reservation of tickets, can anyone help me to get such a system.
|
| help with Table structure | 28 Jun 2008 07:45 GMT | 1 |
My office has a staff database consists of 3 tables. tblEmployee, tblEducationAllowance, tblMedicalAllowance. tblEmployee has EmpID, Empname, EmpPosition, DOB, DateofService... Now my office needs to incorporate employee dependents into the database.
|
| setting up the network path for workstations | 28 Jun 2008 05:48 GMT | 2 |
In the article "Splitting a access database, or how to run ms-access in a multiuser mode" Albert D. Kallal states that you should not use drive letters and mapping to link the front end of an application, on workstations, to the backend on the server. Instead, use UNC as the path ...
|
| Save time for visit | 27 Jun 2008 19:40 GMT | 2 |
I work on database for a dental.I have two fields that save next time for visit , [Start] & [End].I want that start value is not Between [Start]&[end] on the next record in one day. Please Help Me.
|
| Find out what fields have been changed | 27 Jun 2008 19:13 GMT | 2 |
I added some code to the after insert and after update events in a few forms to my Access 2003 db. These use the INSERT INTO stmt and inserts records into a table that record who added a record and when as well as who edited a record and when. I simply created an append query, ...
|
| Can see Items in a combo box on one computer | 27 Jun 2008 13:25 GMT | 4 |
Sorry this is a repost of my last post I have a database that will show items in a combo box (from a table) on my computer but when I go to the schools computer the combo box does not show and items that are in its table. Something is set diff. on the school
|
| How to filter a form from an item selected in a combo box. | 27 Jun 2008 06:46 GMT | 1 |
On my form 'frmReportGenerator' there is a combo box 'cmbGetProjectID' that looks up the field 'Project ID' from the table 'tblProjects' and a command button 'cmdPreviewReportMarkers' that opens up 'rpt_Markers'. The report, based on the query 'qryReportMarkers' brings up all ...
|
| network setup | 27 Jun 2008 04:29 GMT | 2 |
I have DB1, a database that has my tables. DB2, a database that has my forms and queries. The tables for DB2 are linked to DB1. Computer1 is the server. DB1 resides on computer1.
|
| Exporting Reports through E-mail | 27 Jun 2008 01:09 GMT | 1 |
I am exporting a report to be sent out attached to an e-mail. Currently the format is HTML. I need to know what other formats I can export and what their codes are.
|
| Can you start an autonumber data type at say 1000 | 26 Jun 2008 21:14 GMT | 2 |
Sorry I will repost this post also (just new to the group) Can you start an autonumber data type at say 1000 and let it count up 1001,1002 ect
|
| Linking tables | 26 Jun 2008 21:10 GMT | 2 |
Which datatype is best to use for the fields used in linking tables? I know Long integer is a good one. Will a text type of 10 characters work okay? Thanks.
|