Search results for query: *

table: sales field: manufacturing code Data inside manufacturing code: IM2, IM, SIS, SIS2, PASSO2, APC2, SeeFei2, SeeFei I want use the SQL to display the data with 2 at the back only. I know there is a stupid to do that, i.e. ....where ManufacturingCode= "IM2" or...

It was just a though because i believed i should put something mechanism to check this one in my future ms access database design. Thanks

Something very interesting issue to think of. Personally, i believed that there will be limitation in Ms Access like Ms Excel on the database it can store. The maximum row that Ms Excel can go is until 65536. So, what if the database in Ms Access is reaching maximum i.e. cannot store additional...

actually i already tried it after i posted the message on here. It's working...

just wanna to know somethig about Oracle as i'm new to it. As i know, Oralce 7 doesn't support INNER JOIN and Oracle 9 can. My computer is installed with Oracle 7 client. The server is running Oracle 9 server. Can i use the INNER JOIN in my SQL*Plus, Oracle 7 using INNER JOIN command in my SQL...

tblPart = Part_Num,Business_Unit_Id tblOrderDetail = Part_num,Business_Unit_Id tblCorp = Business_Unit_Id I have three tables as stated above. I want to equi-join tblPart.Part_Num = tblOrderDetail.Part_Num and tblPart.Business_Unit_Id = tblOrderDetail.Business_UnitId and...

In the WHERE clause.... .... where area = "india" or area "china" can be equivalent to: where area IN("india","china"). What if: where area like "a*" or area like "b*" How to put the Like and IN command together?

hi, just want to make sure is it my conversion is correct regarding the MS Access SQL and "Native" SQL conversion regarding the join: Here is the SQl from MS Access FROM (ASIA.PROD_ORDER_DETAIL_ASIA INNER JOIN ASIA.PART_ASIA ON (ASIA.PROD_ORDER_DETAIL_ASIA.BUSINESS_UNIT_ID =...

or yah, it's "Equi join". As my first language is not English. I'm always thinking it's "Equal"

hi, just want to clarify something. Is it INNER JOIN is same as EQUAL-JOIN. If not, what is the different

thanks for the help in Pass Through Query. Now i'm able to help the company to increase the productivity. They used the table to link to ODBC datasource then only use the local machine to excute the query to filter whethever they want. THis process usually will take up to three hours. With Pass...

as i understand, if i want to build up a new table using query, i can put the INTO tblName somewhere in the query to build up a new table. Now i'm writing the Pass-through Query to obtained the data from Oracle database. So, i need to use the Oracle-syntax to write out the query. Next, i...

go to the control and right click. Select the Font property then you can change it.

now i'm understanding what is pass through query. Thanks for the inputs and other issues arise or maybe need to take care.

maybe the relevant person can turn this to become FAQ for the benefits for other people.........

environ("UserName") is working on my computer. However, when my friend buy a new computer and copy the MS Access file i developed but it's not working in his computer. I go to Tools->Reference to check maybe his computer is missing any dll or ocx files. But he have all the files in his...

hi, i used a make table query to make up a table. In one of the column, i want to make it as combo box with only two values: Yes, No. CAn i do this in the Make-Table query?

thanks for the information. Just back from Work after few days of small break. BillPower, can your Pass Through Query working by specifing the "Where" clause?

thanks again

thanks, it's working. But when i modified your code before this: Sub SheetsNumber() msgbox ActiveWorkbook.Worksheets.Count End sub it's also working. I would like to know what are the different between ActiveWorkbook and ThisWorkbook.