debasisdas

Start reading and thinking you will get a lot of ideas.

Why not go for the Masked Edit Control instead of a regular textbox. That control allows you to set a predefined format, and also allows for validation on entry, instead of after entry.

before you jump into database or any coding the very first step is requirement analysis. 1. gather the requirement. 2. Plan a solution. 3. decide on front end/ database / system specs etc.. 4. Design the DB. 5. Design the application. 6. Test it for proper functionality 7. ..... 8. …

Blog and forum entries must and should be stored in separate tables.

[quote]the projet doesnt seem to exist yet on the web[/quote] then it must be the eighth wonder on the planet. May i know please what exactly is your idea ?

you simply need to use ASCII function and call the same in KEY_PRESS or KEY_DOWN event Show some effort before asking for code.

Please find all that [URL="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html"]here[/URL]. Download what ever is your requirement. Follow the manual for installation instructions.

i don't understand your logic of authentication. How [B]Select * from Users[/B] ensures that the user id exists and the password entered matches with that stored in DB ?

@Vineeth If a form is not visible (hidden), that does not mean the form is not loaded.

Remove Nurse_In_Charge from WARD and maintain a separate table for day to day activty of the ward. There you can maintain ward ward_id, nurse_id, date_of_activity etc.

Search in the net , you will get a lot of stuff.

1. SMS is not sent from e-mail 2. Before asking for code you need to show effort and post the code that you are working on. 3. Does you project included any database operation ? If yes -- which DB ? How you connect VB to DB ?

database changes ---------------- 1. Migrate table/views and data to Oracle. VB changes--assuming you are on ADO ----------------------------------- 1. Change connection string. 2. May need to take care of data types to make it compatible with Oracle.

Welcome to the forum.

What is not working ? Are you getting any error message ?

You need to mention the relation between the tables.

You need to mention which block of the code is causing the problem.

You need to use Db Link for the purpose.

Can you post a snap shot your UI here, just for reference.

You need to frame the query dynamically at run time and execute the same based on the combo value.

You need to create a new instance of the command button and reposition it every time by changing the X , Y co-ordinates. But may i know what is the requirement that make you drag the button around the form.

When talking about windows ask the guys who know it best, Microsoft. You need to stick to Microsoft technologies.

Hi Ryan, Welcome to Daniweb.

1. Mother board --- you must throw away. 2. RAM --- that is of no use. 3. Keep the hard drive --- you can store something there may be PM3. 4. and don't throw away the fan --- that will keep you cool.

Between is used on number or date data types not on string. ex 1. number between 1 to 10 2. date between 1-jan and 31-jan etc...

What the program is all about ? What language / development environment you are using ? Are you using any database ? ...........? .......?

Why name and address is stored in Computer table ? There should be a separate table for customer.

So, do you have a question ?

ToolTipText is display at the cursor. a better work around is to 1. use a label 2. change the caption 3. move it around as desired with controlled visibility.

You need to read [URL="http://www.google.co.in/search?hl=&q=using+list+view+in+visual+basic+6&sourceid=navclient-ff&rlz=1B3GGLL_enIN368IN369&ie=UTF-8#hl=en&pq=using%20list%20view%20in%20visual%20basic%206&xhr=t&q=listview+in+visual+basic+6.0&cp=0&pf=p&sclient=psy&rlz=1B3GGLL_enIN368IN369&source=hp&aq=0sx&aqi=&aql=&oq=list+view+in+visual+basic+6&pbx=1&fp=5cd426a8b99ed1de&bs=1"]this[/URL] .

As mentioned in the previous post you need to play with some properties of the control.

Try using specific column name in the select query instead of using [B]Select * [/B]

To connect to oracle database from any OS to windows system you need to have TSN file updated for the target DB. And for your information : TOAD is not a freeware, in fact it is one of the most costly tools for DB applications.

That may be delivered to you, if you are ready to pay for your assignment.

Try using IIF .

try this [code] Private Sub Cmdshutdown_Click() ExitWindows EWX_SHUTDOWN, &HFFFFFFFF End Sub [/code]

What exactly you mean by that ? Are you trying to copy items from one list view into another ?

What is the database that you are using ? How you connect to database ?

are you storing the actual password in database as is ?

Hi Paul, Welcome to Daniweb.

In your case ,all depends on how much you can afford to spend. and i don't think all versions of office is shipped with Access. You can look for something like MySQL.

I believe the best way to learn thing is by way of getting your hands dirty. Lets start and learn.

option 1 --------- A. read the file B. convert to binary stream C. store tin database (preferably in a LOB field) reverse the precess to display in your picture box. option 2 --------- A. store the path of the file. B. retrieve the path. C. read the file from file …

You need to use [URL="http://www.yes-tele.com/mscomm.html"]MSComm[/URL] Control.

You simply need to understand why your query failed. To compare, you need dates not strings.

Hi Jaskaran, Welcome to Daniweb.

App.path is not set in MDB file. you need to set that in your VB code ex-- ConnectionString = App.Path & "\MyDB.mdb"

A trigger is what you are looking for.

Welcome back.

No homework / assignment please.