Search results for query: *

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...

Hi All, Is there any way to Archive reports so that they dont add to the file size of the mdb file? I have a reports with names like rptSummary20030127 rptSummary20030112 rptSummary20020916 The numbers at the end is the date in yyyymmdd format. They are the same report but the text of these...

Hi All, I'm working on porting an Access 97 Database to SQL Server. The front end will still remain in Access but the data will be moving to SQL server. There's the background now I'm having a little problem understanding DISTINCTROW. I know that in a select statement it gives me ROWS that are...

Thanks a lot Paul that did the trick ..love this place

Hi Paul, Thanx but I'm not looking for whole days. I would really have preferred to display the field as xx days and xx hrs but i'm ready to settle for xx.xx days for now. Have work out some complicated way to get accurate count of days and hours later. btw Format() function seems to work for me...

Hi All, I'm having a similar problem. I'm using an SQL query in the record source like, "Select Sum(markedhours)/24 as MarkedDays From tblMarked where uid='xxxxx'" How Do I round the values here??? I'm using access 97 and cant seem to find a round function. Thanx in Advance Solomons