Recent content by ennrike

Thanks for the info Gina, But I am using a C# application that uses that database, but occasionally I need to enter to the file and made modifications like adding a new column to a certain table, actually I am suppose to be the only person authorized to do that, however, someone may opened it...

Hello, I have an access file in the shared folder in the intranet, some guy opened and I think he tried to design something, so that, the file is exclusively opened somewhere in the office, there are a lot of computers, so I don't know who is this guy, but the file is like that since yesterday...

Hello, I have an small application C# that uses an Access2003 file that is in a network folder location. We have been using Windows XP with this application and everything was fine. However, we got new computers with WindowsVista the application runs fine in those computers with Vista, but...

I could not paste the image. Two lines come out from Table1. One line for Table2 and other one for Table3, there is a "1" for Table1 and there is a infinity symbol for Table2 and Table3 and the end of the lines. So that, the main Table is Table1 where ODT is the primary Key nor repeatable and...

Sorry my friend I have made the corrections, if you reload the page ...

Here it is the complete query, some notation may not have sense for you but the database was already created when I started to work with it. Table1, Table2 and Table3 has a common relationship called "ODT" (WorkOrder), but Table3 has a column called "TDate". I want to show the ODTs that are in...

Actually I am doing it like that, that's why I am saying that still can see in the SELECTION query some records with DATE >= 2010 when should I be getting only DATE < 2010

Thanks, actually I have been trying that feature but I have a more complex situation now, I would like also to limit my query using a second column in Table2 that has the Date where the WorkOrder was started. I would like also to narrow down my result to those WorkOrders that started before...

Hi, I have a Table1 and Table2. They have a relationship with the column "WorkOrder". Table1 has all "WorkOrders" and Table2 has most of them (but not all). I would like to delete from Table1 the "WorkOrders" that are not in Table2. I think it would be something like that but I am not sure...

By the way, I need to use also "TOP", I mean: SELECT TOP 50 WorkOrderNumber FROM MyTable WHERE HourPlan > 10 ORDER BY Date

Hi, I have a query for selection, for example: SELECT WorkOrderNumber FROM MyTable WHERE HourPlan > 10 Because I have duplicates of "WorkOrdersNumbers" in MyTable, the query gives me more than one row of a simgle "WorkOrdersNumbers", what should I add to the query to make sure it is only...

It looks that it only works for "integers" if I use doubles it does not work ...

The operation "HrsAct / HrsPlan" will calculate the percentage of overloaded working orders. The point here is that in the query I have an aritmetic operation that gives me an error if I do "4.5 / 0". The overload error. How can I handle this exception in a query? By the way HrsAct and...

Hi, I have a query where I am making an arithmetic operation: SELECT * FROM MyTable WHERE HrsAct / HrsPlan > 1 AND USER = "John" It works sometimes, the problem happen when HrsPlan = cero. I tried to do: SELECT * FROM MyTable WHERE HrsPlan > 0 AND HrsAct / HrsPlan > 1 AND USER = "John"...

Hi, I have two tables, TABLE1 that has a column "ORDER_NUMBER" (the primary key) and I have a second table TABLE2 that has also the column "ORDER_NUMBER" these two tables have relationship between using these two columns. However, I have "ORDER_NUMBER" entries in TABLE2 that has a special...