Recent content by Solomons

Thanks a lot tb. You too donutman.

Thanks tb, but that wasnt what I was looking for. I'm mostly try to figure out a query. e.g. Insert into Table (RowNum) select max (RowNum) from Table; Something to this effect (syntax may not be correct, but u get the picture). Only I need a system where a number is returned back to a calling...

Hi All, I'm trying to generate a column with unique values. Kinda like an autoincrement field only that the number is generated by a stored proc. Is using the datatime stamp the only way to do this? Is there any other way of doing this Thanks in Advance

Hi All, A particularly vexing problem. I've set an asp page to cache using the lines below Response.CacheControl = "Public" Response.Expires = 10 This page displays a table with 5-10 rows based on a db query. Selecting a row and clicking on a button Posts the data to a new page. But when I...

Hi All, Newbie at C++, Need a simple C++ CONSOLE APPLICATION example (I mean real simple not the normal C++ simple :) ) of using ADO .addnew method in a loop (call addnew multiple times i.e. insert multiple rows). Thanks in advance

Thanks a lot that was a really well explained answer :) But can this be improved any further? Joins are required over 3 tables and in some cases the data in the "Bridge" tables may be too few to really justify 3 tables. Can this be .. well denormalized?

What is the best design for a books-author database? This is a many to many (each book has many authors and each author can have many books) realationship. Thanks in advance

This line should be in one line, like below If (Not IsNull(Forms!frmqryECNMasterData100!Check140)) Then Think ur just cut pasting it to the module and this ends up being on two lines, which is why ur the statements are turning red. Regards Solomons

Thanx Paul, worked good.

Hi All, I have a footer for a group, in which the last object is a text box which retrieves comments. This comments field is a memo field so the text box has been set to can grow= yes, can shrink=yes. Now I want a date textbox to be printed just below the remarks. Since the textbox can grow it...

Whoops!!!! there was an empty label object under the name and id :P Thanx neways guys

Yup they are from the name and Id borders, but i expect to see that. The problem is the second row, where the name and id are not repeated (blank) but despite the blank value the gridlines for name and Id field still appear :( very very confusing indeed. I have started working on this project...

Hi All, I have a report in which a grouping is taking place. The values that are duplicate are to be hidden and only the unique values are to be displayed. ie. Id LastName Firstname Pet Food 12 XXX YYYY cat can dog bowl The values that i get are correct...

Thanks a lot

I'm planning on migrating an Access 97 DB to SQL Server 2000 but the front end will remain as Access 97. What I want to know is do I have to convert the queries in the RowSource property of the forms and reports to stored proc, or views or will they work as normal queries as they are right now...