|
|
Table Design View by
Heather
Hi, I am trying to create a table that I importing Excel data into and the
first couple of columns I need to come thru a certain way
Booking Qtr should look...
|
|
8 |
202 |
|
|
Auto Increment for non integer ? by
saleemMSMS
hi i have a table called invoice. the primary key supposed to be not only a
number, but also a string. i thought of making the primary key as follows....
|
August 12th, 2009 01:39 PM
by Klatuu
|
2 |
215 |
|
|
35 fields by
Heather
Hi, is there a maximum # of fields that we are allowed to import into an
Access table -- I have 35 fields from an excel table that Access is saying
that I...
|
|
5 |
210 |
|
|
Locking form by
MMacPherson
I need help! The company I work for has designed a database with a form that
you fill out and submit. The form is open to all employees, but for each...
|
August 11th, 2009 05:25 PM
by Klatuu
|
3 |
157 |
|
|
|
|
4 |
185 |
|
|
Setting up a db by
H
Hi - I need to setup some kind of a database that we update monthly but use
the data in Excel and want to find the most effecient way to do this.
The data...
|
August 10th, 2009 05:36 PM
by H
|
2 |
174 |
|
|
Database Reports - display and access by
Bob Waggoner[_2_]
We have used hyperlinks up until the switch from Access 97 to Access 2003 to
access our documents/reports from inside the database. Access 2003 doesn't
seem...
|
|
4 |
157 |
|
|
Access Developer Extensions and Office 12 by
sweeneysmsm
I have an Access database that was designed in Access 2003. I also have the
Access Developer Extensions (2003 – 11.0.5622).
I just recently installed...
|
|
2 |
279 |
|
|
calculate tax by
Sean
I have a database with a table in it.
There are three columns
They are Gross, Net & Vat
How can I get it to calculate the Net and Vat values by entering the...
|
|
3 |
142 |
|
|
Question about exclusive fields by
John Harrington
Suppose I have a table where I want two fields to be exclusive, such
that when one field has a specified value the other in the same record
cannot take a value...
|
|
4 |
150 |
|
|
Form Design Questions by
Damian
It it possible to do something like this:
Consider these 4 tables from this screen shot.
TblCrew
TblJobs
TblCrewType
and a link table between them...
|
August 7th, 2009 07:09 PM
by CraigH
|
1 |
285 |
|
|
Lookup Column to Report by
loki[_2_]
I've searched to see if anyone else has this problem but it doen't
seem so.
So the database keeps track of photos sent to be archived. There is a
lookup...
|
|
6 |
169 |
|
|
|
|
6 |
312 |
|
|
calculating total minutes for each employee by
access_learner via AccessMonster.com
I have 3 columns of data.
First column has Employee #
2nd column has Code_Name
3rd column has number of minutes
The information repeats for each employee...
|
|
2 |
170 |
|
|
Help with validation by
Daniel Haley
I was wondering if someone could please help me with validation rules
for a table. I am running Access 2003.
I have a table called tblSite, which has the...
|
|
3 |
189 |
|
|
Same invoice number- different country by
acss
I have an invoice table with primary key of 5 digit text that is unique and i
have a (customer id foreign key in invoice table)customer table that primary
is...
|
|
3 |
184 |
|
|
Syntax error when using DoCmd.OpenForm by
lmcc007
I have a command button that when clicked it will open a form called Check
Addresses. Below is the code:
Private Sub cmdEditAddress_Click()
...
|
August 6th, 2009 05:49 AM
by lmcc007
|
2 |
164 |
|
|
|
|
4 |
563 |
|
|
Creating a Form by
Damian
Can't figure out how to do something.
I have two tables:
TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType
TblCrewType
( 1 2)
|
|
16 |
510 |
|
|
Overtime DB Help Needed by
Bill
I'm trying to design a DB that will keep track of overtime hours and date. I
have a table of employees, table of equipment they work on and table of date
and...
( 1 2)
|
|
15 |
346 |