I am trying to insert a date into sql Server 2000.
I am using the INSERT...VALUES in an SQL statement with VB, But I keep getting the message that SQL cannot convert char to smalldate.
This is hacking me off!!
This is an example of code that does not work -
INSERT INTO someTable(cName, cDate)...
I have an Access 2000 database which also has links into Sage. The application works with no faults under the full version of Access but when it is packaged & deployed in runtime it periodically ceases in two places. The coding behind the two forms is fine, the code simply checks that certain...
It's an Access 2000 database and I've set the date format
to dd/mm/yyyy and the default to Date() in the relevant table.
The references I have included are 1. Visual Basic for Applications, 2. Microsoft Access 9.0 Object Library &
3. Microsoft DAO 3.6 Object Library.
I will try the...
okay, what about this one then....
I have a data entry form on which one of the fields is a date defaulting to todays date, ie date(). The form adds the appropriate record fine on my PC but when the application is packaged into runtime & loaded onto a target PC the date converts itself to...
Cheers for responding Gary, if you have the code it would be great if you could e-mail a copy to me (awykes@ntlworld.com) otherwise any help you can give me.
Calling all 'clever dicks' out there...
I have a front end which is linked to the back end via the path set in 'linked table manager'.
Anyone know of a procedure to allow the end user (who will be using an MDE version of the front end) change the path of the database as and when required...
Just in case anyone reads this thread to the end and if you are still interested in the solution, I found the answer myself....
Public frmCurrentForm as Form
Set frmCurrentForm=Me.ActiveForm
It's only easy if you know it (as Chris Tarrant might say!)
Cheers Larry, works a treat!.... one more thing if I may.
I want to store this code in a module and call it from any open form that has the focus, is there a quick method of finding out which open form has the focus?
I've done it in the past by storing the form's name in a public variable...
I'd heard that it is bad practise not to enforce referential integrity when adding relationships to tables. If this is so how do you get around the following scenario without setting up a dummy record in the Suppliers table??
eg You may have orders that require a record in a supplier's table...
Can anyone help with some code that I can store in a module for use by all forms in my database that require Move First & Move Last navigation buttons. Basically when the user clicks on the Move First or Move Last button when they are already at the first or last record I want to be able to...
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.