Posts by debasisdas

After all these posts, I see you are using vb.net

If one goes through this thread, it is quiet clear that the OP has never said what exactly he has really done. But he always pretended to do a lot while he actually did nothing. Nicely he framed his questions and made our expert do all the coding. Once the code is delivered he comes back complaining that it is not working.

Now the expert realises all his assumption was wrong (OP has posted some code from some where)and the actual coding was to be done in .NET not in VB6.

May be the expert now will start writing code again in .net and supply. But i am sure that will again not work for OP. Because s/he never understood the code (never bothered to do that), it is clear from previous posts.

@trilok31

Read line #6 of Jx_Man's code

try this sample

select count(*) from demo where user_name = u_name and password = pwd

if this SQL returns 1 log in successful and proceed further
else
re-prompt for username / password.

No need of any looping or checking for EOF.

Hi.
i detached the database and added it to my program as an existing item

What exactly you did ?

I visited this thread several times in last couple of days, but never had the patience to read 600 + lines of code.

May be i will visit this again in the weekend.

forget about PHP.

Post the SQL part of the code where you have any issue.

you are sure , not passing string value of more the length than permitted

ex--

string of length 12 where the column size is 10

you need to check if the MDB is in sync with the earlier version of database.

and ensure that you are passing proper data to the DB from application.

this is the code you have ?

but i can't see any code

try this

dim my_string as string

my_string = "your string goes here..."

if my_string = StrReverse(my_string) then
MsgBox ("This is palindrome!")
end if

If your problem is solved please mark this thread as solved.

Yes.

You can add a filed contact_type and store values like 1,2,3...
1--contact is doctors
2--contact is a nurse
3--contact is a pharmacist.....

etc

if you are moving form one text box to the other in a sequential order you need to code in the lost_focus event of the textbox.

how you ensure that user does not skip input to any of the 6 text boxes ?

why not add a command button to the form and add the code in command button click event

why not merge both address and contact, and add a flag to define the contact type .

1. find the position of the word that you are looking for.
2. find the position of the previous and next new line character.
3. delete / remove everything in between.

4. go to step 1

kindly post the code that you are working on.

How you determine CONTACT and ADDRESS belongs to whom ?

Don't you think both should be merged into a single one.

The statistics is very common for newbie posters.

As you keep contributing usefully to the community, you will keep moving up the ladder.

try this

SELECT posts.*, channels.channel 
FROM posts 
INNER JOIN channels 
ON posts.channel_id = channels.id 
WHERE  (posts.id=? OR posts.id=? )   ----better to use IN clause here.
ORDER BY posts.published DESC

yes , that is exactly how developers trouble shoot. :)

Why not create insert script using some tool (best in EXCEL) and insert the parent record and then the dependent child record.

What is the problem , i don't see anything wrong with the SQL.

Yes, it has to be done through SQL queries by placing some extra controls like a pair of combobox and textboxes on the form.

so what is the problem ?

are you facing any issue with the code ?

show some effort ans show the code that you are working on.

you need to insert a page break after each record.

@Dani:
great job.

I can only imagine how fast you cooked it. :D

You need to read this and this.

As i have already suggested, yuou may need to use some third party control.

In form laod

Combo1.AddItem rs("itemcode")
Combo1.Itemdata(Combo1.NewIndex) = rs("description")

on combo_click

text1.text = combo1.itemdata(combo1.ListIndex)

is that code not working for you ?

alternate method:

Use the item data property of the Combo Box.

populate the combo like this

Combo1.AddItem rs("itemcode")
Combo1.Itemdata(Combo1.NewIndex) = rs("description")

and display the Itemdata property in the textbox.

No, not in any grid directly as is as in Excel sheet.

I did n't mean to use horizontal scroll bar for actual display, just to set the value..

It is always better to design your own component for the purpose.

What about using the Horizontal scroll bar .

If you go through the very 1st post of this thread you will understand what code we are discussing here .

Here the code under discussion is Purely VB 6.0 only.

We are not going to .net and not trying to make that backward compatible.

But how you set the value of the boolean variables ?

Remove rs.Update from move methods.

that needs to be handled separately.

This is VB 6.0 code ?

Why can't you understand that since you are opening the same record set again and again on each click event of next and previous button you are always at the same record.

What you need to do is call the move methods of the recordset object that you have opened in the form load event.

when you select the combo
pass the code into another SQL and fetch the description and display in textbox.

value member and display member are not available in vb 6.

follow these steps.

1. populate the combo only (not the text box) from the recordset.

2. to populate the text --capture the value from combo and pass the same back to DB using SQL. Fetch the Description and display in a textbox.

You need to write a recursive function to find and delete all the files of specific format.

Kindly post the code that you are working on currently.

what about implement the filter at DB level through SQL by generating and executing queries dynamically at run time.

may be i will read this LONG question in weekends.

Is your data getting updated into the DB before yo invoke the report ?

Do you refresh the recordset once the data is updaetd in the DB ?

and finally what is database 2010 ? Is it MS Access 2010 ?

Report , what report ?
Where you enter data ?
Is that connected to database ?
What database ?
How the report gets populated ?

?
??
???