Search results for query: *

You can use: Math.Pow(14,(1/33)) to get the result of 14^{1/33). There are also other math functions such as Math.Abs(..), Math.Sqrt(..) functions (methods of the class) in this Math class.

Hi,Sunnywink, The network instability is just my hunch based on the information I read somewhere before and the experience I had with one customer. This customer had 3-computer network. The database has information as to which computer (based on MS Access log-on name) was the last one using...

SunnyWink: After database corruption sometimes I saw duplicate records too even if it specifies as no dupicate. In fact, the primary key mark was gone after the corruption. I had to delete the duplicate records first before setting the primary key again. I wonder if this is from the network...

I assume you have used total queries to get these aggregate total amounts for expense and budget. This is handy if you have two or more lines of records for any given months. You can use a union query (use SQL statement) to joint these two queries into one, called "UnionExpenseBudget&quot...

Thank you all for your input. The read-only data files have about 50 MB or so each. They are served almost like a dictionary. I would think if each desktop has a dictionary it would be easier for everybody. But from what you people told me it is still faster if the data files are in the remote...

Hi, All: MS Access ADP as a front end will access data in SQL Server (presumably a different computer in the network). I have several big data files (fixed, read-only, lookup tables, not to be edited) such as comprehensive tax table, medical dictionary codes, etc. For speed I feel I should...

You can create a public function like Public Function GetCost(MyTime as date, MyDuration as integer) as currency 'The data types should be identical to table fields'. Select Case MyTime Case #7:00:00 AM# To #8:49:59 AM# If MyDuration = 15 Then...

I agree autonumber doesn't apply here. I would also suggest that the table to store the number should have two fields: MyIndexNumber and MyIndexDate. If you find the record's MyIndexNumber field value is 5 but MyIndexDate is not today, I would set NumberFromRecord = 1 and MyIndexNumber will be...

Try '07/28/2003' instead of '28/07/2003'. Also check your computer's region/language setting. Some countries use mm/dd/yyyy while others may use dd/mm/yyyy or yyyy-mm-dd.

I've found the solution for problem one about retrieving data from MS Access database. It's trial and error thing. Not so sure about the logic behind it but it works. Original code: string source = "Provider=Microsoft.Jet.OLEDB.4.0;" + "User ID=Admin;Password=;" +...

Thanks, LV Your tips are very helpful. I'll remember to write error handling routine. After I added Read() and revised to the following it worked. This solved my second question. Regarding the first question, I still couldn't understand why I couldn't get to MS Access database. Any suggestion...

I've tried a way similar to yours like rdr[0].ToString(). It failed. It looks to me that I simply could not get to the database files in MS Access database or SQL database.

I have a hard time accessing data from SQL and MS Acess database using c#. Please help. My XP computer has MS Access 10 (XP) installed with no logon password and it also has MS SQL 7.0 client (personal) edition installed. The following is the c# code to get the MS Access table. The table has one...