Hi folks,
I am using an Access database, VB.NET and ADO.NET working with a DataGrid
control.
MY datagrid table has both a date_sent and a date_ans field. When I Insert
a record in my SQL statement, I insert a date_sent but I need to insert a
blank date_ans field. date_sent is the date when a question was sent to a
group from a web form and date_ans is the date when a question was answered.
I need to have the datagrid initially show the date_ans field with a date
shown and with the date_sent field having nothing shown. The date_ans field
is later filled in with an UPDATE statement.
I can put in a date into the date_ans field from my INSERT statement but it
is confusing to the user and will be bogus information but a valid date is
the only thing my query function, which passes the date_ans as a parameter,
as being acceptable.
I need to somehow find a way to have the app recognize a date as being a
valid date which shows up as an empty value in the date_ans field.
Thanks for any insight on this. 1 3088
post some snippet of what you are trying to achieve.
Patrick
"glenn" <gl***@discussi ons.microsoft.c om> wrote in message
news:BB******** *************** ***********@mic rosoft.com... Hi folks,
I am using an Access database, VB.NET and ADO.NET working with a DataGrid control.
MY datagrid table has both a date_sent and a date_ans field. When I Insert a record in my SQL statement, I insert a date_sent but I need to insert a blank date_ans field. date_sent is the date when a question was sent to a group from a web form and date_ans is the date when a question was answered.
I need to have the datagrid initially show the date_ans field with a date shown and with the date_sent field having nothing shown. The date_ans field is later filled in with an UPDATE statement.
I can put in a date into the date_ans field from my INSERT statement but it is confusing to the user and will be bogus information but a valid date is the only thing my query function, which passes the date_ans as a parameter, as being acceptable.
I need to somehow find a way to have the app recognize a date as being a valid date which shows up as an empty value in the date_ans field.
Thanks for any insight on this. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: newbie_mw |
last post by:
Seems my post was buried in more cries for help :-) I will try again.
It's probably a very novice question so please take a look! Thanks!
-----------------------------------------------------------------
I created a sign-up sheet (reg.html) where people fill in their first
name, last name, email, etc. The data are then sent to a PHP script
(reg.php). The data are then inserted into a table (reg) in MS SQL
server. I have declared the...
|
by: ms |
last post by:
I am running an insert statement from a dbf file and there is one record causing
the insert to fail. A msg. is returned stating it is due to an invalid
datatype. There are 2 text fields, 2 numeric(double), and one date/time. I
assume it is one of the numeric or the date/time field. How can I determine the
culprit record?
There is one key field which is one of the text fields.
I am trying to write a JOIN query but have not been...
|
by: Kathy Burke |
last post by:
Ugh. I'm using the following in an asp.net. I get an Syntax Error in
INSERT INTO Statement on line Cmd1.ExecuteNonQuery().
I've made all my database fields text (just to eliminate that as a
potential problem). I changed all my variables in the insert statement
to text to test as shown below. Still getting the error! I've checked
again and again my db table and field names. Could someone please tell
me where to go from here??? THANKS,...
|
by: Tim::.. |
last post by:
Can someone please tell me why I keep getting the following error from the
code below!
Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint
'FK_tblOfficePageContent_tblPageContent'. The conflict occurred in database
'CPNCMS', table 'tblPageContent', column 'pageID'. The statement has been
terminated.
I cant seem to see why I keep getting an error when I do the insert!
|
by: sm |
last post by:
Hi All,
Can anybody give me the syntax to insert a record into SQL server through VB
code using variables?
The following statement is failing!
sInsertQuery = "INSERT INTO TestTab (Col1, Col2, Col3, Col4) Values(" & _
str1 & "," & dt1 & "," & str2 & "," & str3 & ")"
where str1 = "col1"
| |
by: Geoffrey KRETZ |
last post by:
Hello,
I'm wondering if the following behaviour is the correct one for
PostGreSQL (7.4 on UNIX).
I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching
the following request :
INSERT INTO temp_tab VALUES (1,2,3)
|
by: Dave |
last post by:
I have an old web app that ues an Access database and ASP 3.0.
I need to build an INSERT statement based on the contents of a form.
What is the best way to handle blank text boxes that are submitted with the
form?
For example, I collect all my name/value pairs that are submitted with the
form like this...
|
by: javedna |
last post by:
Can PHP help with the following as I have tried in the MYSQL Forums and cant get any help
Thanks
Nabz
----------------------------------------
Hi I am developing a PHP MYSQL questionnaire tool.
The problem I am having is that of inserting all the answers into the table. The questionnaire is Dynamic so the number of questions can vary. I have a variable that counts them so at the moment there is 75 questions.
|
by: Blake Rice |
last post by:
Hi everyone! This is my first time posting here, so here goes.
THE SITUATION:
I have a form that has a start date, end date, project number, and total volume. These values are pulled from another form. Then depending on the difference between the start and end dates, that number of text boxes have their visibility set to TRUE and are displayed on the form. The user then enters volumes for each of the months between the start date and end...
|
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:
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |