Hi
I have been tasked with converting my pulp and paper mills weekly
projected and actual contractor hrs excel spreadsheet into a an Access
97 database.
So far my design has been to use a form with a button for each to day
navigate the recordset of a single table using .findfirst and .nomatch
and I am worried about performance as I'm basically creating a flat
file.
I could explain the scenario but I think it will be easier to display
data
For: weekending 13/12/03
Planner: Jimmy Smith Business Area: Causticizing Plant
Day: Monday
Work Types
Maintenance Capital Production
Contractor Types
Electrical 2hrs 4hrs
Scaffolders
Fitters 1hrs 4hrs
Welders 8hrs
etc
This is repeated for Days Tuesday
,Wednesday,Thur sday,Friday,Wee kend,Week2,Week 3,Week4 for the five
different business areas by the 5 different users on a weekly basis. I
think the weekending date is very important for grouping.
The problem is if I normalise the datastructure and use continuous
subforms to input the data it will be slower and complicated for users
to input data. Does anyone have any suggestions for a more logical
way of designing this database? If not does anyone know how to set a
form to display a recordset row after finding it using the seek
method? Ive got it working using bookmarks with findfirst but it
oesn't seem to work with seek which is a shame as I've read it's alot
faster.
Any advice would be much appreciated
Thankyou
Michael Black 2 2132
Mike, just two respond to three points: The problem is if I normalise the datastructure and use continuous
subforms to input the data it will be slower and complicated for users to
input data.
No. Databases are totally different to spreadsheets. Producing a normalized
design, is a fundamental requirement for any competent database. This is
nothing to do with user interface issues. Once you have designed a properly
normalized database, you can then produce forms, subforms, reports etc. for
data entry, enquiry & reporting. It is the "flat file" approach that will
give you grief in the long run; not the "normalizin g" approach.
Does anyone have any suggestions for a more logical way of designing this
database?
Yes. Read: http://support.microsoft.com/support...es/Q100139.ASP
If not does anyone know how to set a form to display a recordset row after
finding it using the seek method?
Forget about user interface issues at this stage. They are really >>not
important<< (in 99.999% of cases) until your table design is correct. >Then<
design the user interface.
HTH,
TC
"Mike" <mb*********@ho tmail.com> wrote in message
news:7a******** *************** ***@posting.goo gle.com... Hi
I have been tasked with converting my pulp and paper mills weekly projected and actual contractor hrs excel spreadsheet into a an Access 97 database.
So far my design has been to use a form with a button for each to day navigate the recordset of a single table using .findfirst and .nomatch and I am worried about performance as I'm basically creating a flat file.
I could explain the scenario but I think it will be easier to display data
For: weekending 13/12/03 Planner: Jimmy Smith Business Area: Causticizing Plant
Day: Monday
Work Types Maintenance Capital Production Contractor Types
Electrical 2hrs 4hrs Scaffolders Fitters 1hrs 4hrs Welders 8hrs etc
This is repeated for Days Tuesday ,Wednesday,Thur sday,Friday,Wee kend,Week2,Week 3,Week4 for the five different business areas by the 5 different users on a weekly basis. I think the weekending date is very important for grouping.
The problem is if I normalise the datastructure and use continuous subforms to input the data it will be slower and complicated for users to input data. Does anyone have any suggestions for a more logical way of designing this database? If not does anyone know how to set a form to display a recordset row after finding it using the seek method? Ive got it working using bookmarks with findfirst but it oesn't seem to work with seek which is a shame as I've read it's alot faster.
Any advice would be much appreciated
Thankyou
Michael Black
I've build a small d/b using a 'query form' to handle the 'week
ending' (I use a date range', the planner id and business area id in
your example
a subform prompts for the other fields in your example
with pull downs for work type and contractor type.. minimal entry is
required
let me know if you're interested mb*********@hot mail.com (Mike) wrote in message news:<7a******* *************** ****@posting.go ogle.com>... Hi
I have been tasked with converting my pulp and paper mills weekly projected and actual contractor hrs excel spreadsheet into a an Access 97 database.
So far my design has been to use a form with a button for each to day navigate the recordset of a single table using .findfirst and .nomatch and I am worried about performance as I'm basically creating a flat file.
I could explain the scenario but I think it will be easier to display data
For: weekending 13/12/03 Planner: Jimmy Smith Business Area: Causticizing Plant
Day: Monday
Work Types Maintenance Capital Production Contractor Types
Electrical 2hrs 4hrs Scaffolders Fitters 1hrs 4hrs Welders 8hrs etc
This is repeated for Days Tuesday ,Wednesday,Thur sday,Friday,Wee kend,Week2,Week 3,Week4 for the five different business areas by the 5 different users on a weekly basis. I think the weekending date is very important for grouping.
The problem is if I normalise the datastructure and use continuous subforms to input the data it will be slower and complicated for users to input data. Does anyone have any suggestions for a more logical way of designing this database? If not does anyone know how to set a form to display a recordset row after finding it using the seek method? Ive got it working using bookmarks with findfirst but it oesn't seem to work with seek which is a shame as I've read it's alot faster.
Any advice would be much appreciated
Thankyou
Michael Black This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Nomen Nescio |
last post by:
can anyone be so kind as to look at
http://www.mysolution.ws/HYPOCRITE.php
and let me know why it isn't passing the form data to
http://www.mysolution.ws/insertHYPOCRITES.php
for the most part, the scripts were created with
http://phpcodegenie.sourceforge.net/
|
by: Kingdom |
last post by:
I have a SelectBoxes.asp page that is working with multiple selection
dropdown boxes to extract data and total the selection prices.
Tom & Bob were kind enough to give me a big help getting this page
working and it's working just fine, no problems with this page.
However I then would like this data e-mailed using jmail (my host insists
on this method) and that is the function of the sendEMail2.asp page.
This is failing and only giving...
|
by: D Witherspoon |
last post by:
I am developing a Windows Forms application in VB.NET that will use .NET
remoting to access the data tier classes.
A very simple way I have come up with is by creating typed (.xsd) datasets.
For example dsParts.xsd and including that in the data tier. I then will
create a class that looks like this
Public Class CPart
Inherits dsParts
|
by: cleveralex1212 |
last post by:
Sorry to disturb. I'm truly a beginner in C++ and my knowledge of it is
really not much. I've been facing a serious problem during these few
days. Let me describe my situation as clearly as I can and I do hope
you guys can give me a helping hand.
Suppose I have a number of people's personal information such as name,
age, hobbies, etc. How can I store them in a way that can be easily
amended by each person? How can I group the people with...
|
by: intl04 |
last post by:
How do I create a data input form in Access that is external to the
Access database to which it's connected (if that's possible, which I
believe it is)? For example, if someone clicks on an Access file icon
on a computer desktop, it will open up a data entry form (that was
created in Access). That way, the people who enter the data won't have
direct access to the database at any point.
I've seen that this can be done, but I don't know...
| |
by: Mark Eden |
last post by:
I havent done any Access database design since doing A-Levels at
college, that was 5 to 6 years ago. Now i have to design one for work
and I have hit problems.
Basically my database has a number of linked tables which extracts
data from an SQL Database. I then perform a number of queries to cut
out all the information i dont need using make table queries. In these
tables it stores items such as Site ID, Site Name, Person responsible
for...
|
by: Francis Debrabandere |
last post by:
Hi all,
I'm a beginner in ms access, and I'm working on my first real
application. But to finish it up I'm facing a problem. I'm not able to
solve and maybe someone can help me.
I have made a database that can be divided in two major parts:
1. entering data
2. reading the entered data.
Everybody who uses the database has access to the second part. The
|
by: sellcraig |
last post by:
Microsoft access
2 tables
table "data main" contains a field called "code"
table "ddw1" is created from a make table query of "data main"
Goal-
the data in "code" field in needs to be inserted into a standard web
address in the table (the filed name is link) in ddw1
Example address ---
|
by: lifeisgreat20009 |
last post by:
I am a newbie to Struts and JSP...I have been working on the code below for 5 hours now..I googled a lot but couldn't get much help so finally I am here.. Hoping of getting my problem solved. Please give me some idea where I am going wrong ??
I just want to retrieve data from my emp_mstr table and display it using my JSP file...
The table emp_mstr is as follows :-
CREATE TABLE EMP_MSTR(
EMP_NO VARCHAR(10) PRIMARY KEY,
PASSWORD...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |