Search:
Type: Posts; User: d3gerald
Search:
Search took 0.10 seconds.
-
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
|
Click Here to Expand Forum to Full Width
|