Search results

Thank you. I didnt know how to frmInvDetails to link with frmInvoice. Could you explain little about working of this. foxtet

Hi Guys, In the database I have Billing details form. I want add items to frmInvDetails. so that the invoice # should be from frmInvoice. Sample db is attached kindly work a solution for this foxtet

Thank you!

Thank you. Is that possible format the vale displayed in txtTot in the format shown below eg: 1,200.00 instead of 1200 foxtet

Exactly you solved the problem. Thank you foxtet

Hi Guys, I want the the text box (txtTot) to display sum of the amount colum of qryConsigneeExpDetails subform, I used the following expression as defult value of txtTot but it displays sum of query amount total. =DSum("[Amount]","qryConsigneeExpDetails") What can be the solution to display...

Hi, I found this problem when I put my Access forms to larger size screen. My forms look too small on the screen. How to make it automatically fit to any monitor with any resolution? Thank you! foxtet

It worked. Thank you for great help. foxtet

How to apply this function in a text box demReason.

Dear Guys I am using a form to enter data in which I want to capitalize the first letter of the sentence. I use the following code after update event of the text box Me!DemReason = StrConv(Me!DemReason, vbProperCase) This gives first letter of each word in upper case. Any suggestions...

provided code worked but it's good that if error message displays immediately after leaving date field. code can execute; after update or on lost focus of date field. could you work on a solution which can work as mentioned. foxtet

First of all Thank you for your help on this post It worked well for clearance tab. In loading details tab the criteria is check for flight date and clearance date goods cannot be loaded on before these dates. the logic i'm expecting is like; if loaded date < flight date msg "goods not...

Hi Guys how can I reference to field flightDate on tblCargoMaster I want flight date to be earlier (older) than clearance date. Private Sub Form_BeforeUpdate(Cancel As Integer) dim fd = flightDate If Me.ClearedDate < fd Then Cancel = True MsgBox "Goods not arrived, try again!" End If End Sub...

In this program I need to check for date validation for the following 1. Cleared date 2. Delivered date Already flight date is entered while entering new cargo. So now I have flight date entered First open frmCargoSearch when double click to MAWBNo field frmCargo Master opens. In this form I...

Flight date is cargoMaster Table the reference is not available in frmClearanceDtails. How can Flight date be available in Clearance Details form? foxtet

very ideal solution

Hi Guys In the attached sample Db there are following tables 1) tblCargoMaster 2) tblClearanceDetails and 3) tblLoadingAndDelivary in the frmCargoSearch when double clicked MAWBNo field frmCargoMaster opens. In that form I have provided tab control in it there are two tabs clearance, Loadding...

Hi Guys When ever I open the database I need to display frmSplash as splash screen for 4 seconds and open frmLogin. If any solution please share. foxtet

It worked! Thanks

Double click event of sub form.