|
from from front end vb 6.0 able to insert the date value into backend MSAccess table, having a single field with a datatype as date/time, using date picker control (project>components>slect file mscomct2.ocx), but i was unable to select a date from the same backend table, from vb 6.0 and received this error msg - "Data type mismatch in criteria expression" kindly provide with solution
regards,
sandeep
|
|
|
|
|
First up all
tell me what Control you are using to select a date from the database?
and also tell me what kind of technique u r using to get the date?
You Must Specify Your Problem Clearlly
VickyMD A Specialist in Message Digest Security
|
|
|
|
|
Hi friends, How do i get the date & time of the server in a client machine. I m using SQL server as backend and VB 6.0 as frontend tool. Pls help me in this regards. Thanks
arutperunjothi thaniperungarunai
|
|
|
|
|
There are Two Options for it
1)Synchronize the client while logging
2)Create DCOM, Run it on server. Create Object on Client
Write a method in DCOM Class to return Date and Time
i m telling u the technique to get the date and time from the Server
VickyMD A Specialist in Message Digest Security
|
|
|
|
|
Hi,
I have made a DLL in Visual C++, and have been using it in Visual Basic. Now after several updations of my DLL when i try to add the reference of my DLL again it gives a error box "Can't add a reference to the specified file". Now can any one please help me wut can be the problem.
I have created the DLL in Visual C++ using the MFC App Wizard (dll), and the strange thing is that once it was running ok but now it doesnt.. any clues? or further readings suggested?
Siddique Ahmed
Senior Software Engineer
Telelogix Software
(www.telelogix.com)
|
|
|
|
|
hi, i'm looking for an answer but i don't have anything...
i'm trying to make a exe like this:
the user types a value in the textbox and when he/she cliks in OK the exe generate ( make ) a file with that information in a directory. cool isn't it ? i´ve already written the code but i need know about the lib necessary !
" DLL entry point generate "
thanks !!!
|
|
|
|
|
silveiro wrote:
the user types a value in the textbox and when he/she cliks in OK the exe generate ( make ) a file with that information in a directory. cool isn't it ? i´ve already written the code but i need know about the lib necessary !
" DLL entry point generate "
Ummm...This doesn't make any sense what-so-ever.
What is the value for?
What kind of file is to be generated?
What directory, where?
What is the 'lib' your looking for supposed to do?
And what's with the comment "DLL entry point generate"?
Are you looking to generate a .DLL file for another app?
What's the app you generating for and what's this generated .DLL supposed to contain?
And to top it all off, are you using VB6 or VB.NET to do this?
RageInTheMachine9532
|
|
|
|
|
Hi! All,
I am creating simplified front-end in VB6/VB.NET, which allows very limited facilities to the user. It allows user to view drawings from different angles(3D Orbit), allows to fill surface with different colors or fill the surface with pictures. User is not suppose to have any other facility than this.
Now, I don't want use COM object application, as it opens another instance of Application which allows user to manipulate drawings in many different ways.
Is there any control (OCX) which allows user to preview drawings? or any other approach?
Suggestion is always welcomed.
Thanking You,
Ritesh.
|
|
|
|
|
The OCX you need can be found AT http://www.cadology.com
Regards,
Thunis
|
|
|
|
|
Hi All,
VB6 CallByName only seems to return a generic Error if one is thrown (ERR.DESCRIPTION : Invalid procedure call or argument). Is there someway of getting my specific custom error messages?
Thanks,
Davy
My Personal Blog - Homepage.
Scottish News - Angus Blog, Perth Blog and Dundee Blog
|
|
|
|
|
How are you generating your custom errors?
It's been a long time since I did VB6 so I may be wrong on this. But to generate a custom error, I think(!), you had to something like this:
Err.Raise vbObjectError+(your error number), (Source as String - optional), (Description as String - optional)
RageInTheMachine9532
|
|
|
|
|
Hi everyone;
Ok, I finished my application using SQL 2000 server. But when I install in other machine and startup the application a error occur "Login Failed For user 'JLMACHINE\guest'".
I don't know why this error occur because in my machine works. please help me on that.
Johnny Lizardo.
|
|
|
|
|
There are couple of reason for this
1)make sure you connection string that your are passing is correct
My_Connection="Server=<servername>UID=<username>pwd=<password>database=<datrabasename>" i hope this will work out]
2)And if your application is accesing server which is another machine,make sure your netwokr is fine.
write your connection string in this format,which is easy,replace your code with this and build if once again,i hope it will work.
|
|
|
|
|
Hi,
I have a problem
I want to be able to detect the computers on my lan by a program I made
how can I?
can anybody help me in this?
BEES
|
|
|
|
|
Hi,
Answer To Printing from Right To Left To The Printer in VB.NET
Printing From Right To Left To The Printer in VB.NET
you can download a small example:
http://www.geocities.com/vmtnl/rtl.html
Have a nice day
From:
yulyos@yahoo.com
http://www.go.to/yulyos
|
|
|
|
|
How I prepare deployment package. Waoo I'm so lost. I finished my application, but now How Can I prepare a deployement package?.
Johnny Lizardo
|
|
|
|
|
well i think that you had not gone with all the tools which comes with the Visual Studio Package
there is one tool name Package and Deployment Wizard
You can use it
or else you can add the Package and Deployement control
and make your own deployment package
hope this will help you 
VickyMD Specialist in the Message Digest security
|
|
|
|
|
Hi
Thank that's help me.
Johnny Lizardo
|
|
|
|
|
Hi all,
I have developed an Vb.net application. I have prepared deployment package. But at the Target computer, when I install then it will create a problem related to keycodev2.dll “can not be registered”
Is vb.net framework necessary to install this application at client end. If it is then how can we install silently.
Please help me, I just want to give an single exe file e.g. Setup.exe (it contains exe file of program, .net framework)
Reply me as soon as possible
Mahesh Prajapati
|
|
|
|
|
In order to work your app on client machine , you would require .NET frame work ,that you need to be install seperately.That is available in microsoft site.just go and see in download side of the microsoft.well if you are using any crystal report in the application ,you must include some merge module along with your setup project.
thanxs
ask me if you face any problem
|
|
|
|
|
how do i make the backend database in sqlserver2000 appear on the frontend visual basic form
plz show me the connection code thank u
|
|
|
|
|
The simplest way would be to add an Adodc Control from your toolbox to your form, and build the ConnectionString using the wizard.
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
Support Bone
It's a weird Life
|
|
|
|
|
In order to retrevie data from backend SQL server....
You need to follow this step
1)first go to Project-References-select "Microsoft ActiveX data objects 2.1 library
2)then declare this value
Option Explicit
Dim con As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim Com As New ADODB.Command
Private Sub Form_Load()
con = New ADODB.Connection
ConString = "provider=sqloledb;uid=<server uid="">;pwd=<sql server="" password="">;Initial Catalog=<database>;Data Source=<server name="">"
con.open
Then you can write code for retreiving data..
make sure that you close connection each time when you open the connection.
End Sub
|
|
|
|
|
how do i make the back end database in sqlserver2000 appear in the front end on the visual basic form
plz let me know how the connectivity is to be done
|
|
|
|
|
Dim Con As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim Com As New ADODB.Command
Private Sub Form_Load()
with Con
.ConnectionString = "Data Provider=SQLOLEDB;
Provider=MSDATASHAPE;
uid=;pwd=;
Initial Catalog=dbname;
Server=server-name;"
.Open
end with
With Com
.ActiveConnection = Con
.CommandType = adCmdText
.CommandTimeout = 0 '//never time-out
.CommandText = "SELECT * FROM table-name"
End With
Rs.Open Com
Call Read '//sub defined below
End Sub
private sub Read()
Rs.MoveFirst
while not Rs.EOF
Print Rs!Field-name1 '//print to screen - whatever..
Print Rs!Field-name2
.
.
Print Rs!Field-namen
Rs.MoveNext
wend
end sub
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
