I have an application that is basically information capturing with reports. I compiled it into and MSI file which has successfully installed on OS's Windows 98 through to Vista. However...on my PC (Windows 7) when I tried to install it, it stopped near the end and produced this Error message...
I have an applcation that is basically information capturing with reports. I compiled it into and MSI file which has successfully installed on OS's Windows 98 through to Vista. However...on my PC (Windows 7) when I tried to install it, it stopped near the end and produced this Error message...
Yup. These are my tables - my very own creation. DOB is data type 'date'. Other fields are mostly text fields with one 'yes/no' and one 'number' field (in this specific table).
I know I can work around this problem by making the DOB field a text field and insert dates like "20090424" and then...
Yes - I have set breakpoints to follow what's happening all along the way. The error is generated immediately after the "datPD.recordset("DOB").value = Null" line.
Yes, I am updating a recordeset. The code is not that complex. See below. Only there are are about 16 fields bound to text-boxes to update.
datPD.recordset.edit
datPD.recordset("DOB").value = txtPD(6).text
datPD.recordset.update
I wanted to do the following:
datPD.recordset.edit
if...
Hi Guys
Perhaps my expression "drive home" is not good programming speak - but I really meant that I can't get the database DOB date field to accept a Null value when the textbox bound to that field is cleared. It does not respond at all to "" as well. The same kind of error (3426) is generated...
Hi Skip
Great answer - however, if a field is set as data type: Date - I can't see where one would set the field to accept Null values. Enlighten me, please.
Mike
Hi Addy
I guess I must be stupid. I have been working with Access 2003. Where do I set the table to allow Null values - in particular this date field? Is it the default value?
Regards
Mike
Hi all
Haven't been around for ages. I have a problem that nobody seems to know how to resolve. In VB I have a textbox bound to a date field in Acess. When I want to empty the textbox because the date is incorrect and anknown for the moment, I can't drive home a null value to the database...
Hi there lilboi. I have had a tremendous time working with a little app. call iconomaker. It is capable of all types of icons - including XP types. Give it a try: http://www.iconempire.com/free-icon-editor/
regards
Micash
Hi there
I've asked about this before, but got a fairly feeble response. Here's my query:
I have two machines hooked up in a 'home - style' network - a machine in each office from card to card using a UTP cable. Running Windows 98SE.
I want to know is there any capabilities within Outlook...
Hi out there!
I am just wanting to know if there is any capabilities within Outlook Express or Microsoft Outlook that could enable me to send a "pop-up" kind of message to another computer in a small workgroup (each running Windows 98SE). The idea would be to be able to send a message to the...
Hi there.
I have an app in VB6 and numerous reports. I am having no trouble doing formulas that involve basic records selection formulas in VB for crystal (records and groups). However I need help with a formula to show per person, events that exceed a determined amount.
Example: Peter takes 1...
Hi Guys
could someone help me with what might be quite a simple statement, but I am strggling with it.
I need to create a table that will populate with all the records that have two specified ID numbers.
I can do it to see a list of all records with one ID Number:
Example:
with datPeople...
Hi out there!
I wonder if you can help. I have an application that uses crystal reports quite extensively. Everything seems to work well. But I am trying a new thing (for me anyway). I want to suppress records (groups and details) where the summary for the main group is less than a USER DEFINED...
Hi there all. Another pain. I have lost my sound for games. I go to System Information and run the DirectX diagnostic tool. While it is loading up and getting whatever info it is getting, it is interrupted with this error message. This is how the message box looks:
In the titlebar:
"DxDiag...
This is a real pain. Everytime on startup, just when the desktop is loading and the various apps are being displayed in the taskbar on the right-hand side(active apps) - an error message pops up, and this is how the message box looks:
In the titlebar:
"Error"
the message:
"Cannot...
Hi all out there
I need a bit of help here - new problem
App written in VB6.0 Prof.
Uses Crystal Reps.v8 OCX
Access 97 DB
Visual Installer used to package.
Application deploys on eveything under 'normal' circumstances from Win95 to Win XP.
Latest User has installed on WinXP and this error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.