Search results

Hello guys I have a database that my dear friend (@arnelgp) helped me design. It contains two tables, the first is called (A) and the second is called (B). Table (A) is the main table in the database. As for table (B), it is a table that I feed with information for specific fields and use a...

Thank you isladogs Yes I mean the motherboard number Public Function GetComputerSerial() As String 'gives serial number for processor / motherboard (?) Dim SWbemSet As Object Dim SWbemObj As Object Dim strSerial As String Dim strShowForm As String Dim strSerialInTable As...

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...

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

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

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

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)

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

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

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...

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...

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

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

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.

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.

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

Oh thank LarryE dear. Yes I need a report.

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

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)