I am trying to find a way to do the following
I need to make a report (or datagrid, not sure which would be better) that can be printed. The format of the report is as follows:
The first column on the print out is 24 hours in half hour increments (starts with midnight 00:00 and ends the next midnight 23:30). The rest of the columns on the report are fields from access 2003 database as well.
When a schedule for an event is entered into the database, it has a start date and time and a stop date and time. The event could last for hours, days or evenweeks, but each new day would be a seperate output.
With that said I will try and explain as well as possible
Database field names:
Date_In
Time_In
Date_Out
Time_Out
Unit_Name
Impact_Area_Use d
Unit A requests a block of time :
Date_In = 8/28/2006
Time_In = 01:00
Date_Out = 8/28/2006
Time_Out = 04:00
Unit_Name = A
Impact_Area_Use d = "Charlie Range"
(Please note that the times can overlap
as the units are on differnet ranges, one is on Charlie Range while the other is on Echo Range)
Unit B requests a block of time :
Date_In = 8/28/2006
Time_In = 00:30
Date_Out = 8/28/2006
Time_Out = 02:30
Unit_Name = B
Impact_Area_Use d = "Echo Range"
So, using the input of the start date/time and end date/time, Unit A has requested the use of Charlie Range for a 3 hour period.
So, using the input of the start date/time and end date/time, Unit B has requested the use of Echo Range for a 2 hour period.
So, the layout of the datagrid (or whatever control would work best, or if report would be better?) would be something like the following
TIME Charlie Range Echo Range North TAC (Fields continue>>
00:00
00:30 Unit B
01:00 Unit A Unit B
01:30 Unit A Unit B
02:00 Unit A Unit B
02:30 Unit A Unit B
03:00 Unit A
03:30 Unit A
04:00 Unit A
04:30
05:00
(and this continues until you hit 23:30 as the last time entry for this day)
I have a scanned copy in Acrobat of the current schedule that they print out if anyone has any ideas and would like to see it, I can send it to them.
Thanks in advance. So far, I haven't figured out a way to use the existing data and fields I have to make this work. But I also know there are some very sharp individuals on here (2 of whom I have gotten help from before, Killer42 and Will akaWill, thanks again to you both!) I hope everyone has a great thanksgiving and a safe one!
3 3134
Not getting much of a response to this one, are you?
I suspect it's just too big for most of us to tackle. Don't know about the others, but I'm only popping in here between other tasks, so something this in-depth is kind of daunting - sorry.
You might want to try posting another copy of this to the Access forum, as I suspect you'll find more help there. It seems like more of a general design-type question than a VB-specific one (though of course it will have to boil down to VB in the end). If you agree, then it might also be a good idea to post in one of the more general forums, such as the programmers lounge.
Thanks for the suggestion Killer42. I am looking at another way of achieving the goal that I think will work. Will update this post as soon as testing is complete. And thank you for the advise and all the help you have given!
Not getting much of a response to this one, are you? ...
I must have got my threads mixed up. I thought this one had been outstanding for a week or more when I posted that comment.
Anyway, hope it works out OK.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Bill Sonia |
last post by:
It seems whenever I set a DataGrid.DataSource = DataTable
(vb.net) to populate a datagrid, the scroll bars on the
datagrid default to disabled. And the only way I can get
them to enable is to manually resize a column width with
the mouse (not very elegant).
Anyone have any ideas how I could enable the datagrid
scroll bars in my code?
Thanks,
|
by: Kurt Häusler |
last post by:
Hi.
I just installed the latest visual studio .NET 2003 and am doing some c#
work. Its just a standard windows forms program, not an asp or web thing.
I have been able to use a DataGrid ok, except this version of DataGrid
doesnt seem to have a SelectedItem member.
Additionally there is no DataGridItem class either.
|
by: Stan |
last post by:
This is how I access Pieces field in my editable datargid during Update
event:
protected void grdMain_OnUpdate(Object sender, DataGridCommandEventArgs e)
{
string Pieces = ((TextBox) e.Item.FindControl ("txtPieces")).Text;
....
}
|
by: Matthew Wieder |
last post by:
Hi - I have a datagrid that has a black header and the rows alternate
white and gray. The problem is that until items are added to the grid,
the grid appears as a large black rectangle, which is quite ugly. The
black area is larger then it is once an item is added. How can I solve
this problem either by:
A) Having only the header black and the rest of the empty block white or
gray (preffered solution)
B) Having the color gray or white...
|
by: damonf |
last post by:
I'm currently trying to add an ASP hyperlink to a
template column in a datagrid. The normal hyperlink
column doesn't give me the ability to add attributes to
the item. In my grid there are four columns. Three are
databound to a dataset and one is a template column. I
need to be able to access each item in the template
column (getting access to the hyperlink) then adding an
attribute to call some client side code. Does anyone
know...
| |
by: Jeff User |
last post by:
Hi
I tryed to solve this problem over in the framework.asp group, but
still am having trouble. Hope someone here can help.
using .net 1.1, VS 2003 and C#
I have an asp.DataGrid control with a Delete button on the end of each
row. I am unable to gain access to the event when the button is
clicked.
I don't fully understand how the click gets connected to the C# code,
|
by: Manuel Alves |
last post by:
Scenario:
ASP 2.0 on XP pro dev machine works fine.
Publishing to windows 2003 server worked OK until I included paging for a
datagrid.
On page load I cal sub binddata
Private Sub binddata()
Dim ds As DataSet = getMydataset()
|
by: Aziz |
last post by:
Hello, I'm using a DataGrid to add a product to an order. I would like
to fill in a child field (a foreign key) by bringing up a ComboBox
inside the the datagrid cell (like in the latest Northwind database) so
that it shows all available options and I can select the right one.
E.g. in the Orders datagrid I can simply select the product to order by
using a dropdown list
I'm using access 2003 and a VB .NET 2003. I need a solution that is...
|
by: yzlin04 |
last post by:
I'm using VB.net 2003. I can delete a row in datagrid (dgTempTransaction), but my MS Access table can't directly being updated. The row i deleted is still exist in my MS Access, but in my datagrid, it already being deleted.
The table name in my MS Access: tableTempTransaction.
Here is my code for that part...i don't know where is the error. Please help me..... Thanks anyway.
Dim currManager As CurrencyManager
If...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
| |