Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
DATABASE CRASHES when creating new report from existing report25 Jan 2008 01:55 GMT6
I tried to create a new report from an existing report by using "save as"
while in report preview.  It seemed to work.  When I went to the database
window under reports, my new report name was not there.  I get the follwing
error message:
Multiple error messages24 Jan 2008 17:09 GMT5
I am the creator of an Access database and currently the only person having
this problem...I get errors of many types when I have left the database open
and return to or attempt to scroll through records.  The errors are
intermittent and seem to occur when I have multiple ...
Duplicate Values Question24 Jan 2008 16:02 GMT15
I have a table containing, among others, a field titled
numSerialNumber ("SN") and a field titled strBoardNumber ("BN"). The
SN field is the primary key, and the BN field is required.
Additionally, the BN field must contain a unique value, unless the SN
Lookup Wizard not displaying all field choices24 Jan 2008 14:32 GMT2
I realize a bunch of people posting do not like lookup up columns, but i
really have never had a problem with them...until today.
We are creating tables for a new database - eventually, everyone will be
using a form to enter data. Until the form is created, testing data entry
One to Many and Auto Number Problem24 Jan 2008 03:54 GMT26
I helped a co-worker set up a One to Many design. The parent table had a
field called TransID and we linked it to a child table which also had a field
called TransID. However, in keeping with the goal of having unique records [a
Primary Key], even though I don't like them, we ...
Integrating "Blocks" of Constants23 Jan 2008 20:34 GMT4
GIVEN:
A spreadsheet containing a dozen "blocks" of constants data.
Each block consists of 16 columns and 12 rows of constants,
and each block relates to a named, geographical location
ODBC Linked Tables23 Jan 2008 17:02 GMT2
Is there any way to point the linked tables that I have to another source. I
have the same tables in a test database as I do in live, whilst developing
the database I pointed everything to test now it is doing what I want I want
it to look at live. Is there anyway to change the ...
Calendar Control 1223 Jan 2008 16:41 GMT1
How do I display event information in the calendar on calendar control.  I
want to be able to click on a date and see the appointment information for
that date in the calendar such as in Outlook calendars.
How to prevent duplicates of non-primary key23 Jan 2008 13:55 GMT14
I am using Access as a front-end to an SQL database.  I need to be able to
prevent having duplicate keys without using a composite primary key.
I have a table that allows an employee to have multiple skill sets:
  SkillID        -  as my primary unique ID field
Transferring cumulative weekly time 40:00:00 from Access to Crysta23 Jan 2008 08:52 GMT2
I am creating a database with weekly staff hours in a format of 40:00:00, I
figured out how to get access to accept these numbers but now I need to
transfer this data accross to a crystal report to help compile it all.  I
believe their may be a setting in Access to allow this ...
appointment scheduler table structure23 Jan 2008 02:28 GMT1
I know that I may have more luck posting this question in an Outlook group,
but these Access groups are the ones that I most frequent, and I like all of
the regulars here.  This subject comes up quite a bit in these MSAccess
forums, and I have actually already designed a database ...
Junction Tables23 Jan 2008 00:36 GMT7
Is this valid?
Three tables (call them A, B & C), each with a junction table between (call
them a, b & c). Six tables total, in a related in a circle? Is there
something I'm missing with the junction tables?
ms access relationship problem22 Jan 2008 16:03 GMT1
I created a database in access with the following table. but when ever
i try to enter data it gives an error message.
"You cannot add or change a record because a related record is
required in table 'Insti_details'
Design strategy22 Jan 2008 11:33 GMT6
This will be a bit difficult ot explain, hope it clear.
As a product manager I'm responsable for a few brands. This means, I need to
keep SAP up-to-date for these products. t.i. buying and selling prices,
taxes etc.... On the other hand i retrieve data from SAP for analyses and
simple inventory for printer toners21 Jan 2008 22:43 GMT1
I need to order and track printer toners.  We have many many different
printers, therefore many toners.  When a user requests toner, I need to enter
their department and name.  At the end of the month I need a report that
lists which toner the user took, date they took; so I can ...
Pages: 1 2 3 4 5 6 7 8 December, 2007
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.