Search results

  1. T

    Solved Problem with INSERT Date value

    Thanks for the helpful tips, Josef P.! I appreciate it! 🙏
  2. T

    Solved Problem with INSERT Date value

    Exactly! That was my mistake. Тhank you guys so much! 🍻🙏🍻
  3. T

    Solved Problem with INSERT Date value

    You are correct. Just replaced the single quote with double 'mm/dd/yyyy' Thank you! P.S. As a supplement to ask why the field "Value" ((Short Text)) save me the records the numbers with а comma (9,1) and not as I enter them with dot (9.10). How to format the field?
  4. T

    Solved Problem with INSERT Date value

    Hi, I am trying to INSERT date form fields form with that code: CurrentDb.Execute "INSERT INTO 01_tblLocalVariables ( Value, VersionDate, WhatsNew ) " & _ "VALUES (" & Me.txtVersion & "", #" & Format(Me.txtVersionDate, "mm/dd/yyyy") & "#", '" & Me.txtWhatsNew & "')" where...
  5. T

    Highlight matches

    I'm sorry. I fix it. http://allenbrowne.com/AppSearchHighlight.html
  6. T

    Highlight matches

    Hi, I need help to modify a code and implement it in my code. I found this а code on Provided by Allen Browne http://allenbrowne.com/AppSearchHighlight.html works great. Мy idea is if I can remove the combobox "cboField", by replacing it with a button "search". In the text field "txtSearchText"...
  7. T

    Solved How to count distinct id?

    OK, thank you! I looked at the query and saw that access added this name looks like a regex :) I did some exercises tried to build query that returns DISTINCT Object_ID for each employee (as advised June7), using your template query and it also worked, for which I am very pleased! I read that...
  8. T

    Solved How to count distinct id?

    arnelgp, June7, Thanks for the help and invaluable advice guys! You are awesome!:love: arnelgp, everything works perfectly. You are great! I have a question about that query (2_Cou). I could not understand why is that Alias (AS [%$##@_Alias])? Дoes it mean anything or did you just pick it that way?
  9. T

    Solved How to count distinct id?

    Hi, everyone! I need help building a query with a column to count the distinct id. What do I mean : That is my first query (Query1): SELECT tbl_Inspections.inspectionDate, tbl_Inspections.employee, tbl_Objects.city, Count(tbl_Inspections.inspction_type) AS CountOfinspction_type...
  10. T

    Header with image and text HTML and CSS

    No, it came from my Access program I made :) But I am trying to make the same vision on html and css
  11. T

    Header with image and text HTML and CSS

    Hi all. I need some help. How to make that header and Navigation bar in html and css...?
  12. T

    Solved Column divided into four other columns

    Thanks everyone for your help - ebs17, CJ_London, MajP, arnelgp I appreciate it!
  13. T

    Solved Column divided into four other columns

    I just wrote it like that without any particular intention.
  14. T

    Solved Column divided into four other columns

    MajP, thank you for your help and your time. I am concerned about the case where the sum obtained from the multiplication of the two columns is odd. For example 75. It means 75 to be random distributed in four new columns - column1 - 19, column2 - 18, column3 - 19, column4 - 19, the total sum...
  15. T

    Solved Column divided into four other columns

    I sorry for the incomplete information. I describe in more detail.. That is my request: SELECT qryAnnualPlan.CodeObject, qryAnnualPlan.ObjectType,Count(qryAnnualPlan.ObjectType) AS CountOfObject, tblCodeObject.Multiplicity FROM qryAnnualPlan INNER JOIN tblCodeObject ON qryAnnualPlan.CodeObject =...
  16. T

    Solved Column divided into four other columns

    Hello, I have a query in which I want to divide a number from one column into four other columns, i.e. bus stations (100) -> first quarter (25), second quarter (25), third quarter (25), fourth quarter (25)
  17. T

    How to remove border around the button after pressed.

    Yes, that is a possible option, but it is quite laborious to do for all buttons! Тhank you for the advice!
  18. T

    How to remove border around the button after pressed.

    Happy New Year to all! I wish you all happiness and health! How can I remove that border, which remains around the button is pressed?
  19. T

    Query criteria by month

    Thanks for the help, arnelgp! I will look into the request and may need to add more things. Тhanks a lot again!
  20. T

    Query criteria by month

    Thanks for your time and reply. I will try now
Top Bottom