Search results

Hi Uncle Gizmo, Can I have practical example with the attached DB. foxtet

Hi All In the attached sampleDb in the frmUnit when clicked add new button I want unitID field to be increased to one. data type of the field is text foxtet

Hi Guys! Good Day for all. I have a small database in which I have a search form. When I double click the search form MAWBNo field frmCargoMaster opens. I want combo boxes in that form to be displayed as text boxes. I tried to do that but still Im not able to get this done. Any bright minds...

How can I mark the post as [SOLVED]

[SOLVED] I honor your coding skills and excellent knowledge in access programming. Hope that you will attend to the other threads that I post in this forum Thank you for your time. foxtet

Hi arnelgp, I have added Add New Cargo button on frmCargoSearch. When I add a new record on it and close that form added record is displayed on the subform. To get that record in sub form every time I have to close the frmCargoSearch and re open it. Can I have the record displayed in the sub...

[SOLVED] Solution is exact and worked fine Thank you! :)

Thank you! Excellent solution! One lats thing that I look for is that the label displaying total records on sub form can have format like 2 of 50. :)

Thank you arnelgp, It worked as the way I was looking for. In the meantime 1) Can you add reset button next to search combobox so that the sub form will have all records displayed when clicked. 2) A label below the subform displaying number of records. Good Day!

Hello Guys! I have placed a combo box in the cargoSearch form header to filter records based on its selection on subform which is placed on the details section of the form. when I select comobo seclection I get error message 'Run time error 3251' Can I have this error corrected. The other...

Hi have a look at table structure for more details. Help me to way forward with issuing services. Foxtet

Function GetUnitPrice(lServiceIDID As Long) As Currency GetUnitPrice = DLookupNumberWrapper(" [List Price]", "tblServices", "[ID] = " & lServiceID) End Function

Hi friends could you have look at on this issue. when run it gives error sub or function not defined. Adopted from nothwind databse. Private Sub ServiceID_AfterUpdate() 'Initialize price and discount for each product change If Not IsNull(Me![ServiceID]) Then Me![Quantity] = 0...

I also find it difficult to relate tables to get out put. Foxtet :(

the access file is attached. i find it difficult to make a query to obtain services that customer is provided. foxtet

In the database to manage clinic opd in which I have created 3 tables tblService, tblServiceCat and tblServcieDetail. I wanted to design a form with embedded subform to selected services obtained by the patient. I want service subform to be like. Service name Qty Unit price...

Private Sub SearchResults_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_File_Info" stLinkCriteria = "[FileNumber]=" & Me![SearchResults] DoCmd.OpenForm "frm_File_Info", acNormal, , "FileNumber=" &...

When double click the entries given in the attached database I cannot open the correct form. it gives parameter value. kindly help me to overcome this error. Fox

Thank you Steve for the technical explanation. Could you work on the attached database to show how it works. Since I am very new to access i find it difficult to apply your code in practice.. Thank you for your time. Fox

can the output be format 2014/1, 2014/2..etc