Search:
Type: Posts; User: dertty_b3
Search:
Search took 0.09 seconds.
-
Yes! The database type is acdb.
I located it in a shared folder.
There is a VB6 application the allows users to edit the records.
I tryed to chenge the users access permissions, but it didn´t...
-
-
Hi!
The file is stored in Program Files and I'm using Win 7 Prof. SP1.
How can I solve this problem?
Thanks for your quick replay!
-
Hello!
I have a database updated throw VB6 code.
When I copy this file to another folder, it doesn´t show the same records.
Can somebody explain me how to solve it?
Thanks in advance!
-
Hi!
I'm back again.
You all where right. Threads 14 and 17 show where I was wrong.
One more time, sorry ant thank you!
-
Hi all!
I have a application running in my own office computer. Let´s call it 'Server'.
I put this in a shared folder so I other users can have access to it though client computers.
In fact,...
-
Hi!
If the user doesn't get access permission to create a folder on the specifyed path, MkDir command will fail. So, if you didn't succed to create the desired folder, you can save nothing there....
-
Try to declare ETChours as Single.
-
No error occur if I remove the aliases.
I have other sql statement that return no error: SELECT movel AS c1, movel2 AS c2, c.fixo, c.fax, email FROM Contactos c WHERE c.nome = '" & Combo1 & "' AND...
-
Hi!
The sql statement I tryed to execute is:
"SELECT Stuff.PI AS PI, Stuff.Nome AS Nome, Stuff.Delegação AS Delegação, Sector, Stuff.Carreira AS Carreira, " & _
"Stuff.Categoria AS...
-
Hi!
The sql statement I tryed to execute is:
"SELECT Stuff.PI AS PI, Stuff.Nome AS Nome, Stuff.Delegação AS Delegação, Sector, Stuff.Carreira AS Carreira, " & _
"Stuff.Categoria AS...
-
What is the datatype of ElementNumber?
-
Did you try the ShellExecute function?
-
Hello!
Try this:
UPDATE friend SET total = 2 WHERE class = 'A'
Or
UPDATE friend SET total = total + 1
Let me explain th differences between this two options. The first one must be repeated 3...
-
Hi!
Use the Environ() function to return the user name.
Syntax: strUserName = Environ("username")
And use the Kill function to delete the file.
Syntax: Kill path
Where 'path' is the full path...
-
What if you define subs like this:
Private Sub ShowItems(Index As Integer)
And then you could loop like this:
For i = 1 To 3
ShowItems(i)
...
Next
-
Now I know where is the problem.
Both syntax are valid. But none of them works with joins.
When I code: FROM tableOne AS t1 INNER JOIN tableTwo AS t2 WHERE t1.id = t2.id it returns an error.
...
-
I know that there is no need to use alias when we use only one table.
You said ms syntax is correct. If so, the difference is:
MS FROM CLAUSE: FROM tblOne AS t1, tblTwo AS t2
My syntax: FROM...
-
Dear Mr. DataMiser,
I want to say sorry and thanks for your kind reply.
You were right all the time when you said that the correct syntax is:
SELECT fieldname AS f FROM tablename t WHERE t.f =...
-
I'm going to try again. If the error occur again I will post the code and the message showed.
Thanks!
-
Thanks for your reply. But I've already tryed this syntax too and it didn't work. I'm going to try something like this: SELECT field FROM (table AS t) WHERE t.ID = 1.
-
What a odd thing?!
I read an article by microsoft explaining how to use fields and table aliases. Great! I tryed to use field alias and it worked. But when I tryed to use table alias I got an error...
-
I'm not sure that SendMesssge function solved your problem. But you can try to set the fucus on your combo box and then SendKeys to simulate a dropdown.
-
Don't use the Like operator if you want to get only one especific record.
-
Why are you using two loops?
The actual inner loop is enough.
Your code doen't stop loop because the value of loopme keep true and there is no condition to turn it false.
-
You don't need the ";" at the end of statement.
-
Try this: ...WHERE orderID = " & OrderID
Number must not be surrounded by single quotes (').
-
SELECT job FROM tableName WHERE [date work done] = #2/1/2013#
-
Sorry my poor english. I think Fiels(0) refers to column 1, Fields(1) to column 2, so on. So Fields(2) does not exist. The safer way is to code Fields("userID").
-
I think you must manipulate raw and col variables if they are out of range.
|
Click Here to Expand Forum to Full Width
|