473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Interesting Problem......... or not so for the advanced, lol

At the moment my co uses a spreadsheet to note how many orders each
engineer is assigned and this is updated manually. I've thought about
transferring this to Access and have thought of two possible ways, 1 is
clearly better then the other but goes beyond my Access knowledge.
If anyone cares to have a read I'd appreciate any feedback.

Each particular order may have a number of sites and this is also
noted. The orders allocated per engineer is simply allocated as they
come in

Method 1
--------------
Create a form in which all the relevant details for each order (ie
engineer, number of sites) are inserted and this acts as a new record
for each order. Stats can then be extracted using a number of reports
and queries. This is a very simple approach but having a record for
each order is quite unnecessary as we only need a count of how many
orders and sites an engineer is working on.

Method 2
---------------
Enter the details in a form and on the click of a button, the values
entered on the form will be added to a table setup with the engineers
for each day. This way there will only be a max of 28 records per day
as we have 28 engineers.

Woulkd anyone have an idea of how to use numerical values entered into
a form to update a main table by simply adding the figures?

I hope this all makes sense.
Thanks

Jan 20 '06 #1
2 1300
For starters, what you can do is to create your base table. Add all the
data fields you want to collect. You can make the first column an
Autonum column (an Identity field) - you can name it something like
IDnum, then add a Eng_Name column (engineer's name) as a Text column,
maybe they all have ID's - Eng_ID As Number (or Text if Alpha Numeric),
.... and so on, and finally a date column for the respective date
EntryDate As Datetime.

Next you go to forms, New and in the dialog box at the bottom select the
table you just created. This will be your data entry form. The form
will be based on this table. In the design view of the form on the top
side of the window go to the first toolbar. In the middle of the
toolbar, you will see an Icon with the planet Earth, and to the right of
that are 2 more icons, one looks like a Notepad, and the other is a
toolbox icon. You are interested in the Notepad looking icon. This is
the field list of the table you just created. If you hold your mouse
over the icon, it will say "Field List". Click on this icon and you
will get a list of all your table fields. If you click on the top of
this list, it will highlight the entire list. Drag this highlighted
section to your form and release the mouse button. The fields will now
be placed on your form. Now you can drag the fields around as you need.
When you enter data into these fields, the data will automatically be
entered into the table. This is called data entry form. Please forgive
me if you already know all this.

In your date field, you can add a function like =Date() to the default
value on the properties sheet of the date field. To get to the
properties sheet, just right-click on the date field (right click on any
field to get to the property sheet). There is a row in the property
sheet that says "Default Value". This is where you enter

=Date().

Now the current date will be entered into that field for each record.
For today, today's date gets entered. For tommorrow, it would be
tommorrow's date. If you need something different than that then you
will have to add/write a little bit of code in the field's After_Update
event. But hopefully this will get you started. If you need more
assistance,just post again.

HTH

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Jan 20 '06 #2
Once you set up your basic database as Rich P gave instructions for,
you can customize it to do exactly what you want it to. For example, in
Method 2 you could delete all the records in your table before entering
the first record for the new day, and then (since you only want a count
of how many orders and sites per engineer) input engineer name/ID,
number of orders to add, and number of sites to add. When you wanted to
get your stats on the engineers, you could run a query that would sum
up the number of sites and number of orders for each engineer.

Jan 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jay | last post by:
Hi everybody ! I am a newbie here. I hope somebody will help with my problem. I am currently write a web-application that allow user to submit their job application online. In the job...
0
by: Michael J. Wendell | last post by:
Hello, I am trying to debug an issue with sessions in my ASP 3.0 web application, which runs fine on WIN2K Pro and WINXP Pro, yet fails to function correctly on WIN2K Advanced Server. My actual...
2
by: nanookfan | last post by:
Hi all, I'm having a bizarre problem converting XML files to HTML using an XSLT. The problem is only occuring in my Netscape 7.0 browser. What makes it more bizarre is that it is only...
8
by: Dominic Tocci | last post by:
I'm searching for a way to use window.open on my web page to open a window in firefox that allows the sidebars to work (bookmarks, history, etc). When I use the following: var...
3
by: Leslie A Rhorer | last post by:
Hello all, I am quite new to HTML, and I have created a number of pages related to a project on which I am working. Several of the pages look just the way I want with the default font settings...
2
by: news.symantec.com | last post by:
Hi All, I'm trying to install DB2 Enterprise Edition 8.1 (partitioned installation) onto a clean Win 2k SP4 advanced server box. The problem is the partitioned installation requires a "Domain...
1
by: Methven | last post by:
File - Get External Data - Import - Text Type - Advanced - Specs PROBLEM Can anyone assist me with a problem ? When attempting to specify an import specification using ; File - Get External...
0
by: mortenol | last post by:
Hi, I am trying to connect a MS SSIS package to an AS400/DB2 database, and I experience problem when I hit the "Create Package" button in the "Data Link properties window". I have understood that...
3
omerbutt
by: omerbutt | last post by:
hi there i have downloaded a prototype tooltip from http://www.nickstakenburg.com/projects/prototip/ the logic it uses is to call the script after creating the <div> for example i am using the...
2
by: swethak | last post by:
hi , i write the code in .htm file. It is in cgi-bin/searches/one.htm.In that i write a form submitting and validations.But validations are not worked in that .htm file. I used the same code in my...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.