Search results

  1. A

    Board Maker Serial Number

    Hi guys I am using this function to protect the database from copying and transferring it to another computer. And it works very well. But the problem I am facing is that I have to open a window (VBA) to put the Board Maker Serial Number for the program to work. Is there a way to create a table...
  2. A

    convert macro to VBA

    I used the Convert Form Macros option on the Form Design tab. Access closed itself and made a backup.
  3. A

    convert macro to VBA

    Hi guys I made a macro button for search. When I want to convert it to VBA language, I see that the conversion command is not activated. What is the reason? Thank you
  4. A

    listbox Count

    Thank you very much moke123 I put it in the VBA editor Private Sub Form_Current() 'MsgBox "There are " & Me.lstBookings.ListCount & " items in this Listbox." Me.Text50 = lstBookings.ListCount End Sub
  5. A

    listbox Count

    Hi guys Have a nice day everyone. I have a listbox based on a query. I want to put a text box on the form that will collect the records in it (ListCount)
  6. A

    Import variables from the first database to the main version

    Thank youThe_Doc_Man dear. You are really great, kind-hearted and very smart. We have learned a lot from you.🌻🌻:)
  7. A

    Import variables from the first database to the main version

    Thank you,The_Doc_Man . I understand what you are saying and dividing the database into front and back. We are talking here about transferring a database from one place to another using flash memory. Because this database is distributed on CDs and we cannot connect it through the local network
  8. A

    Import variables from the first database to the main version

    Thanks Gasman Yes, I need to update only one table's information fields. But how can I call this table and a specific department in it from the other database? Because the table contains 16 departments. And maybe I need to update the employees of department number 3 for example. Command15...
  9. A

    Import variables from the first database to the main version

    Hello guys. I have a database that contains almost general employee information. This database is distributed over the group of departments in which these employees work. Almost every month, changes occur to these employees, such as promotions, travel, and other matters. The employee concerned...
  10. A

    RGB color code / MS Access color code equivalent

    Thank you very much isladogs I was looking for it for the purpose of coloring the datasheet.
  11. A

    Open form based on field value

    In the double click event of the intended field, open the code and write the following code: On Error Resume Next Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmName" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm stDocName, , , stLinkCriteria
  12. A

    Crosstab query in form?

    Your point of view is correct. No one is perfect in all matters. It is true that I lack a lot of information in (VBA) but there are always those who ask for help from others. I salute this forum for the help it provides. Thank you dear for the constructive criticism.
  13. A

    Crosstab query in form?

    Yes, I learned a lot, my friend. The credit goes to you and to the forum. I have been a member of this beautiful forum for many years. I have learned a lot.
  14. A

    Crosstab query in form?

    Yes I will use the latest program because it is integrated in terms of reports as well but I will modify the fields and navigation buttons. Thank you very much you are really great. dear friend LarryE
  15. A

    Crosstab query in form?

  16. A

    Crosstab query in form?

    Oh thank LarryE dear. Yes I need a report.
  17. A

    Crosstab query in form?

    Thank you very much dear LarryE Yes I have seen that already. But there is one problem is when I make the form full screen some navigation buttons will disappear. And I am trying to adjust the subforms inside the main form
  18. A

    Crosstab query in form?

    Haha :) you are really great thank you very much.LarryE I will make some adjustments to the destination It is very nice to find friends like you in this wonderful forum. Thank you to those in charge of this really enjoyable forum. 🌹 🌹(y)
  19. A

    Crosstab query in form?

    Thank you very muchLarryE , great work. But the crosstab query displayed in the form remained the same, I have to use horizontal scroll bars. And with the addition of new material it will be longer and so on. So I was thinking that I can isolate the categories with three crosstab queries and...
  20. A

    Hello my dear teacher DHookom Can I divide the categories into several tables. For example...

    Hello my dear teacher DHookom Can I divide the categories into several tables. For example, stationery - devices - sports equipment Is there another way other than creating multiple tables and what is it? Please provide an example and I will be grateful 🌹 🌹
Back
Top Bottom