Lowyat.NET: Latest topics by felixwhoals

Any refurbished or used laptop for sale?

felixwhoals — Sat, 09 Aug 2008 05:16:40 +0800

Hi there,

As you are aware, I am actually looking for a refurbished or second hand laptop.

Yeah with the price range listed above. I am not looking for high tech laptop. I am actually looking for a 10.4 - 12/13 inches laptop with Word Processor installed.

As long as the screen is small and light, that's all I really wanted. Please let me know if you have any laptops available for sale.

Do reply this thread, pm or email me : felixwhoals 'at' yahoo 'dot' com.

Canon IXUS 60 for sale

Thu, 01 Jan 1970 07:30:00 +0800

UNIX Scripting Question

felixwhoals — Thu, 13 Dec 2007 23:00:00 +0800

Hi there!! I am new to UNIX scripting.

I am basically doing this simple example but I am not sure the commands to use.
Ok, I have a file with 20 lines on it and I want to append a text in the middle of the line of that file.
What I did was to check for the total lines of that file and divide by 2. What should I do next? Should I do a loop or should I add a condition (if Line equals to the line I specify, then append data onto it?)

Trade in Cam

felixwhoals — Sat, 27 Oct 2007 16:46:42 +0800

Hello there,

I was wondering can we actually trade in our old camera with another camera and pay the extras.

I would like to trade in my Canon camera, I was just wondering if I could trade in my camera at any Canon dealership companies?

Microsoft certified courses

felixwhoals — Thu, 25 Oct 2007 04:43:21 +0800

Hi there,

May I know where can I study for Microsoft certified courses such as MCDST and MCSE in KL? I want to know if they have any available teaching in November.

VBA Forms Query

felixwhoals — Fri, 23 Mar 2007 10:37:48 +0800

I have a question about Forms in MS Access

U know in vb, you have Form_Open, Form_Load, Form_Current properties
For Form A:
Form_Open function: MsgBox "hi"
Form_Load function: MsgBox "tada"
Form_Current function: MsgBox "mama"

It does all the three functions when I open Form A in Access.
However, I've got a button in Form A that opens another Form (FormB)

I did this Me.Visible = False - close or minimise form A?
and then DoCmd.OpenForm(FormB)

Well, it opens formB now and FormA disappears. So I assume I have closed Form A. It wasn't minimised so I assumed it is closed. On form B, I have another button that opens Form A back.

When I open Form A, Form_Load and Form_Open functions did not run. I thought it might run Form_Open function but it doesn't.. It just executes Form_Current function: that displays msgbox "mama"

So does anyone know if there is any way I could execute Form_Load or Form_Open function when I open FormA again? (Direct from FormB)

I hope that's a clear explanation.

Running MS Access as back end!

felixwhoals — Tue, 13 Mar 2007 21:34:24 +0800

Hello guys,

I have done this project on Ms Access - well some kind of system.

However, I don't want this file to be in .mdb.

Well I have all the databases, tables and forms in Access. I want to make it .exe or maybe put it on .html then view it!

So user will think it's actually running on the website or probably a stand-alone system but on the back end, it's actually running Ms Access!!

Anyone knows how to do that? Does Ms Info path help me to achieve that?

Im not too sure if this is the right thread to ask this question!

Please help!

mySQL query

felixwhoals — Sun, 11 Mar 2007 19:27:26 +0800

Ok in StudentTimetable, there's LecturerName column :
1) Dr J K / Dr M L
2) Dr M J
3) Dr S U

I tried doing this: SELECT StudentTimetable.LecturerName FROM StudentTimetable
WHERE StudentTimetable.LecturerName LIKE 'D%'
This should match all three above right? Cause it starts with D? But it doesn't work.

I also tried with :
Like '%Dr M L%' but it doesn't work.

Is it possible to output the 1) by giving Like '%Dr M L%' or Like '%Dr J K%'??

MsAccess - VBA problem

felixwhoals — Fri, 09 Mar 2007 04:45:59 +0800

Ok, I have a text box and also a list box
Listbox: Year
Textbox: Text2

Private Sub Year_Click()
Text2.SetFocus
Text2.Text = Year.Value
End Sub

Whatever I clicked on Year listbox will appear on Text2..
Ok, when I run it, I click on the listbox, got this msg:

The Macro or function set to the beforeUpdate or ValidationRule property for this field is preventing the system from saving data in the field!
If I click debug:

the error is in - text2.text = year.value
but i dun think there's a problem with that

But when I click 'END' it appears to be fine.

So what's wrong with that ERROR?

Please help me!!

Creating a select query & place it on a text box

felixwhoals — Mon, 05 Mar 2007 01:28:11 +0800

Hi guys,

I have a question to make.

I'm in MS Access now!
Ok, I have this information from a combo box. Based on this combo box result say, 'felix', i want to use that result and create a select query to check for my ID number and after getting the ID number I want to place it on a text box.

Any simplest way to do that on Ms Access - Visual basic?

SQL Query

felixwhoals — Fri, 02 Mar 2007 23:31:21 +0800

In Ms Access 2003:

Dim datbase As Database
Dim qerdef As QueryDef

Dim Location As String

Location = "fdfsds.mdb"

Set datbase = OpenDatabase(Location)

Set qerdef = datbase.CreateQueryDef("NewQueryDef", "SELECT Subject.Level Name FROM Subject Where Subject.BC = 2645;")

datbase.Execute "INSERT INTO Subject (BC) Values " + qerdef

What I'm trying to do is to select a value from different table and append it into another table.

There seems to be a type mismatch on the 'qerdef' side. Anyway to fix?

[addedon]March 5, 2007, 12:40 am[/addedon]To simplify my question:

Dim datbase As Database
Dim qerdef As QueryDef

Set qerdef = datbase.CreateQueryDef("NewQueryDef", "SELECT Subject.Level Name FROM Subject Where Subject.BC = 2645;")

Is there anyway I can put the result from that query into a string??

SQL Question

felixwhoals — Mon, 29 Jan 2007 08:15:56 +0800

Virtual reality mini project

felixwhoals — Sat, 02 Dec 2006 01:29:37 +0800

Hi guys!

I was wondering has anyone done Virtual Reality module before?
I need to create a mini project for this module.

I can't think of anything that has GOOD behaviour and animation.
As far as i know, GAMES have that but I'm not sure what we can do.

One question, if I were to make a kitchen as a game, what kind of things can you play in a kitchen?

Any other suggestions would be great!! I just need some help and suggestion.
I have to develop it in VRML.

VB - Access Login form

felixwhoals — Tue, 21 Nov 2006 21:09:24 +0800

This is my problem:

'Check if user has enteterd the correct username

If IsNull(NameText) Or NameText = "" Then
MsgBox "You must enter a User Name.", vbOKOnly, "Required Data"
NameText.SetFocus
Exit Sub
End If

'Check to see if data is entered into the password box

If IsNull(PasswordText) Or PasswordText = "" Then
MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
PasswordText.SetFocus
Exit Sub
End If

'Check value of password in student table if it matches

If PasswordText.Value = DLookup("Password", "Student", "[StudentName] =' " & NameText.Value) Then

StudentName = NameText.Value

MsgBox "Test successful.", vbOKOnly, "Required Data"

of which password appears in student table. and studentname in my student table too. Ok I typed 'Felix' for username and 'abc' for password which appeared in the Student table on my database.

Apparantly, the one that I highlighted, there's a syntax error:

Syntax error in string in query expression '[StudentName]='Felix'

Since it's syntax error, there must be wrong with the syntax. I tried I to take off the single quotation, and I get

you cancelled the previous operation

can someone help me?

Parser Software

felixwhoals — Sat, 04 Nov 2006 07:26:15 +0800

hi there,

I'm trying to get information from the website and parse them into SQL.
For example:
DAy/Time 8 9 10 ....
Mon HCI AB CD
Tue AB CD SD

that one appeared on a table in a website.
I wanted to copy 'HCI' into mysql database.

I'm trying to extract information from that table and put them into mysql database.

I wonder if anyone knows how to parse them.

Dell Media Experience Installation

felixwhoals — Sun, 20 Aug 2006 21:14:49 +0800

Hello there.
I already formatted my laptop (dell inspiron 6400).
After installing all drivers and windows, I tried to install dell media experience application.

There was an error: This application requires Microsoft .NET Framework 1.1 or higher to operate.

Alright, I went to microsoft website and downloaded Microsoft .NET Framework Version 2.0 Redistributable Package (x86) which is correct for my windows cause i'm using service pack 2 too.

After installing that, I restart my computer and try to install dell media experience but I couldn't install it. The same error came out again.
What's the reason actually? I checked frm Add/remove programs and Microsoft .NET Framework 2.0 was there. That's mean I already installed that software but I don't know why I couldn't install dell media experience still..

Anyone knows why and give some suggestions?

Regular Expressions

felixwhoals — Fri, 07 Apr 2006 07:40:37 +0800

Hey there...
I have two questions to ask because I'm quite confuse..

1) (ab*)* -- does not match ba while (a*b*)* matches ba
i thought for (ab*)*, you get abbbbabbbbabbb.. you get ba right?

2) (a*b*)* -- this matches all aa, bb, ab and ba right?? because
it can do aa, bb, then aabbabaaabbbabababab

Computer Science Final Year Project

felixwhoals — Thu, 23 Mar 2006 09:46:11 +0800

Hey there, one of my supervisors has put 'developing e-commerce website' as one of the projects in final year. But I don't think I will get good marks if I come up with the website.

I was wondering if anyone has any suggestion to make the E-commerce system to push me in getting better marks for final year. I have 3 months decide on a topic.

Ok, first of all, I need to have a real client to really test the system. I think I need to collaborate asp into it.

But should I develop an e-commerce website that implements HCI principles?

I mean what features should I provive in an e-commerce website?

UML Sequence Diagram

felixwhoals — Tue, 21 Mar 2006 01:40:38 +0800

That's the link to the file - question and my answer (I'm not sure if it correct)
I know it is simple but I think the simple it is, the harder I get good marks. So I hope some1 could take a look at it and comment about it.

http://www.megaupload.com/?d=0MWDRA6U

If you want to change them, please change for me and send themback to me :
felixwhoals at yahoo.com.

Inti College Subang Jaya

felixwhoals — Sun, 19 Mar 2006 06:31:08 +0800

HAHA, just want to let some students who want to join INTI For May 2006 intake
I studied in Inti last year January 2005. This place is really great!! Although the structure is like a school but somehow I enjoyed studying in this college.
Just imagine, opposite the school's library is the market where you can cheap food 'chap fan' haha and walk for a few minutes, you'll see cyber cafes!! There are actually lots of good places to eat somehow but my friend's favourite ones was McD as usual!!! It's so small there. We have to go to burger king when mcDs is full. We have Starbucks opposite INTI college. HAHA that's what I'm proud now. The whole college area really has STUDENT LIFE. Imagine, three colleges are there, INTI, TAylors and metropolitan.
I luv weekdays during lunch time, where u see lots of ppl walking (students though) - for guys out there, lots of lengluis and for girls out there, lots of lengchais.
You won't regret coming to Inti!!

One thing bad about INTI, no place to find parking!! HAHA, I always park at housing area, sometimes it's illegal park there but I really enjoy studying here. though I live far from Subang. I live in Cheras, have to drive for 30 mins. If I have lectures at 8am, oh my god have to come out from home at 7am.

Mamak stores all around, fast food, food courts, chinese hawker stalls, market hawker stores, cafes all available just in Subang area!!