Sorry its kinda messy, its from access.. the bold part is the 1 have issue. once againg sorry

SELECT Product.[Electronic Product Code], Product.[Item Name], IIf([parent - category] Is Null,[name],[Category].[name]=[category].[Category ID].[name]) AS Category , IIf([Parent - Category] Is Not Null,[name],"") AS SubCategory, Location.Country, Location.Building, Location.[Street Address], [Tracking Record].Timestamp, [RFID Reader].[Reader ID]
FROM Location RIGHT JOIN ((([RFID Reader] RIGHT JOIN (Product LEFT JOIN [Tracking Record] ON Product.[Electronic Product Code] = [Tracking Record].[Electronic Product Code]) ON [RFID Reader].[Reader ID] = [Tracking Record].[RFID Reader ID]) LEFT JOIN Has ON Product.[Electronic Product Code] = Has.[Electronic Product Code]) LEFT JOIN Category ON Has.[Category ID] = Category.[Category ID]) ON (Location.Latitude = [Tracking Record].Latitude) AND (Location.Longtitude = [Tracking Record].Longtitude)
WHERE (((Product.[Electronic Product Code]) Like "*" & [forms]![Search History]![tbxEPC] & "*") AND ((Product.[Item Name]) Like "*" & [forms]![Search History]![tbxProductName] & "*") AND ((Category.[Category ID])=[forms]![Search History]![cmbCat])) OR (((Product.[Electronic Product Code]) Like "*" & [forms]![Search History]![tbxEPC] & "*") AND ((Product.[Item Name]) Like "*" & [forms]![Search History]![tbxProductName] & "*") AND (([forms]![Search History]![cmbCat]) Is Null)) OR (((Product.[Electronic Product Code]) Like "*" & [forms]![Search History]![tbxEPC] & "*") AND ((Product.[Item Name]) Like "*" & [forms]![Search History]![tbxProductName] & "*") AND (([forms]![Search History]![cmbCat]) Is Not Null) AND ((Category.[Parent - Category])=[forms]![Search History]![cmbCat]));</pre>

Good day, I have some problem with my SQL Commands in access, really hope that you can help me out. Category

CatID Category Name Sub- Category Description

1 Beverages 123
2 Condiments 456
3 Juice 1 help
4 Coffee 1 pls

I wanted to display the main category of the Juice which is beverage. No matter how hard i tried, i can't display the Main category in access. Really hope if any kind soul could help me with this Regards Veon

hmmm... is there any other way without using sms gateway from service provider mobile company

Hi Friends I'm currently doing a project regarding on sending sms using C#. Is it possible to do it, if it is can anyone kindly share the code with me Thanks in advance :) Best Regards Veon Cheng

Hi People i have a problem with my Excel VBA. i have a worksheet with all my sales data, and another worksheet with customer detail. Where the customer detail do hold a foreign key of the sales data. How am i suppose to search using the foreign key. As i'm trying ti use the customer details to check what did the customer did. Thanks Best Regards Veon Cheng

hi sorry about the "wan" thingy. hmm ok i'm creating a form in excel where the form is able to let the user to select the start date and end date of the report to be generated. therefore i need to know the code that is able to call the data from an excel sheet to get the figure as well as items in the excel sheet. where i want to use the excel sheet as a DB. how? thanks Veon

hi, i had a problem in VBA, and i really hope you guys is able to help mi. i'm creating a simple system using VBA in excel, therefore i'm using the sheets as my DB. how am i suppose to call the things i wan. 2nd question how am i suppose to link the data list or list box with the sheets. Thanks really hope to hear from you guys thanks Best Regards Veon cheng

hi currently i'm facing a problem in creating a graph as well as pie chart using VBA. could any kind soul please help mi with it Thanks Warm Regards Veon

hi to all i would like to ask, is it possible that if i create a system and i want to generate the display items into excel file or txt file is it possible?? Warm Regards Veon

Hi to all, =) thanks for all ya advice. i'm very glad that you guys reply me and gave me some good advice.=) i'm new to the corporate world just step into the REAL IT world.haha thanks hope to hear from u guys again Warm Regards Veon

hi to all Thanks for replying. ok, my company will be running the admin of this system, it has a number of outlets will be using this system as well how am i suppose to make the system communicate. for example there is some update in outlet A. And i wan all the other outlets and the admin system to update the info of outlet A to all the system. i'm very confuse in planing the system right now. pls give me some advice ,Thanks Warm Regards Veon

hi Navaneeth, Thanks for replying. ok, my company will be running the admin of this system, it has a number of outlets will be using this system as well how am i suppose to make the system communicate. for example there is some update in outlet A. And i wan all the other outlets and the admin system to update the info of outlet A to all the system. i'm very confuse in planing the system right now. pls give me some advice ,Thanks Warm Regards Veon

Hi to all, i'm planning to create a new system using Visual studio for my company. but how am i suppose to create the system so that when the users wants to use this system he or she must install before he can use. besides that the users does not have a database system like SQL, how are they going to save the data or read from the data i created in my DB. are they suppose to install the DB as well ?? thanks Warm Regards Veon

hi Besides converting there is still other problems. i'm still wondering what to use to programe this system. Anyway Once i get the data into excel it will become my "database", the current situation is that everymonth this data from all the outlet would be like 10000 Rows in excel and my staff need to manually input using privot table to generate the total sales for stations. besides that the manager would also like to view the turnover as compare to last year by Q1, Q2,Q3, Q4 ,H1,H2 or a year. from the report maybe it could generate graphs or chart for a better view. thanks veon

hi my dear friend thanks for ya advice, maybe we could discuss this issuse and come out with a solution :).ok actually i'm doing a system for company and it has a system (TCS system) that links to other station where this system will catch the sales data from all the station. This TCS system is at HQ where we will generate the data into text file as this is an old school system which is still using MDOS. so currently they will just manually input the txt file to excel and process it. therefore its very time consuming. so i'm trying to create a software to help them generate their reports as well as other things related to the Txt file faster, easier and user friendly :) hope to hear from you Warm Regards veon

Hi to all i would like to know about some VBA and excel. I would like to create a form and i would like to use excel as my database. How am i suppose to code it and update the "database". Before updating the database i have a Txt file from my TCS system as it only generate txt file. In this file there are lots of space, comma and semicolon. therefore the code need to delimite the space, comma as well as semicolon. how am i suppose to do it?? besides updating, in the form i need to read the data as well. so how to read the data from the database, maybe is it like C# SQl where they is a need of some store procedure. and for some part i would like to read selected column. once again how am i suppose to code thanks once again thanks my dear friends Warm Regards Veon

hi hmm it the cell in excel for example A3 etc are cell right thanks veon

hi to my dear friends around the world how am i suppose to insert images into cell? so that when i do a VlookUp the image would be able to display thanks veon

hi ok thanks a lot realy thanks for the help and this is what i want thanks thanks veon :-D

hi thanks for your help but now i have a problem, i paste the your code into my code , when there is no error the error msgbox will prompt the user. this is how i code it

Private Sub CommandButton3_Click()
On Error GoTo ErrorHandler
Error 424 'This error is displayed when there is a missing object
Exit Sub
Dim Wk As Worksheet
Set Wk = Sheets.Add
ss = tbx_name.Text
Application.DisplayAlerts = False
Wk.Name = ss
ErrorHandler: MsgBox "Error Number: " & Err.Number & " With The Description ->> " & Err.Description & " <<- Occured."
End Sub

so whats wrong with it thanks thanks veon