Search:

I suggest you use sql statement to append data to your database. you may use the insert into statement of sql. you may also refer to http://w3schools.com/sql/default.asp for more information...

Microsoft actually have posted a troubleshooting guide for this error... Please click the link below.

http://support.microsoft.com/kb/306269

Hope this helps

Welcome to the forums....

First up... could you please specify what error are you encountering with this script?

You may refer to the following link for help on SQL statements

http://www.w3schools.com/sql/default.asp

I just would like to point out something from the code above...

If Not rs.EOF And Not rs.BOF Then

the above condition will never return a True value thus the statements inside the if clause...

You may also refer to this thread for some ideas...

http://www.vbforums.com/showthread.php?t=386579

You may also make use of LVButtons which can be downloaded online for free...

What change do you want to implement? I don't see any change in the data quoted above...

Update statement is used to update all or specific record or set of records in a database using the syntax...

actually, I was able to do that before however, you need to have a stable internet connection. Also, you need to know the correct host path of the image plus you can only show images from non-site...

I agree... I was just thinking that he is using an access database or an excel file...



May we know what database are you using?

do you mean that there is no space before the letter n??? please clarify...

this actually requires you to share the directory where your database is located over the network... then reference your sql connection string to that path...

for example///

the path of your...

have you tried enclosing the table names with [] like [1234]...

If I may ask, are you trying to show all records from the empmas table? If so, you could just remove the condition "where empid=@empid"

thus your SQL statement would be "Select * from empmas"

I totally agree with this

the program named Game.exe should be placed in the same folder/directory where your host application/project is located...

for example:

you saved your project in C:\Prog\ directory

the...

Please don't get me wrong, I just would like to make sure that this is not a result of a typo error in your code

try to replace

Open App.Path & "\ir\user\" & lstCodesets.Text & ".cds" For Input As #currentfile


with

MsgBox App.Path & "\ir\user\" & lstCodesets.Text & ".cds"

an Application Freeze usually happens when it encounters a line of code that takes much time for execution. There are various ways of getting rid of this. Try to check the codebank for some sources.

your problem lies on the query you're trying to execute. Using "update" statement, you are going to make changes to the table you are invoking in your query. In your case, use the "select" statement...

use a timer in your form and place your conditions in your timer's code.

you can use the change event of the textbox to do that or you could use a form level variable and check the value of the textbox through the code...

i forgot how i did it before coz i'm now using sql server database. but try to go to

http://www.vbaccelerator.com

welcome to vbforums,

well there is an existing sms modem that allows you to send sms through your pc using a valid sim and network.

You can execute an sql statement to get the total value of that field

Select Sum(Subtotal) from <tablename>

try going to the reporting section of this forums... I'm sure you can get a lot of ideas there

The problem is on the part where you open the recordset because the two fields have different data types...

you can use this idea

If optCode.Value Then
rec.open "select * from emp...

try this code and see if it returns a value

m_strSQL = "SELECT Username, AES_DECRYPT(Password, '" & m_strEncryptDecryptKey & "') As Password, Disabled "
m_strSQL = m_strSQL & "FROM...

sorry but I just thought that the data found in the database would match to the condition if the password is encrypted in the condition

maybe somethin' like this flow would work

m_strSQL = "SELECT * "
m_strSQL = m_strSQL & "FROM AuthorizedUsers "
m_strSQL = m_strSQL & "WHERE Username = '" & txtUsername.Text & "' "
...

you can do something like this


msFlex.Rows = msFlex.Rows + 1
msFlex.TextMatrix(msFlex.Rows - 1, 0) = "First Collumn Value"
msFlex.TextMatrix(msFlex.Rows - 1, 1) = "Second Collumn Value"...

i prefer declaring it that way, anyway it doesnt matter, it could either be long or integer but i prefer using long

well in that case, you can manipulate a variable to detect your desired interval

set the interval of the timer to 10000

dim ctr as long

Private Sub Timer1_Timer()
if ctr = 3 then
...

try a search in the forums. we have discussed that topic many times before.

dont enclose StaffCode in singlequotes

SELECT * FROM table2 where StaffCode = " & Text1.Text

PWS is the web utility of WIN98. you dont need it. XP is built on NT structure and NTs counterpart for PWS is IIS. you just need to activate it.

try to search for lvbuttons, its free

try putting the me.SetFocus command after your shell code


shell "Yourexe.exe"
Me.SetFocus

Are you developing somethin like a keylogger? if thats the case, sorry, we dont support that thing here...

why dont you use a timer for that one