|
|
Autonumber 0ne-One by
acss
I have an invoice table and an invoice details table and i need to have the
design accept duplicate invoice numbers since we receive same invoices from...
( 1 2 3)
|
|
22 |
787 |
|
|
Default date question by
acss
I have a FE/BE design with the BE residing in a network folder. The data
entry form in this DB has a hidden date field with default Now() and some
entries...
|
|
1 |
121 |
|
|
Primary key to prevent duplicates by
acss
I have an invoice DB and the primary key field is for the invoice number
which is unique and should not be duplicated. I have just received duplicate...
|
|
8 |
192 |
|
|
Preliminary design by
acss
I am in the first stage of creating a DB that will be utilized by six people.
They will be keying data and running queries during each month as invoices
are...
|
May 5th, 2009 02:37 PM
by acss
|
8 |
153 |
|
|
relationship inderteminate---Fred? by
acss
On May 4th i made a posting and only now i am working on my DB...I receive
the error of relationship inderteminate when using the INVOICE ID field from
my...
( 1 2)
|
May 18th, 2009 05:33 PM
by acss
|
11 |
447 |
|
|
Date format in design by
acss
I am creating a DB to track invoices and in the future i would like to run
queiries or reports that would separate invoices from one month to the other.
For...
|
|
6 |
252 |
|
|
Design Issue by
acss
Creating a invoice tracking DB yet there is no standardization from the 7
different formats that customers send in. Some fields are always on invoices
such...
|
|
6 |
180 |
|
|
Allow Duplicates by
acss
i have a table for invoices and at times i receive a duplicate invoice number
from another country. How do i set up a primary key (InvoiceID) and a
secondary...
( 1 2)
|
|
19 |
314 |
|
|
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 |
186 |
|
|
Drop down list edit by
acss
I have a drop down list on one of my forms that contains description
selections for end users to pick from. The problem is that the field can not
be edited...
|
March 31st, 2008 11:44 PM
by Evi
|
2 |
100 |
|
|
Remove/Hide Toolbar by
acss
How does one remove or hide the toolbar so end users do not have the option
to play with the design? I only have one query that needs the export to
excell...
|
March 28th, 2008 06:52 PM
by Evi
|
1 |
138 |
|
|
Tables Normalized? by
acss
I have three tables, one for vendor ID, another for centerID (which
identifies country business cost location) and one for invoice information
identfying...
|
|
1 |
102 |
|
|
Time on date by
acss
I have a date field that is set at short date and when a query is run is
fills in the field with date and time. How does one prevent the time from
being...
|
|
6 |
79 |
|
|
Primary key value by
acss
I have a number data type in my primary key field and for some reason when i
key in 016 it reverts to the number 16. What can be done so it does not
remove...
|
|
3 |
68 |
|
|
|
August 30th, 2006 08:21 PM
by Neil
|
1 |
61 |
|
|
Command button wizard won't start by
Adam
Within the last week when I add a command button to a form the wizrd will not
start. I have changed the registry key for sandbox from 3 to 2. That didn't...
|
|
2 |
115 |
|
|
Help Tracking Hairdye by
Adam
I am working on a database for a cosmetologist friend of mine and I'm trying
to track hair dye inventory, and then subsequently be able to run a report...
|
|
3 |
76 |
|
|
Relationships?? by
Adam
1. I have a one-to-many relationship. But everytime i go back to the
relationship window Access automatically creates another relationship using
the same table...
|
|
3 |
90 |
|
|
Hyperlink field by
Adam
I hope this is the right Access sub-group for this post -
apologies if not!
I'm setting up a catalogue of our team's files. This is in
Access, but the problem...
( 1 2)
|
|
12 |
313 |
|
|
Thanks! by
Adam
Hi Everyone
I just wanted to say a really big 'Thank you' to everyone who has helped me
over the past year.
Some of you may remember answering my many...
|
|
1 |
99 |