Recent content by Giovaanni

Has anyone linked an autocad drawing inside of an Access form via VBA and database parameters? I'm a window manufacturer and would like to integrate on the fly autocad drawings to scale of products ordered as they are being typed in. Has anyone had any experience running autocad through MS...

Hi, well the method would have worked for me I just wanted to remove the decimal value of the number but I accomplished the same thing by running a CAST on it and changing it from a decimal to an integer. Mark.

Well ROUND(field,0,1) is supposed to truncate but it doesn't, at least I can't make it work. I have had success in access using FIX(number) to truncate the value but I need to get it working inside of SQL Server so I can do some calculations on the server side instead of on the Access client.

Hi, I saw an example of this in the books online for SQL Server and I'm not getting it to work. I'm trying to truncate the number right at the decimal point (no rounding just lop it off). It's coming back at me as having the wrong number of arguments when they do it in the example just fine...

This was remedied by eliminating spaces from the database name. Problem solved :)

Hi, I'm setting up a view and in design view I add a table. When it comes up graphically it only shows the (* all columns) in the table and no other column names for that table regardless of how many it has. When I do the same thing on the Northwind sample Database I can see all the columns...