User Profile

Ajay Bathija · Apr 25 '07, 03:44 PM

Ade:

Thanks for the response. Sorry for the delay.

Ade, this is a scheduler and hence it will be inconvenient for the users to see the time in 24hr format. It will help coding but may not be good for the users. Hence I am trying to keep the time in the 12 hr format.

I tried using the code that you provided (I copied and pasted the code). While executing, it gives the error "Syntax...

Ajay Bathija · Apr 18 '07, 08:43 PM

A. Ade, In the class they are declared as:

Code:

Dim mstrScheduleID AS String
Dim mstrPeronID AS String

Both of the above variables will always have a numeric value in the string format.
The values for these variables are pulled from other tables in the database depending on who is using the system and on which schedule there are.

B. Ade, I just realized that this is the mistake made throughout the code....

Ajay Bathija · Apr 17 '07, 08:18 PM

Ade, I apologize if I mis-spelled anything.
The metadata information that you requested.

Table Name = ScheduleItem

Code:

ScheduleItemID; AutoNumber, PK
ScehduleID, Number, Fk
PersonID, Number, FK
StartTime, Date/time
EndTime, Date/Time
RoleID, Number, FK

Table Name = racRoles

Code:

RoleID, Autonumber, PK
RoleName, Text

While responding to you, I realized...

Ajay Bathija · Apr 16 '07, 09:51 PM

Ade,

Thanks for coming to the recuse.

Earlier I tried the Orderby function, but it had not worked for me. I Am now sure that I had made some stupid mistake in the snytax.

Ade, the solution that you have provided works for me and can meet the minimun requirements of my project atleast.

The limitation of this method would be that the user cannot Sort the Datagridview while...

Ajay Bathija · Apr 13 '07, 09:04 PM

The above diagonsis seems to be incorrect.
http://www.thescripts.com/forum/thread347463.html

It is Access that is causing the problem I guess.

They have used the "format" technique which did not work in my case due to sorting.

Ajay Bathija
www.ajaybathija.com...

Ajay Bathija · Apr 13 '07, 08:47 PM

Same result, the date is being inserted.

Based on the techniques that we have used, my understanding is that Access is not the one adding the date. The vb.net or the ole Adapter is adding the date.
If I use the simple query for just pulling the time directly (wihtout any formating) in access then it returns the time with no date. When I use that query in the vb.net code then Date is inserted.

I can...

Ajay Bathija · Apr 13 '07, 08:32 PM

Mary, thanks for the Single quote information.
I tried the Cdate technique, it inserted the Date (12/30/1899 9:00 AM)...

Ajay Bathija · Apr 13 '07, 06:50 PM

Mary:

Thanks for the help. I highly appreciate it.

You said:

First, I hoping that I am not missing anything, the only change you suggested was in "Myquery".

I tried using the code that you provided, but vb.net would not accept it, as it was getting confused in the "s being used.

Hence I tried the following:

Code:

myQuery = "SELECT format(Tb1.StartTime,"

...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

How to Separate Time from Date