Search results

  1. A

    setting cursor in textbox field on initial load of form

    https://www.w3schools.com/tags/att_input_autofocus.asp
  2. A

    Activate an ole object by clicking a button

    Here is an answer after 9 years ! Private Sub btnopen_Click() Me![oledoc].Verb = -2 ' Tells Microsoft Access to open the application. Me![oledoc].Action = 7 ' Activates the application. End Sub
  3. A

    I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????

    Re: I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "??? A new reply for an old question for anyone drop in here. The solution is to set the database, tables , and fields collation to utf8_unicode_ci. as for the php files make them encode utf8 in BOM .
  4. A

    How to use Access with mysql

    Mariadb is good alternative .. see this odbc connector https://downloads.mariadb.org/connector-odbc/3.0.5/ it works with both mysql and mariadb itself. I tested it many times in both my internet website databases and over the lan network.:)
  5. A

    Access FE for the ODBC connection with Mysql

    Good day This is one form interface from inside MSaccess to Link/import /Export tables from/to Mysql. it works fine but I need some experts touches to deal with the listbox items that show currently available tables and show which is real one which is a linked one. and how to manage if the user...
  6. A

    Share Ms accesss database over lan network safely

    Hi people, I am sorry , it was like a big lie , I was unable to redo that attempt again. so I must be mistaken and was deceived by another database file in the same PC which my FE was talking to, I am sorry again, and forgive me for this too late apologize for I was busy working around to SAFE...
  7. A

    Share Ms accesss database over lan network safely

    Goo day for all. I have something nice to share with you. Well at first you might solved this before, but I was glad to do it myself. This is how to share a database over lan network safely. the solution was so simple , I split my database into two parts , part one has the forms and will work as...
  8. A

    Import selected file name to table

    http://www.access-programmers.co.uk/forums/showthread.php?t=219482
  9. A

    Documenting database

    Documentation ! Well, I like to share with you my vague version of 'simple documentation system' database. I imagine a department of purchasing or contracts..this dept. has some sections , each has few employees work in it. each one of these employees maintains a requisition or purchase order...
  10. A

    Home Learning Course Suggestions Please !!

    for beginners www.html.net
  11. A

    MYSQL and Image Storage

    what if i wanted to store the image itself in the mysql database not only the name? is that possible? if it is possible is it an idea to use the binary internal data of a stored small pic as authentication value for login? is this the idea with the loging seal used by yahoo website ?????
  12. A

    help me making database for trainees and courses

    press shift as you open the database so as to enter and make changes I'v used some short script that hide the menus of access 2003, this is the only thing in open form event , remove it
  13. A

    help me making database for trainees and courses

    For my own sake this is the final touch
  14. A

    help me making database for trainees and courses

    Thanks ALOT that was wonderful site. I did my best and made this database in the attachment, it was written in Arabic but I've translated it so fast , this time it deserves your attention I still have some problems the fast search returns duplicate values and I have no idea which is better...
  15. A

    help me making database for trainees and courses

    Hi everyone I hope this is the right place for this post and it won't be deleted I need to create a database that manage the courses and trainees, I made one myself but couldn't get it works properly, there must be table for courses contain course_id,course_name, date_start_,date_end...
  16. A

    Extracting path from FileName

    Awesome. Thanks a lot.
  17. A

    Extracting path from FileName

    Really amazing , only three lines code ! Thank you so much
  18. A

    Extracting path from FileName

    Thank you for your code.. For me I was working on archive program and I have the path of a picture file and I needed to locate its folder and open it with shell , explorer.exe and passing the path as parameter to the explorer ...., so the letter of the drive is needed and I would not drop it...
  19. A

    Extracting path from FileName

    Hi everyone this is my own easy way to extract directories from file name Private Sub doit_Click() Dim rght As String Dim lft As String Dim fnl As String Dim i As Integer i = 1 Do Until lft = "\" rght = Right(Me.pth.Value, i) lft = Left(rght, 1) i = i + 1 Loop fnl = Replace(Me.pth.Value, rght...
  20. A

    Large icons for access 2003 users

    Large icons for access 2003 users
Top Bottom