Search results

I make a query with enter the parameter value box (). I have to put complete word ( PKAS Petrol 1002 ) or ( PKAS Diesel 1002) to filter the data from table tblProInfo (). Is there any way that i can filter it .... by just insert Petrol or Diesel.

Thanks DCrake. I used ur code.... combine with mine... become like this : Private Declare Function InternetGetConnectedState Lib "wininet" _ (ByRef dwFlags As Long, _ ByVal dwReserved As Long) As Long Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim tdf As DAO.TableDef Dim...

hi.. i got a problem with my database. i used odbc connection using oracle. sometime there is no connection. i used this code to open the connection. Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim tdf As DAO.TableDef Set db = CurrentDb() Set tdf = db.TableDefs("TEST")...

hai yanie. Awak orang malaysia ke?

i dont know about this before. tq this is the first time i used this oracle program. i just extract the table by import it using ms access. hopefully u can help me

hi. I need some help. i used oracle9i. every time, i need to put the password to extract the data. Question: 1. so is there any code that i can used to automatically insert the password and user name. 2. automatically update the table

oic... so the best way is... u try to make a new simple database. this database must have table and query same as the real database. so then we can try to solve it. ok?

good... so u can attach the example of database (no need the real one). i will try to look what i can do to help.

This is what can i advice u. first don't think about kml. make the database first. then make the query that have all data u need to put into the kml. for example: ID COUNTRYNAME LONGITUDE LATITUDE EMPLOYEENAME 1 USA 102.123 5.8927 John, robert, tan 2...

Hai... I like to help but... still don't understand what u want. maybe u should give some example.:)

Great man!!! How u do this!! i like to learn.

Ok.... Thanks 4 ur Suggestion.:D

Yup... I agree with u. both can used 4 different reason. so when is the right time we should used IIF or SWITCH. as a beginner, I like to learn more....more and more.

Thanks...Stopher. before this i only used IIF. now u give me new knowledge. can u elaborate more about SWITCH.

Thanks Mike375...... it work g8. :)

I have the following columns; ID, OPS, CO, HC. Example: ID OPS CO HC RESULT 1 Static 2 500 2 Static 5 400 5 3 Static 5 660 5 AND 660 4 Static 3 700 700 What I need is to...

u can used query... used unique id (EmployeeID) relationship to combine the table.

:D "together we share, together we learn something new, everyone is my friend"

OK.. now i understand how it's work. Thanks again 4 ur help.:)

Hi... Learn new thing is very interesting.