Search results for query: *

Hi Thanks JerryKlmns you were right. I ran the SQL in Access and found some errors such as the auto number Primary Key in one Table cannot be a auto number primary key with the same name in two tables even if one is a joint primary key (should be "number"). After a little work i got the...

Hi Guys, I would be grateful for some help on a 2 problems i have. I am using VB6, ADO, Access 1)I have a Transaction Form with a datagrid for entering details of orders received. I am having problems opening the recordset.I get a "type mismatch in expression error". I am getting data from...

Thanks for your reply cbsm. Sorry i did not get back earlier.The second grid is not bound (but i have no problem it with it being bound). If it was bound, can you give me an idea of the Insert syntax as i am at a lost of how to do it. By the way the second grid is being used to collect all the...

Hi Bob Thank you for your answer. It looks like exactly what i was after and i will get back to you later after trying it. Cheers again.

Thank you Bob for your reply. 1)Your assumption was correct. But i was uncertain about the syntax required. 2)I dont fully understand your second solution. Why would you create a sixth and how would you "set it equal to whichever of the 5 that suits whenever you like". 3) Cheers for your...

Hi Guys, I have a large table in a database.I would like to populate a datagrid so that rows can be selected by scrolling. This would be too large. I therefore have 5 option buttons for which i will create 5 recordset that i need to load into a datagrid depending on selection. I am doing this...

Hi Guys, i am doing a project which involves the user double clicking on a row on a datagrid on one form and this action populate the next empty row in another datagrid in another form with that data. I also need the row on the new form to have one cell empty so i can put a quantity in there. I...

Thanks Golom! I Didn't realise that i had not done it. It is now working. Cheers also to johnwm and tonioJ.

Hi johnwm, Thanks for your quick reply. This has worked. But i now get an error on the next line: rsDetail.Open strSQL, dbConnection, adOpenKeyset, adLockOptimistic, adCmdText The error is "Arguments is of the wrong type, out of acceptable range ,or are in conflict with one...

Hi tonioJ, Thanks for your previous answer. I tried it but kept getting a syntax error in the frmDetails: (Form1.PKVar & "'"). Can you look at my code and tell me where i am going wrong please. I know my code is a bit long winded but it helps me understand whats going on. Cheers...

Hi tonioJ, Thanks for your reply. i understood what you have written and it looks correct. I will try it later and get back to you. Much appreciated. Cheers!!

Hi Guys, I am new to VB database and need your help. I am creating a small customer and product database. After populating a datagrid with, say, customers name and address, i would like to doubleclick on a particular name and open up a form with more details of this particular customer...

Thanks for your replies guys.I understand a little bit more.

Hi Guys, I am just learning about designing relational databases. I am on Functional Dependency. I understand some of it but when i come to certain scenarios i am lost. Can anyone explain it in layman terms or suggest a good site / tutorial / book. Cheers!

BDC2-Thanks for your answer. I will try it later today. DRJ478- Thanks also for your answer.I dont fully understand template class but i will investigate it and try it. Thanks both!

Thanks sleipnir, I tried that but only the first row appeared in the table. I think you are right but i think there is some sort of loop and i dont know how to do that.

hi guys i am a newbie at PHP. I have written a query to show the content of a table in MySQL. The ouput is correct but i would like it to look neater. I have tried using tables but i can only get it to display the first row in the table. This probably sounds simple to you guys but bear with me...

Thanks for your thoughts guys i'll go through them later and change a few things you suggested.

This is my first effort. Please review design and content. I can take it! Thanks. http://famousframes.netfirms.com

You two guys are great!. i made a list of the images that loaded and noticed that all of them had a single name whilst those that had two or more didn,t load. Thank you for that. Regarding changing the size of the table, forgive my ignorance but do you mean the table width. I can only see...