Search results

  1. A

    Solved Disabling Shortcut Menu except a textbox

    Thank you so much.
  2. A

    Solved Disabling Shortcut Menu except a textbox

    Hello everyone, I'm trying to disable form shortcut menu except a textbox, I mean I want to disable right click on a form except a textbox so that users be able to right click and paste on the textbox, is it possible?
  3. A

    Select records until a specific record

    Bravo,Thank you both,
  4. A

    Select records until a specific record

    Hi all, I have a table of Product names and I need a sql code to pull products name till a speciific products name, like : For example, If the target record is "Canon i70", SQL code must select products names until the target product name that are 1 to 7. "HP pro 400" "AOC T96" "HP 220"...
  5. A

    Solved Filter subform by short time

    That's really great, thank you so much Can it be used on change event of textbox? (not AfterUpdate)
  6. A

    Solved Filter subform by short time

    Hi all, I have a field on subform that contains short time data, now how can I filter subform by typing time in text box on form? is it possible?
  7. A

    Portable database for storing images or any binary file

    Thank you all, sorry for the delay in replying, I didn't expect to these response. many thanks to cheekybuddha, I finally found what I've been looking for, this is "SQLite", SQLite is awesome, because it's a potable database (.DB) and the size of this database is extremely large. and also MS...
  8. A

    Portable database for storing images or any binary file

    Nearly 6 GB is enough, but I need to a portable database, I have worked with SQLServer, but users must install it.
  9. A

    Portable database for storing images or any binary file

    Hi all, As you know access database is limited in size (2GB) and it's not good to attach more files in it for example images, musics , ... I have been using to attach the files in a folder beside access database and call them from access, but I need to store all files (jpg, png, pptx, mp3 ,..)...
  10. A

    Select by Dsum criteria

    Thank you, Yes your right, I don't nee to Docmd.runsql
  11. A

    Select by Dsum criteria

    This worked for my file, great.
  12. A

    Select by Dsum criteria

    In this case, "dblValue" is fixed, while "dblValue" must be calculated for each C_Code.
  13. A

    Select by Dsum criteria

    Excuse me, I had forgotten,
  14. A

    Select by Dsum criteria

    Hi all, I'm trying to populate a table field to ComboBox so that another column of the table is greater than sum of another table : Table1 : C_Code C_Amount A190 2600 A250 3200 Table2: D_Code D_Amount A190 150 A190 500 A250...
  15. A

    Store file in SQL server

    Thanks for your response, is there any limit to varbinary(max) column? and do you have any example or sample code to convert file to binary code and insert to varbinary(max) via vba?
  16. A

    Store file in SQL server

    Hi everyone, newly I migrated from access back-end to SQL Server, and I create all tables with sql server and connect it with access by OCDB. But I have a question, How can I store and read file in sql server like "attachment field type or OLE-Object type in access? For example I want to insert...
  17. A

    Solved Relationships problem

    Hi, you are right, I had no information about split. I accomplished it after searches.
  18. A

    Solved Relationships problem

    That's great, thank you mike60smart, also thanks to plog to given the solution.
  19. A

    Solved Relationships problem

    Several users will work with the database. I mean someone may delete the tables incorrectly.
  20. A

    Solved Relationships problem

    Thank you plog for spending time to this post, this good idea to link by autonumber but this action will there be no problem in the future? , because I thought link by autonumber is not a right way to join (I knew that's possible). I was assuming that if "tblSections" is destroyed, we won't...
Back
Top Bottom