Tables

Hey Roberta, your little boy is playing in the middle of the road
The con artist is at it again. I see you are avoiding words like good, functional or useful when referrring to your work. These newsgroups are provided by Microsoft for FREE peer to peer support, not for gas station attendants who pretend to be computer experts trying to sell snake oil. John... "Mark" <n... 28 Jun 2008 12:42

Pictures in Access database records
How do I show different pictures in individual Access database records (forms view)? ... 5 Jul 2008 02:21

reservationsystem for tickets
I have a circus and need a database to reservation of tickets, can anyone help me to get such a system. ... 28 Jun 2008 13:43

help with Table structure
Hi, 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. Each dependent will have medical allowance as well. ... 28 Jun 2008 03:31

setting up the network path for workstations
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 name. My question is, if I put... 28 Jun 2008 01:29

Database Design/Combo Boxes and Relationships
I'm setting up a database and I'm trying to follow the rules for normalizing it. I have a master table that has about 7 fields that all store the foreign key from lookup tables. I had set up a relationship on each field to the lookup tables as well. Create the forms with appropirate combo boxes. Where I run i... 10 Jul 2008 11:20

decimal points
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. ... 30 Jun 2008 07:35

Revenue Tracking DB - Need to figure out the table structure.
Here's the scenario... I manage the billing for a single client. This client is billed in a number of countries worldwide (30 Countries in total). Billing is done in multiple currencies (depending on the Country where we bill). This is the information that I have: Invoicing Data: Country Invoice Number In... 1 Jul 2008 12:20

Find out what fields have been changed
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, tested it, then copied the SQL t... 27 Jun 2008 15:14

How to filter a form from an item selected in a combo box.
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 records with all Project IDs. I ... 27 Jun 2008 01:55