Posts by debasisdas

Hi Sandy,

Welcome to Daniweb.

On Error Resume Next----is evil, especially in the context of log in screens.

"select count(*) from login where username = ' " & Text1.Text & " ' and password = '" & Text2.Text &"'"

if count returns 1 proceed further and go to the next screen else re-prompt for login credentials.

A cursor controls the navigation of records in a recordset and how the records will be updated

adOpenForwardOnly - this is the default cursor if no other is specified. This cursor allows only forward movement through a recordset

adOpenKeyset - this cursor supports forwards as well as backwards navigation. It also allows you to update a recordset and all changes will be reflected in other users recordsets. The cursor also supports bookmarking

adOpenDynamic - this cursor supports forward and backward navigation but bookmarks may not be supported (ie Access). Any changes made to data are immediately visible with no need to resynchronise the cursor with the database

adOpenStatic - this cursor uses a static copy of data from the database and therefore no changes to the data are visible and supports forward and backward navigation

With the information provided by you, i can only suggest you to read books for all the details.

getting auto-incremented, how ?

check if they are getting auto-incremented or not .

You are not inserting the Id columns (authorID, publisherID,..............) into any of the tables.

check your insert statements.

change the last line to the following.

& textDateTime & "','mm/dd/yyyy hh24:mi:ss')",'" &  ComboBox1.Text.TRIM & "')"

did you follow the steps as suggested by urtrivedi ?

I think the values in the column UpperBound & LowerBound are reversed.

Regarding your SQL, why not use between operator.

may be you need to fix the part between the date and combo field.

change line # 9 to following and try.

rs.Open str, conn, adOpenStatic, adLockOptimistic

post only the SQL insert statement.

Can i have your table structure and some sample data please, that will really help understand your question better.

Can you print the SQL statement and post over here. (only the SQL not .net code)

Hi sunny,

Welcome to Daniweb.

what about passing more info .

......I am in charge of Administration on days the other IT guys are not available.

Is it that you work on weekends only when no one works and no one is available :?:

That did not answer my question.

I don't open rapidshare for any coding not do i send solutions by mail.

I really do not understand your code.

can you please explain line #4 and #5 .

1. You can create a view based on the records of the JOIN between the relevant tables for the purpose of search.
2. While updating you need to update only one master table by pulling / selecting record from the above mentioned view.

it is Plan1 or Plna1

Yes, that's what school kids do.

All Apprenticeship jobs are like that only.

I want all records to display.

Then why you need to use GROUP BY clause in the SQL ?

Why not use a dynamic parametrized dynamic SQL to handle the requirement.

authorID in the books table is the foreign key in Books table which refers to the primary key of the Author table.

Welcome to Daniweb.

since you are using GROUP BY clause , you need to use some grouping function as part of the select list.

You can try to use Base64 encoding.

Try this.

What is a GIS project ?

What kind of data you are going to store in the DB ?

What is the front end application /language you are using / planning to use ?

Does that job pays you enough ?

Don't break anyone's heart... you'll regret it later.

How do you convert data in data report to the formats mentioned by you ?

Hi harry,

Welcome to Daniweb.

in what format ?

Hi johnn,

Welcome to Daniweb.

Hi nanvy,

Welcome to Daniweb.

Hi
Welcome to the forum.

check for the New Posts link on the status bar.

You may need to use 3rd party control.

also try reading this and this.

824

824

What i was trying to explain you is you need to show us here what you have done so far and where you are struck. We need to understand what exactly is the problem to slove it.

824

No.

I did not open a free code writing shop.

You need to show some effort to get any help here.

826

826

Write a program that will ask ..........

I have written the programme. :)
What next ?

826