Posts by werks

Hello windows experts. I have a big problem please help me.. I have reinstalled WinXP SP2 everythngs ok except for the Sound Driver It has a Yellow question mark on it. how can i solved this? need help URGENT..tnx in advance.

Kenneth
"Better Than Yesterday"

try PM me

try using Innot Setup for Packaging, The good thing about it it is easy to use and its completely free..

Solved the problem tnx to debasisdas.. By using SHELL i can call different Application..

Hello experts. I have 2 vbp (namely Project1.vbp and Project2.vbp) I Group them into 1 Project, my problem is how can the user choose on what project they want to use using VB6?

My initial idea is when the user login a form will prompt, and the user will be given a choice w/c project to run the Project1.vbp or the Project2.vbp.. Please help me on this. tnx in advance

Could you please guide me through... Yes! Im developing a Library Ystem w/ OPAC and Reservation

Thanks for your reply. I just found out how to manage that by using Replace() function.. btw thanks everybody

Now i see.. You should learn first the basic Database Programming in VB 6..

How can i do that.. Please guide me through

Hi Kenneth...
I am getting error in these lines..
rsnew3!text1 = text1.Text
rsnew3!text2 = text2.Text

BTW what kind of error?

Do you have a field name text1 in your table in the database?

Try removing the error handler to detect which line the error occur

Hi Shouvik..
Thanks .. I tried your code but i am getting the error msg "error in creating the new record."

In what line of code you get the error?

I get the problem if save the record with NULL value then it will save Empty String and if you save the record with a value it will not save any record because you don't specify the code to save the record..

Hi experts this is an urgent question. how do you import and export database online?

I have 2 equal database. I uploaded my FrontEnd(OPAC) and Database online. I have also a same database in my BackEnd(VB6) located in my computer. My problem is how do i update both database in every transaction done.

E.g. I added a record in my backend, the system will automatically update the database record online.

how can i accomplish this? is it possible? Tnx.

BTW im using VB6, ASP and Access

Hi experts this is an urgent question. how do you import and export database online?

I have 2 equal database. I uploaded my FrontEnd(OPAC) and Database online. I have also a same database in my BackEnd(VB6) located in my computer. My problem is how do i update both database in every transaction done.

E.g. I added a record in my backend, the system will automatically update the database record online.

how can i accomplish this? is it possible? Tnx.

BTW im using VB6, ASP and Access

Solved the problem. wrong variable

The picture does not display, is my code wrong? please help

<tr>
<% Response.Write("<td><img src=Books/" & varAccession & ".jpg class=picA width=200 height=150 /></td>") %>
</tr>

Hello

Every time i input the character ' and % in the textfield it generate an error in my query.

The error:
Syntax error in query expression 'Title LIKE '%' %%';'.

My code:

adoList.Open "SELECT * FROM qryOPAC WHERE Title LIKE '%" & varExp & "%';",CoNN,3,3

tnx in advance..

Kindly post your code..

Thanks! your a great help!

Hello experts could someone tell me how can i combine multiple records into one value.

Sample in MS Access:
(Lastname & "" & "," & " " & Firstname) AS Name

How can i do this in MySQL?..tnx in advance

--Hotel Reservation with Monitoring System
--Payroll System
--Library System

Solved it. I use $exp = str_replace("'", "", $exp); BTW Thanks to the two of you..

Hello nav33n i've tried your code

"SELECT *
FROM `table3`
WHERE name LIKE '%hilgard's%"

but still it returns an error

Hello PHP experts how can you detect ' character in your search field?
Because every time I input the word hilgard's it returns an error I think because of the character '. This is the error

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Title LIKE '%hilgard's%';'., SQL state 37000 in SQLExecDirect in D:\wamp\www\Online Library\opac.php on line 76
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Title LIKE '%hilgard's%';'.

tnx in advance.

Tnx Web_lock for your reply... I'll check it out

--Automated Library System with OPAC and Reservation
--Computer Aided Instrusction in Mathematics

try this it is a All-in-One package

WampServer
Xamp

I'll try it tomorrow..

tnx choudhuryshouvi

sorry Robin but i dhdon'tave any idea on how to add records using Adodx.. ^^

Hi guyz, i have a question about crystal report . How to connect the Crystal Report in MS Access (w/ a password security).. Cause i can't seem to connect it with a password database..tnx in advance

Hope they post the rankings..hehehe

How come you want to be famous when you cannot spell correctly the spelling of your country?

He's actually right..lol

Hi try using external software like Inno Setup. It is a good software and absolutely free

I'm going to pay all the Liabilities of all Countries in the World..

Kenneth

Hello there xcard14, what is a Voltage Control is it a System or Program, etc.? It will greatly help us if you explain more..

Kenneth

tnx hollystyle.. Is it possible to get the remaining results in the query after using the TOP?

e.g.

Select TOP 10 qryOPAC.* FROM qryOPAC

It returns 20 records, since im using the TOP 10 it will only return the first 10 records, right? Now how about the remaining 10 records what happen to them?

Kenneth

Never heard of ADODX.. how do you use it? and What are their diferrence?

Hi there. how can i limit the value of records in Access. Is there a LIMIT function in Access like in MySQL? tnx in advance..

Hi there programmers could you help me out. I need idea on how to create an Online Reservation of Books for a Library.. thank you in advance..

You could also use PHP and MySQL

Private Sub Command1_Click()
    Form2.Show
End Sub

If you press the Command1 button it will automatically show the another form..

Could you explain more details.. tnx

Give us specific details on your problem(s)

thanks for the tips..

I'll be dating my computer the whole day..lol making Thesis Project

Thank you programmers for helping...

Hello does anyone know how to lock the system within a specified time? Like a screensaver..

Actually i want my system to automatically lock if it is unused for about 15 minutes..tnx in advanced