Posts by debasisdas

That is because both the variables P_ID and P_NAME are IN type variables. So you cant asign value to a In type variable in a select into statment.

Please pass few more details . It is very difficult to suggest anything based on the very little info passed by you.

If you are not using the form itself to show the picture then trry to use a image control stretch the image and resize the control to the size of the form.

Kindly pass few more details .
What is the database that you are using and how you are conecting to database.

there is no problem with the query . You might need to change the join condition . Kindly post both of your tables structure for more details.

use
Me.Close()

on the button click event

instead of using 3 combo boxes use DTPicker control and then find out the .Date .Month .year property of the control.

Try this

select tf.time_id from tf where(((tf.rac_id= "'" fac_type & "') And ((" & tf.reserv_date)= " & booking-date & "))"

USER is a restricted key word. Most of the databases do not support any object by this name.

The keyword User might not be supported, check for that in the databse that u are using.

Your question is already replied in the other thread.

suppose in a table u store all the company names and in another table all there products.

now in the form load read all the company name name from table1. whwn u change the selection in the combo ,u need to execute the select command in database and select only the related products of the selected company only.

In this case you dont have to hardcode anything. and it does not matter howmany companies or how many products are there.

This is only go give you an idea .Hope that solves your problem.
If you still have doubts then please post back.

can u kindly post your table structures for my reference please.

Instead of going for all these hardcoding ,its always better to go for database connetion and fill the combo from database tables at runtime as per user selection.

I don't have any tutorial to explain all that.But i would suggest you to store all the data in database and select from there using SQL query and fill the remaining combo dynamically at runtime.

for that u need to add the itemsdynamically to the combo at runtime.

Please post what exactly is the error that you are facing.

Try to implement the logic by SQL

can u kindly mention what is the datbase u want to use.

^ finds mistakes easily.

^ great indian.

^ ready to dance now

^ a great human being.

use the followingto open the connection while using DSN

Conn.Open "DSN=mySystemDSN;" & "Uid=myUsername;" & "Pwd=myPassword"

You can easily do that using the functions SUBSTRING ,REPLACE etc.

^ seems to be in happy mode.

^ bright & dynamic.

^ chills others

^ is ready to accept what he is.

^ Understands people better.

^ loves to see blood all around

^ has an unique style .

please specify what exactly you want to display.

for that u need to handle the registry.

likes to praise others.

I does for DML opeartions. And status changes for DDL.

seems to be a good programmer.

Please post your question clearly , what exactly is your requirment.

Are yo sure the printer is not a network printer and the font of notepad is same every where.

Are you printing from the same system on which your code resides.

Are you printing from the same system on which your code resides.

Oh ....
Finally i got the much awaited answer........

thanx a lot for the same.

i though someone will answer , but........

Just asked out of curiosity.....

i would like to know what is the database that is being used at the backend, i guess it is oracle.

just crossed a milestone.

saying somthing nice to my Dude.

put the timer on the MDI forn using any container control and run the search code the timer_timer event at the interval you want.

before you develop your peoject and i suggest you anything my i know what are the programming languages that you know,which can be used as frontend . and as u said u will be studying oracle ,it means u also have few or no idea of oracle it self. In this conditions i am confused what to suggest you . One thing i can suggest to you is first go through the languages and database (oracle) . AFter taht you can develop any project you want.

oh god
that is the funniest think i have ever heard any one trying in my entire carrier.

dear EXE file are not created like you have tried(smart try) .You need to write some code and compile it to make an Executable.
someday you will also learn that.