Multitable searching
Mon, 24 Nov 2008 09:30:18 -0800
I'm posting this in the design group because I'm actually trying to think of
different ways to design this thing. I say thing because it's become more of
a monster then a dbase. And one quick note, please don't comment on my naming
conventions. I'm not a professional nor will I ever expect to be one. But I
a ...
|
Problem with new database
Mon, 24 Nov 2008 07:28:07 -0800
All,
Access 2003, Win XP, some sort of huge server.
I re-wrote (for the fifth of sixth time) the database we use for tracking
employees, work locations, and various bits of information. The newest
database still has about a dozen tables, but a simpler relational structure.
Anyway, everything was work ...
|
Limit the size of an Access Table
Sun, 23 Nov 2008 19:49:01 -0800
I want to create a table that will accept only a limited number of records -
say 10 records. I want the user to be able delete or add records but I don't
want the total number of records to exceed 10. How do I do this? ...
|
Your Opinion on Design Question
Sun, 23 Nov 2008 07:52:03 -0800
I'll try to describe the situation pretty thoroughly and then I have a pretty
specific question. For an Inventory database, we are trying to keep track of
2 pieces of information. One piece is the quantity of each item (each item
is defined by an SKU number). The other piece is the location of each item.
...
|
How to Create My Own Self Define Icon in BUTTON
Sun, 23 Nov 2008 04:15:33 GMT
Hi,
1.Just to make my application more user friendly, I like to create an icon
with my own define pics..
(Eg: Button with Handphone Symbol?)
2. Anyone knows how to do it ?
Edison
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200811/1
...
|
One table or a couple?
Sat, 22 Nov 2008 17:10:01 -0800
Okay, I have a question about denormalizing. I have an activities table.
One particular activity that may take place is the setting of traps, each of
which has many captures. Another activity is hunting, which may also have
many captures. The problem I'm running into is whether I should have
multiple tab ...
|
Short time format problem in Access 2007
Sat, 22 Nov 2008 07:57:01 -0800
In my table, I have a date/time field and have format the field for short time.
When I enter 00:34 hours, the table converts that to 0:34 hours dropping the
first zero. I have tried various ways to format the field but can not get
access 2007 to properly format the field in a 24 hour format.
When my form ...
|
|
|
access 2007 runtime
Sat, 22 Nov 2008 05:38:01 -0800
Is there a way to setup different install options for a split DB using Access
2007 Runtime? install both frontend and backend, install just backend,
install just frontend. From what I can tell it only allows one setup option.
Any information would be appreciated. ...
|
New to Access & DB's
Fri, 21 Nov 2008 22:22:03 -0800
Hi All!
I'm a brand-spanking-new Access user, especially am new to the Microsoft
Office 2007 version. I have the need to make a hobby-related database which
contains data from 10-15 years of published data containing a small number of
related fields. I tried to learn Assembly, like the type used in Micros ...
|
Pass Field Name Using Variable to SQL string
Fri, 21 Nov 2008 17:54:22 -0800
I want to pass field names to an SQL string to identify the current of many
fields that I have to update in the table tblData (ie Fields ----> Jan06,
Feb06, Mar03......Dec09).
I want to use a recordset with SQL to identify the current field and edit
and update the current record in the current field.
Th ...
|
