Hello everyone!!!
I have a problem in retrieving starttime and the endtime values. Can anyone help me to solve this problem? Here's my sample codes: -
-
'==================
-
from frmSchedules
-
'==================
-
-
SetConnection
-
CheckConnection rs
-
rs.Open "Select * From LoadSchedules Where ScheduleID='" & ID & "'", _
-
adConnection, 1, 1
-
With ScheduleEntry
-
.txtScheduleID.text = rs!ScheduleID
-
.txtCourse.text = rs!Courses
-
.txtSection.text = rs!Sections
-
.txtSemester.text = rs!Semester
-
.cboSubjectCode.text = rs!SubjectCode
-
.txtDescription.text = rs!Description
-
.cboRoom.text = rs!Rooms
-
.cboDay.text = rs!Days
-
.cboStartTime.text = rs!StartTime '<-----Run Time error '383'
-
.cboEndTime.text = rs!EndTime '<-----Run Time error '383'
-
.Show 1
-
End With
-
-
'==================
-
from frmScheduleEntry
-
'adding items to the starttime and endtime comboboxes
-
'==================
-
-
Sub LoadStartTime()
-
Dim t As Date
-
Dim i As Integer
-
t = CDate("07:00:00")
-
Do
-
t = DateAdd("n", 30, t)
-
cboStartTime.AddItem Format(t, "h:mm AM/PM")
-
i = i + 1
-
Loop Until i >= 26
-
End Sub
-
-
Sub LoadEndTime()
-
Dim t As Date
-
Dim i As Integer
-
t = CDate("07:30:00")
-
Do
-
t = DateAdd("n", 30, t)
-
cboEndTime.AddItem Format(t, "h:mm AM/PM")
-
i = i + 1
-
Loop Until i >= 26
-
End Sub
-
I check the data of start time and the end time in the table and it matches with the items on the comboboxes. I don't know why this error occurred.
2 17790
HI..
i think that you trying to set Text property value in Combo Box control, then this error appear because you set Style property to "2" = DropDownList, this style disallow change of text property, you can change style to any other style, or instead if your data withing the combo box list you can use ListIndex property to select this item.
Best Regards
HI..
i think that you trying to set Text property value in Combo Box control, then this error appear because you set Style property to "2" = DropDownList, this style disallow change of text property, you can change style to any other style, or instead if your data withing the combo box list you can use ListIndex property to select this item.
Best Regards
Hi
I tried these codes to my other programs and it work. My combobox style property = 2 (DropDownList) and the items of the combobox was retrieved from the database. But now, the items from the combobox are adding during run time. Well, I guess I need to use the ListIndex Property
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Frederick Page |
last post by:
Hi everybody,
I'm trying to open Control Center for UDB 7.2, FP7 on a WinNT 4.0
machine, but it "silently" just crashes. db2diag.log shows strange
entries:
2004-02-02-16.36.59.809000 ...
|
by: Chris |
last post by:
I built small C# Web and Web Service applications in a
training class last week. The applications worked in the
class, but when I tried to run them again over the
weekend, they both bombed....
|
by: Glen |
last post by:
I'm working on a custom assembly and I'm trying to figure out the best
approach to handling known constraints within the assembly, once
compiled, to alert the developer at compile time of a...
|
by: Chris |
last post by:
I posted this in the C# language group, then thought it
might be more appropriate in this group. I would not
cross-post except I want the answer so badly.
I built small C# Web and Web Service...
|
by: |
last post by:
I have gotten the following error in trying to get totals to come out on a
footer.
Server Error in '/test' Application....
|
by: Alan Silver |
last post by:
Hello,
I'm trying to use an ArrayList to do data binding, but am getting an
error I don't understand. I posted this in another thread, but that was
all confused with various other problems,...
|
by: Ed Bick |
last post by:
Well, I read today about how I could set the dropdown value to False to
change the control from presenting a Calendar to cycling through the times.
Before getting that, I developed a custom Time...
|
by: phil.stollery |
last post by:
Hi,
I've currently setup a local user as described in:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT01.asp
This users has been created on the remote...
|
by: Phil |
last post by:
Hi,
I've currently setup a local user as described in:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnne...
|
by: Mack Bolan |
last post by:
Please can some one can help me resolve this bug?
Object variable or with block variable not set,
Option Explicit
Private mVehicles As CVehicles
Private mstrKey As String 'Holds...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
| |