Search:

Type: Posts; User: dertty_b3

Search: Search took 0.09 seconds.

  1. Replies
    4
    Views
    824

    Re: Remote Access to MS Access Database

    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...
  2. Re: Same Access database, different contents

    Thanks!

    I'll try it.
  3. Re: Same Access database, different contents

    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!
  4. Same Access database, different contents

    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!
  5. Replies
    17
    Views
    25,294

    Re: [RESOLVED] MS Access Table name alias

    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!
  6. Replies
    4
    Views
    824

    Remote Access to MS Access Database

    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,...
  7. Re: getting run time error 424 or 1004 when using Saveas method

    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....
  8. Replies
    1
    Views
    882

    Re: Type Mismatch Run-time error '13'

    Try to declare ETChours as Single.
  9. Replies
    17
    Views
    25,294

    Re: [RESOLVED] MS Access Table name alias

    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...
  10. Replies
    17
    Views
    25,294

    MS Access Table name alias

    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...
  11. Replies
    17
    Views
    25,294

    Re: [RESOLVED] MS Access Table name alias

    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...
  12. Replies
    4
    Views
    1,883

    MsOf07 Re: Run-time error '6':Overflow?

    What is the datatype of ElementNumber?
  13. Replies
    7
    Views
    4,703

    Re: Bring Another Program To The Front

    Did you try the ShellExecute function?
  14. Re: Select Then Update Data In Access Database

    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...
  15. Replies
    23
    Views
    1,718

    Re: Help with code

    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...
  16. Replies
    12
    Views
    1,565

    Re: loop between subs

    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
  17. Replies
    17
    Views
    25,294

    Re: [RESOLVED] MS Access Table name alias

    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.
    ...
  18. Replies
    17
    Views
    25,294

    Re: [RESOLVED] MS Access Table name alias

    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...
  19. Replies
    17
    Views
    25,294

    Re: MS Access Table name alias

    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 =...
  20. Replies
    17
    Views
    25,294

    Re: MS Access Table name alias

    I'm going to try again. If the error occur again I will post the code and the message showed.
    Thanks!
  21. Replies
    17
    Views
    25,294

    Re: MS Access Table name alias

    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.
  22. Replies
    17
    Views
    25,294

    [RESOLVED] MS Access Table name alias

    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...
  23. Replies
    2
    Views
    800

    Re: Combobox: make dropdown in code

    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.
  24. Replies
    2
    Views
    638

    Re: Data Report is showing all the records

    Don't use the Like operator if you want to get only one especific record.
  25. Thread: stop looping

    by dertty_b3
    Replies
    8
    Views
    1,045

    Re: stop looping

    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.
  26. Re: Access UPDATE Error 3464 Data type mismatch in criteria expression

    You don't need the ";" at the end of statement.
  27. Re: Access UPDATE Error 3464 Data type mismatch in criteria expression

    Try this: ...WHERE orderID = " & OrderID

    Number must not be surrounded by single quotes (').
  28. Re: Query to find all jobs that work started on a certain day

    SELECT job FROM tableName WHERE [date work done] = #2/1/2013#
  29. Re: Row cannot be located for updating , ?? please help ,

    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").
  30. Re: Correct VB6 code for popup calendar display location, please help

    I think you must manipulate raw and col variables if they are out of range.
Results 1 to 30 of 30



Click Here to Expand Forum to Full Width