Dim DisTest as Double = 2.5/100 DisTest= (Int((DisTest + 0.005) * 100)) / 100 The secret is in the 0.005. 0.001 + 0.005 = 0.006, * 100 = 0.6, int = 0, / 100 = 0.00 0.002 + 0.005 = 0.007, * 100 = 0.7, int = 0, / 100 = 0.00 0.003 + 0.005 = 0.008, * 100 = 0.8, int = 0, / 100 = 0.00 0.004 + 0.005 = 0.009, * 100 = 0.9, int = 0, / 100 = 0.00 0.005 + 0.005 = 0.010, * 100 = 1.0, int = 1, / 100 = 0.01 0.006 + 0.005 = 0.011, * 100 = 1.1, int = 1, / 100 = 0.01 0.007 + 0.005 = 0.012, * 100 = 1.2, int = 1, / 100 = 0.01 0.008 + 0.005 = 0.013, * 100 = 1.3, int = 1, / 100 = 0.01 0.009 + 0.005 = 0.014, * 100 = 1.4, int = 1, / 100 = 0.01 0.010 + 0.005 = 0.015, * 100 = 1.5, int = 1, / 100 = 0.01 etc Also, I don't use "Round" because I can never remember from language to language how it works (round up? round down? round on .5?) If I want to round .005 down, .006 up (standard practise), I use 0.004 instead of 0.005

Another way to create an Access database without all of that hassle: If you know the basic structure of the Access Database, then you create the basic 'template' in Access and then embed the database into your application. Then through the use of File.IO and Reflection you can stream the template to a local file for alteration. (It is simpler than it may sound). Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my Blog

I've had a similar issue and was only able to get around it with a rather complicated work around. It has to do with the database you designed the report with no longer being located in the same file structure as it was during design time...which is NEVER once you've deployed it and the report is being run on your client's machine. I got past the issue by including an access database that contained the same table and field structures as I used during design of my crystal report. Then, before I set the report documents datasource or the crystal viewer's ReportSource property, I do the following: 'My schema database has been downloaded to the CurrentUserApplicationData folder via ClickOnce publish settings Dim strSchemaPath As String = My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData & System.IO.Path.DirectorySeparatorChar & "SchemaDB.mdb" 'This will set the login info to the schema DB, even though it has no passwords set, so the login screen will not display cdReportDocument.DataSourceConnections.Item(0).SetConnection(strSchemaPath, "", False) This workaround seems very silly, and requires the user to download a good sized file when they really shouldn't have to. But I've posted this question in several forums and no one has been able to help me with a better fix. If you find anything better please let me know.

Thank you very much Noctris, I will give that a shot. But most importantly I will remember this advice. In this case the text boxes are masked and only accept numeric characters, no symbols at all (not even positive/negative). But thanks again for helping you do a great job and it is much appreciated!!!

Thanks, that is exactly what I needed!

In very liberal psuedocode: OpenDatabase() ExecuteSQL("Update APCHK Set ColumnName = '" & TextBox2.Text & "' Where ColumnName = '" & TestBox1.Text & "'") CloseDatabase() Is that what you are trying to accomplish?

I would think you will have to rewrite the query in Access to duplicate the results, I would guess that DSum is an Access specific function that is no longer supported by the later version of DOA. And yes the forum is for VB and you are correct to ask the ? here, however it stikes me as invalid to move from 5 to 6 before moving to .net, a waste of resources. I just hope it is not so you can use the upgrade wizard to get the app into .net! Never underestimate the power of human stupidity RAH

Hi, To set a String with tabs, try the following code. Its a modified version of what Dave provided. Dim mainStr as String = "" Dim rowStr as String = "" For Each r As DataGridViewRow in DataGridView1.Rows rowStr = "" For Each c As DataGridViewCell in r If (c.ColumnIndex > 0) Then rowStr += ControlChars.Tab End If rowStr += c.Value.ToString() Next mainStr += rowStr + ControlChars.CrLf Next This code will produce the results as u wanted i.e. CCG3 wrote: Row1Value1(tab) Row1Value2(tab) Row1Value3 Row2Value1(tab) Row2Value2(tab) Row2Value3 Hope this helps to your expectations. Thanks Terry

What I have right now is the flag set to RemovePreviousVersion, and I set my MDB's Permanent property to true. And anytime I do an updated build, I have to change the Version. Then when they install, it will see the other version, un-install it, but leave the MDB alone, and then reinstall. Does anyone else know of a better solution for updates using the Setup Project feature?

Hi, SELECT MAX(PatSurgEnNo) as "MaxNo" FROM TableName; ... but you still need to worry about the multi-user changes. hope this helps :) NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...

CCG3 wrote: f so, then can you show me an example of how this can be done with a formula field? Nope. I don't have any example because I don't use Crystal Reports. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

:-D A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

CCG3 wrote: I am just working to modify it and change the way that some things show What to show and in which way you want?? CCG3 wrote: I am connecting straight to the database if your work demands showing just full content of a table you can straightway do this..Otherwise if you have some specific query then you have to go for a typed Dataset(.xsd) to do this....populate the dataset with your query....make the Datasource of your report object to that Dataset..... Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

That is EXACTLY what I needed. Thanks CleaKO!!

CCG3 wrote: DT.Load(SQL) The Load method is looking for a DataReader as a parameter and you gave it a string. The ExecuteReader method returns a DataReader object, which you just ignored and dropped. This code should read: Connection.Open() Dim Command As New OleDbCommand(SQL, Connection) Dim dr As DataReader dr = Command.ExecuteReader() DT.Load(dr) But, like I said before, another alternative would be to use an SQL UPDATE statement, where you would need to load this stuff into a temp table. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

If you used parameterized queries, you wouldn't have to worrdy about things like making sure the date is in the correct format, or if the # characters are in the correct place, or escaping other data in your parameters, ... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Answered in another post, but for other users with a similar problem # signs need to be around dates. Other rules for access sql text: dates should be the date with pound signs ex. #08/25/06# boolean should be true or false (no quotes) ex. true numbers should be just the number(no quotes) ex. 25 text is enclosed in single quotes ex. 'Test' topcoderjax - Remember, Google is your friend.

You said in your description you have two tables. But, this operation you're describing is only working on one table. Which is it? Shouldn't the WHERE clause lok like this: SELECT COUNT(OrderName) As ExistingRecords FROM OrdersListBoxInfo WHERE OrderName=? I also don't like using AddWithValue. It leaves too much up to interpretation by the OleDbParameter class. I'd do it like this instead: cmd.Parameters.Add("@OrderName", OleDbType.VarChar, 50).Value = OrderName You might also want to validate what's in OrderName before you assign the value to the parameter. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007