Date Time Picker + Database - Visual Basic 4 / 5 / 6

Adrian Parker

Hello all. I have a Access database which I read records from. All the
records read fine, except the Date/Time field of the database is not being
properly assigned to my Date-Time-Picker control in my VB code.

I've tried setting the datasource and fields with both code, and by using
the Adodc control (and setting the DTP control datasource, datafield, and
dataformat properties via the VB interface). All I get is an error 545
code, along with "Unable to bind with field or Datamember: 'Date Planted'

[Date Planted] is the correct field name, spelled exactly as it is in the
database. The database and table are opening fine, because I can read all
the other fields from the table.

I checked google.ca, I didn't see any useful mention of it there.
<Ade
--
Adrian Parker. Ordained priest. <ad***********@sympatico.ca>
Want to know the purpose of life? I'd be happy to share it with you...

Jul 17 '05 #1

Subscribe Post Reply

5453

frankcea

I had this problem. It only happens when Checkbox is False and the recordset is empty. The rest of the time it works fine.

Sep 15 '05 #2

Similar topics

Date Time Picker and empty databases

by: Adrian Parker | last post by:

Hi. I have a date time picker in my program which uses ADO to read from an Access database. It works perfectly, unless the database is empty (no records) when opened. When you try to open an...

Visual Basic 4 / 5 / 6

TypeOf and Date Time Picker control

by: TD | last post by:

This code doesn't work. Every posting I can find suggests that it should. If TypeOf controlname Is DTPicker then do something here End If I am using the Date Time Picker control and wish to...

Microsoft Access / VBA

Date Time Picker Question

by: XmlAdoNewbie | last post by:

Hi All, I am wondering if it is possible to allow nulls or empty strings when it comes to the datetimepicker control. I have an app with a few datetimepickers on it and there are some instances...

C# / C Sharp

Date Time Pickers...

by: Need Helps | last post by:

The example given in msdn.com on how to create a Date Time Picker involves using the CreateWindowEx function. However, I created a dialog box using the graphical interface, and then used the...

.NET Framework

Date and Time

by: Michael Turner | last post by:

Hi Guys I have two DateTime pickers one shows the Date and the other the time, this is a requirement of the solution. The problem I have is that when the time is saved to the sql database into a...

Visual Basic .NET

VB05 Express Date/Time Picker control

by: Darhl Thomason | last post by:

I'm converting my Access 2003 VBA app. I have a number of date fields in my db that I want to use the date/time picker control with, but if there is no entry in my database, I want the date/time...

Visual Basic .NET

MySQL date, and time entry issues.

by: dylan | last post by:

Hi, Just a few quick questions about date and time entry using html. What are the preferred methods of entering time data into a database. Eg, using two drop-down lists. And also, can...

PHP

date time picker and validate event ( is this a bug ? )

by: Michel Posseth [MCP] | last post by:

I have a problem with the date time picker validate event wich i believe is a bug How to reproduce : throw on a form a date time picker control and a textbox control select the validating...

Visual Basic .NET

error with date and time picker control?

by: fredloh | last post by:

i have a tab control on my form. i then have several microsoft date and time picker control on the tab control. when i select a date on any of the date and time picker control, the result of the...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing