|
No 'allow multiple values check box'
Access 2007
Trying to create an input form which has a field which will populate a
multivalue field in a table. However I cannot get the wizard to display the '
allow multiple values check box '. This is true for the table and the form.
The database was first created in the 2003 version and then converted, might
this be the problem???
Help please!!
...
|
3 |
6/5/2007 1:05:09 AM |
|
|
Create a numbered list that allows change in priority.
Hello anyone/everyone,
I'm trying to set up a form/report that allows me to move an item from
one point in the list to another. For example, if the list consists
of:
Name Date Of Entry Referral
Source Change Date
1- John S. 05/05/07 ABC Facility
2. Christopher C. 05/06/07 Hamilton Hospi...
|
2 |
6/4/2007 10:33:55 PM |
|
|
FONT
Just a quick question. I am trying to just change the font of a few words in
Access 2007 but it will only let me change the font of the whole database.
Is there just a way to change a few words? Thanks....
|
3 |
6/4/2007 10:20:50 PM |
|
|
Back table not deleting?
Hi everyone,
It appears that my back table isn't deleting the main record and the related
sub-records when you delete the main record from the form. I've double
checked the relationships and all are correct with referential integrity
turned on (one to many)with cascade deleting selected. If you go into the
form and delete the record it looks like it's gone and you can no longer see
i...
|
7 |
6/4/2007 10:05:00 PM |
|
|
Maximum Indexes Reached
I have a database with a lot of tables. One of my main tables links to most
of the other tables. I tried to create a relationship that has Enforcce
Referential Integrity set but I receieved an error:
"There are too many indexes on the table. Delete some of the indexes on the
table and try the opertation again.
I looked at the help and see that 32 indexes are the maximum. Is there a...
|
4 |
6/4/2007 8:33:26 PM |
|
|
Autofilling a field if a previous field on the same form is >9999.
--
DMainland...
|
1 |
6/4/2007 8:16:01 PM |
|
|
Database for my articles
I have some 140 MB's worth of journal articles. I need a searchable database
that shows the author, journal name, date, a brief summary, key words, as
well as the file name on my computer. I've never used access, but i'm a quick
study.
...
|
8 |
6/4/2007 4:31:09 PM |
|
|
Linking several tables to one table
Hi,
I am creating a database that stores IP addresses for various devices
(network switches, computers etc) on the network. I had hoped to be able to
have one table in the middle that stores an IP address to a serial number.
Seperate tables, one for computers and one for switches would link to this
table to get the IP address for the device's serial number.
Unfortunatly, after I've cr...
|
4 |
6/4/2007 2:09:56 PM |
|
|
invalid use of null
I have the following code which checks the ISBN check digit to ensure a
correct ISBN no is enter for a product. This works fine, however, if the
user enters the field and then decideds not to enter an isbn no, i get the
'Invalid Use of Null' error message which will not go away and even takes the
user into the code, which i don't want. Could anyone please tell me how to
stop this happe...
|
8 |
6/4/2007 9:41:28 AM |
|
|
In need of quick help
Hi I am in the process of putting together a database and my boss is not too
familiar with Access and neither am I. I was wondering if there is any way
to create "subfields" in Access. For example, I am looking to make a main
heading "Contact Information" and then subcolumns within that column with
headings such as "email address," "phone," etc. Thank you for your help....
|
10 |
6/4/2007 6:52:00 AM |
|
|
Table/Relationship Design
This is probably basic normalization design, but I can't seem to figure it out:
I have four Vendor Types: AG, IC, GB, DE
I have ten Service Types: 001 - 010
For each Vendor Type/Service Type combination there are minimum and maximum
rates, eg:
AG 001 is from $15-$23,
AG 002 is from $17 - $28
IC 001 is from $8.00 -10.00
IC 002 is from $10.00-$15.00
etc.
I'm trying to figure ou...
|
5 |
6/4/2007 4:04:15 AM |
|
|
Basic question about Table design (2 tables versus many)
Hi All,
I have moderate knowledge of Microsoft Access. I have been building
small databases for years and just sort of learning and and picking up
things as I go. At this point I'm pretty proficient at writing basic
code, running complex queries and creating really pretty forms. :-)
Because I'm pretty much self taught I lack some of the fundamental
knowledge of database design, especia...
|
4 |
6/3/2007 11:49:57 PM |
|
|
multidata property for text box
dear friends ,
i have an field name for Eg ,[ train detention] ..(date/time)
if the train detained entry will be (date and tme )
else (text) like "not
stoped" ,,etc
how to format a field text box for this and further use the
time
value foir calulation
balu. ...
|
2 |
6/3/2007 7:38:17 PM |
|
|
Help Please - Copying Records from one table to another
Hi All,
I have 2 similar databases the table1 in each is slightly different
with the addition of extra colums.
let me explain,
Database 1 (db1) is older than Database 2 (db2) and therefore Table1
in db1 has the original set of columns in it lets say a b c d e f .
Now db2 being a more updated version has columns a b c d e f g h i &
finally j in it. for example.
I know how to import ...
|
5 |
6/3/2007 7:33:58 PM |
|
|
form login password
dear friends
i have an table name Employees
field employees (text)
" password (text)
table 2 name Loggers
field employeename (text)
date (date)
password (text)
i have created an form to use as an main form based on loggers table and
placed other command buttons on its header to access other forms and for...
|
3 |
6/3/2007 2:23:01 PM |
|
|
Split same fields into two seperate tables?
I have several fields with the same name in two seperate tables..example...PO
Number, RMA#, serial # etc.
The tables names are Shipping and Receiving. The shipper ships the item to
an address and then when he receives it he ships back either the full order
or only half of the order. Either way he uses the same RMA etc fields in both
tables. Is thier a simpler non redundant 3NF way of do...
|
2 |
6/1/2007 10:50:00 PM |
|
|
Linking Tables TO another DB
I am using Access 2003 SP2.
I have a masster db and several working db's. When I create a table in the
master db is it possible to link that table from the master to a working db?
I know I can link it while in the working db, but can I do it from the master?
It seems to me that the lined tables would be better managed if I can set
the link from the master.
I've tried using the Tra...
|
5 |
6/1/2007 8:28:02 PM |
|
|
Access 2000 - Create a Dependants Table
For a Health Club membership system, I have been tasked with designing a
Parent and Dependants (Family Members) table so we can track what Members are
signing up for classes. My first thought is to have both the Parent and each
of the Family Members in a single table each being assigned their own
CustomerID.
Is this the best way to accomplish this?
My sample layout for my tblCustome...
|
3 |
6/1/2007 1:29:03 PM |
|
|
Unique serial neumber in table
I would like each new record that is entered into a table to have a unique
seial number automatically assingned to that row of data. Is it possible to
do that?...
|
3 |
6/1/2007 1:22:00 PM |
|
|
mde file in network folder
I have placed an mde file in a network folder with a linked table that is in
a mdb file in a different drive. Although I have successfully tested the app
both from a local copy and the file on the network a user is getting the
error Jet database engine cannot open the file "F:\.... it is already in use
by another user or you need permission to view its data"
I compiled this file on my ...
|
9 |
6/1/2007 1:08:03 PM |
|
|
Re: Continuous SubForms
I have a form which contains a sub form for each day in the month (to create
a schedule/calendar for hours worked by each member of staff in our call
center). Each sub form accesses the same query that determines who worked
which hours on which days.
The problem I have is that each sub form is set to continuous and displays
ALL fields in the query (name, startTime and endTime). I can se...
|
4 |
6/1/2007 12:49:09 AM |
|
|
Combine same fields into one table?
I have several of the same fields in two seperate tables: Shipping and
Receiving.
When a shipment goes out it has a RMA, PO# and a Serial# etc. These fields
are redundant in both tables. Is thier a way I can use these fields only once
while tracking the shipment? ...
|
4 |
5/31/2007 9:00:02 PM |
|
|
Database Design Scorecard
I have a working database that I am "tweaking" and would like advice on best
practices for table design. Scorecards are composed of multiple measures
often with multiple data types. Currently I have a text field in one table
that holds the results of all our measures. This works fine for reports
because I have assigned each measure a "type", i.e. percent, currency etc.
and use this related...
|
2 |
5/31/2007 8:02:54 PM |
|
|
Validation Rule? IF (Field A) = (Cell Value), then Field B ok
For example
Field A = ID #'s
Field B = Characteristics from a drop down value list.
If [FieldA] = "32", then [Field B] Must be entered/selected (in the form)
I want the value list to activate on the form if Field A is "32"
Not sure if this is possible.
Thank you in advance,
T...
|
3 |
5/31/2007 7:57:00 PM |
|
|
Help with design
Hi, I have a small homemade inventory database that work fairly good in
keeping track of my customers purchase'and payment. Recently I face a
situation like below and did not know how to structure my tables to
accomodate this changes.
My customers come to buy stuff on credit which cost about $200. Later he
come to pay $500 and take another puchase of $650. In this case I didn't
know h...
|
2 |
5/31/2007 7:11:05 PM |