Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Titan5

    Need help with calculation!

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

    Access 2000 Database corruption

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

    Access 2000 Database corruption

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

    Bringing together two separate sets of data into one chart?

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

    Need to connect to local data files

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

    Need to connect to local data files

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

    calculating all records

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

    autonumber field format

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

    SQL Command Problem

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

    Inability to access database

    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=;" +...
  11. Titan5

    Inability to access database

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

    Inability to access database

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

    Inability to access 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...

Part and Inventory Search

Back
Top