Hi!
I don't know how u have managed to assign the client number to a variable. but here is one way to do so.
when u execute the query using the Execute function, all the values retrieved are as a...

Use Form_KeyDown event


Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
'make sure KeyPreview is True on Form Properties
On Error Resume Next
Select Case KeyCode
Case...

http://www.daniweb.com/forums/thread160872.html

Check the following thread. I have written some code. May be of some help. If not then u may post back for further requirement stating some sample data....

Try following links. u will get some idea of storing images in a SQL Server table.
http://www.codersource.net/csharp_read_write_images_database.aspx
...

if badge_id column a numeric, then omit the quotation marks for '1234'

what is the error msg u r getting.

http://gamedev.digiapp.com/

http://www.vbforums.com/forumdisplay.php?f=63

Check out this thread.
http://www.daniweb.com/forums/thread138971.html

If you want to build some more graphical games then check out this link....

Insufficient Info provided.

Please post some sample data.
Say 5 records for each table.
and the desired result output.
I will try help u out with this. by the way, which db r u using? MS-Access or SQL Server or...

Regards...

to delete a row u have to use F9. I have assigned F9 for row Deletion.

I have already written the program such that u give the quantity and press enter it will automatically create a new row and go to the first column of the new row. If the quantity is zero then the new...

Run the project i HAVE sent u once.

Select your Product and press enter. the Qty column will be highlighted. again press enter to edit the quantity cell. a textbox will come in the place of the cell and u can enter your quantity there...

When this error shows up, without clicking the OK button,

Press Ctrl + (Break/Pause) button and debug each statement execution by pressing F8 key (executing one line at a time for each press of...

could not get what your idea or requirement. plz elaborate with some example.

Use some other notation for those dummy fields like in the query which i had suggested in the last post.

Table2.tk2 AS sTK, '***' as sFATHER, -999 as sAGE, '***' as sPLACE

Here's the solution for your error problem.

rs.Open "Select PCODE from Product WHERE PCODE = '" & Trim(Text1.Text) & "'", cn, adOpenKeyset, adLockPessimistic
If rs.BOF = False Then
MsgBox "The Product Code is Already Exist!", vbCritical...

I think i identified ur problem. plz wait another 30 mins

Make
List1.itemData(List1.NewIndex) = QBColor(I)
as
lstProject_report.itemData(lstProject_report.NewIndex) = QBColor(I)

Ok. Send me the setup

Referring Grd if same as referring to the Current Cell which is active.
u can even write


Grd.TextMatrix(Grd.Row, Grd.Col) = FlexGridEditor.Value


When you press enter in the Product Id...

U can find solution in the following link.
http://www.vbforums.com/showpost.php?p=2172&postcount=4%3Cbr%20/%3E

'In MR Form Change the FieldName from UNIT to MaxOFUnit
'I already adviced u to have a look at the fieldnames which i have given
'In ur PARTDETAIL Query you have given
'MaxOfUnit as the Output...

Also please note down the entire error message and post it here along with the Module Name, Procedure Name, Error Number and Description.

Firstly, did u get any error msgs while adding those files to the project.

Then open Class Module Products.cls. Check out the Tablename and FieldNames which i have given are correct or not.

If...

sorry i could not upload the files yesterday. you might have waited hoping for my reply. sorry for the inconvenience. Actual problem was that my internet connection was down from yesterday night till...

Hi! I worked through the solution for nearly 5 hours. At last arrived at some sort of solution. i hope for the best that it will help u. I am uploading the ZIP File here.

NOTES ON USING THE SENT...

what is the Name property of your Command Object. is it rsCommand1 or only Command1

Try replacing rsCommand1 with Command1

ok. will get back to you by your time of 6:30pm

with reference to QVeen72 earlier post, if u have copied and pasted the code for the SQL Query then maybe the table name u have got wrong.


Select * From MyTable Where Fees Between ? And ?

...

Here it is 6:00 PM. I can work it out and give it 2 u in another 3-4 hrs.
By the way what is the time there now?

If you can do it with getting some help on DataGrid, u can try by the time.

FlexGrid is not editable Grid. you cannot edit MSFlexgrid/MSHFlexGrid directly. u have to use another TextBox control to display covering that cell and after data is input and validated in that text...

First initialize all text boxes from txt1 to txt7 = ""
Then get the data from table using a query for sum of Stunden for different Taetigkeit and populate the textboxes.


Private Sub...

where is PO.ZIP attachment. it is not here.

You must create a string such that it should append the values of the controls, not the control name.

INSERT INTO MyTable (Name, Age, chk_stat) VALUES ('" & txtName & "', '" & txtage & "', 0)