|
|
Can a field name start with a number? by
Don Wiss
I have a table. My column field names are like 50xs50, 100xs100, etc. By
when I issue a sql query like:
Select Year,'100xs100' from RLLagMatrix;
It give me...
( 1 2)
|
|
12 |
297 |
|
|
Upload New Data Structure by
Erica
Is there a way I can upload a new access database structure without
overwriting all of the data inside the current database?
|
|
3 |
152 |
|
|
|
|
0 |
225 |
|
|
|
February 1st, 2005 04:46 PM
by BB
|
3 |
163 |
|
|
|
February 1st, 2005 04:27 PM
by Rick B
|
1 |
135 |
|
|
Suppress Warning Message - DAO Insert by
dave h
Hi,
When using -
DoCmd.RunSQL mySQL with an INSERT INTO............
How can I surpress the dialog box that asks to confirm the append?
Thanks, Dave...
|
|
5 |
175 |
|
|
Not understanding M:M relationship by
MCB
I have tblCategories, which was related 1:M to tblSubcategories. So, for
example:
- Category 1 had Subcategories A, B, and C
- Category 2 had Subcategories D,...
|
February 1st, 2005 01:39 PM
by MCB
|
4 |
208 |
|
|
|
|
2 |
160 |
|
|
Time formatting question by
Wylie C
I have a time field that I want to store hh:mm:ss. I can set the custom
format to 99:00:00 and the user can input the time but no matter what I do
the table...
|
January 31st, 2005 11:13 PM
by Rick B
|
7 |
176 |
|
|
Group Permissions by
Sam
I have a DataBase and a Replica. What impact will giving group permissions
have? I want to allow two groups access to enter/modify data on a form and
read a...
|
January 31st, 2005 04:33 PM
by Sam
|
0 |
129 |
|
|
|
January 30th, 2005 11:28 PM
by Chris2
|
4 |
152 |
|
|
|
|
9 |
281 |
|
|
table design by
[email protected]
I am having problem with a table design. The table is for
Quality measures. A couple of the attributes for the
Quality measures table are the Company name and...
|
|
3 |
151 |
|
|
|
|
1 |
216 |
|
|
Difference between primary key and index by
Amir
What is the difference between primary key and index in Access?
If I define an Index field which is Unique and Not allowed Null, is it a the
same as a PK?
|
January 30th, 2005 04:05 AM
by Chris2
|
3 |
150 |
|
|
Add Index Property To Temp Table by
Larry R Harrison Jr
I have Access 97. I have a "tmp" table that is created in code via a query
(or SQL statements), I then need to modify 2 of the fields to be index (dups
okay)....
|
|
3 |
138 |
|
|
Auto Numbering by
Craig B.
I am creating a data base and want to add a formula to my table so that when
a form is filled out an automatic number is assigned to each new document.
The...
|
|
6 |
230 |
|
|
problem with subform by
Nuno Camarinhas
I have a database on Projects. I have PROJECTS that can have many
participants, and PERSONS that participate in many PROJECTS.
Therefor, I created:
- a...
|
January 29th, 2005 02:42 PM
by Chris2
|
1 |
319 |
|
|
|
January 29th, 2005 05:05 AM
by Joan
|
0 |
108 |
|
|
|
January 28th, 2005 09:27 PM
by Dan
|
3 |
506 |