473,321 Members | 1,877 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,321 software developers and data experts.

A couple of questions....

Ron

Hello everyone,

I have a couple of questions really quick questions.

I am creating a dispatch database. What I would really like to do is
have to option of automatically inserting the time when I hit the "]"
button. Is this possble?

Also I am trying to create a form that has the standard boxes contained
within it and I would also like to add a subform or something simular in
a spreadsheet format that can be used to also enter information and to
look up information that has been entered. Would this be possable? And
if it is possable is there a way if I selected a row of infomation that
it would bring it back up in the original form?

Thanks again for your help,

Ron
--
Ron
------------------------------------------------------------------------
Ron's Profile: http://www.dbtalk.net/m48
View this thread: http://www.dbtalk.net/t296320

Mar 31 '06 #1
3 1580
Ron wrote:
Hello everyone,

I have a couple of questions really quick questions.

I am creating a dispatch database. What I would really like to do is
have to option of automatically inserting the time when I hit the "]"
button. Is this possble?
If you want to do this throughout the form, open up the forms property
sheet and open the event for OnKeyPress. Also set KeyPreview to True/Yes.

If it's for a specific field, put in an event for OnKeyPress. You can
also use OnKeyDown/Up too.

You need to find out the value for KeyAscii or KeyCode, depending on
which one you use, for the value pressed. You could enter something like
Msgbox "KeyAscii is " & KeyAscii
and find the value for ]

Then you know the value to check for to set the time. Press the F1 key
in the events I listed.

Also I am trying to create a form that has the standard boxes contained
within it and I would also like to add a subform or something simular in
a spreadsheet format that can be used to also enter information and to
look up information that has been entered.
Yes. You are only limited by your imagination.

Would this be possable? And if it is possable is there a way if I selected a row of infomation that
it would bring it back up in the original form?
Why would you do that if it is a subform? Anyway, you could use an
OnDblClick event to do whatever if that helps.

Thanks again for your help,

Ron

Mar 31 '06 #2
Ron

Salad Thankyou for your help, you have no clue how much it is
appreciated.

As far as the form is concerned, this is what I am trying to do.

1) Some of the dispatchers that I work with like using a traditional
form with boxes and some of them like using a spread sheet format. This
is one of the reasons for both.

2) The second reason that I would like a traditional form and a
spreadsheet format of all the calls entered is to be able create a
quicker way of looking up past calls without having to click through to
entry arrows at the bottom or going over to the original table.

This is primarely becuase we have differant officers arriving and
clearing at differant times and most of the time we have additional
time(s) or clearance times/deposition codes that we need to added to
the original call. So just being able to scroll down to that particular
call to plug in any of that information what save a tremendious amout of
time for our dispatcher.

I hope this gives you a little understanding of what I am trying to do
with this particular form.

Maybe I was wrong in calling it a subform.

What would I have to do after I create the original form to add a
history of all the calls in spreadsheet format at the bottom for what I
want to do?

Thankyou everyone again for your help, it is greatly appreciated. I
hope that I am not to much of a pain.

Ron
--
Ron
------------------------------------------------------------------------
Ron's Profile: http://www.dbtalk.net/m48
View this thread: http://www.dbtalk.net/t296320

Mar 31 '06 #3
Ron wrote:
Salad Thankyou for your help, you have no clue how much it is
appreciated.

As far as the form is concerned, this is what I am trying to do.

1) Some of the dispatchers that I work with like using a traditional
form with boxes and some of them like using a spread sheet format. This
is one of the reasons for both.

2) The second reason that I would like a traditional form and a
spreadsheet format of all the calls entered is to be able create a
quicker way of looking up past calls without having to click through to
entry arrows at the bottom or going over to the original table.

This is primarely becuase we have differant officers arriving and
clearing at differant times and most of the time we have additional
time(s) or clearance times/deposition codes that we need to added to
the original call. So just being able to scroll down to that particular
call to plug in any of that information what save a tremendious amout of
time for our dispatcher.

I hope this gives you a little understanding of what I am trying to do
with this particular form.

Maybe I was wrong in calling it a subform.

What would I have to do after I create the original form to add a
history of all the calls in spreadsheet format at the bottom for what I
want to do?

Thankyou everyone again for your help, it is greatly appreciated. I
hope that I am not to much of a pain.

Ron


Here is something I have done, if I understand your question. This
works for me and would incorporate both single form and something
similar to a datasheet. You would need to be able to code in VBA to use
what I do. I'll use an order form as an example.

I create, via the design wizard, a form to display the orders as a
continuous form. I'll call it OrderLog. Let's say the fields are
OrderNo, DateOfOrder, CustomerName, CustomerAddress, etc. I set this
form to no edit/delete/add as I don't want to change the data in the
continuous form. I display the records sorted from most recent order to
first order.

In the Form Header I have text boxes above each column to search for an
item. So if the person puts the cursor in the FindOrderNo text box, the
op enteres the order number and the AfterUpdate event finds the order
and moves to it. Or the person could go to client and enter "Peter" It
will then find the first Peter and by pressing F3 go to the next Peter.
This is by using FindFirst/FindNext "CustomerName Like *Peter*" IOW,
it's easy to find a record if you know what to look for.

In the form header I also may have combo boxes/option groups, etc to
filter the data. For example, I may have a combo that selects all of
the salesman that have created an order. I then select from that list
"Joe Blow" and all of the sales for JoeBlow are displayed (using
Me.Filter = "Salesman = 'Joe blow'", Me.FilterOn = True. Or perhaps
Me.Filter = "Active = True", Me.FilterOn = True to display only active
orders.

In the form footer I have command buttons to add an order or goto order,
sort the list, exit, etc.

I create a function called GoToRecord. I then hilight all columns and
pull up a property sheet and enter =GoToRecord() in the DblClick event
for the fields.

So, the user can dbl-click on each row or press the GoToRecord command
button. This opens the OrderForm. When I open that form it filters the
form to the filter in the OrderLog and its sort. I then find the record
I was on in OrderLog. Now the user is in a single order form with all
of it's info for input. Since the form is filtered to that of the
orderlist, one can navigate record by record through the orders. Once
the person is finished with a single order, he presses the exit button.
It gets the current order number and if the order log is open, finds
the current order number in the log and closes the order form. This way
the two forms remain synchronized.

Once you have created a log form, it's quite easy to modify it for other
logs. This is quick and easy for the ops to use. They can find records
fast and get to the record fast.

I don't know if this will meet your situation, but if works in mine.
The

Apr 1 '06 #4

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

Similar topics

2
by: bjs | last post by:
I hope I've got the right group here and apologies if I haven't. I'm a hobby programmer and have just upgraded to Visual Basic.net and have a couple of questions if anybody can help. In VB 6...
1
by: hoochiegooch | last post by:
Hi, all. I have a couple of questions about NAnt. 1. Is there a better way to invoke NAnt from a C# "Master Test Rig" than shelling out? IOW, how should an ASP.NET web app or Windows Service...
21
by: Rob Somers | last post by:
Hey people, I read a good thread on here regarding the reason why we use function prototypes, and it answered most of my questions, but I wanted to double check on a couple of things, as I am...
1
by: dln | last post by:
Howdy. I'm a bit new to C# and got a couple of quick questions that perhaps someone can help me answer. First, is there a property that you set on a TextBox control that will force the control to...
4
by: Sccr18 | last post by:
I just have a couple of easy questions: 1. In Asp.net using Vb is there a way to list all the possible characters without listing them all like Char() = "abc..."? 2. I was trying to set the focus...
3
by: punt | last post by:
I've got a couple of questions about a deployed VB.NET application. Firstly can a deployed application remember any variables(single string) after being closed down and re-opened, without the use...
0
by: Marc | last post by:
Hi, I'm working with a customer that is trying to find a solution to provide geographical redundancy. Our application is currently using IBM DB2 v8.2. I have a couple of questions with regards...
3
by: melton9 | last post by:
I'm just getting into using datagrid and have a couple of questions. 1.)How do you get the grid to show the values of a datatable automatically? Currently I have to hit the + sign and then...
0
by: Newish | last post by:
Hi Couple of questions on datagrid 1) Is there a performance issue when using datagrid to display data from a datatable. 2) Is there a security issue when using datagrid to display data...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.