Search results

function NZ in access 2013 removed a similar Problem with the function IsNull

Problem is when conditional expression is long or very complex, ploblem is in readability formula , or a copy complex expression again. I use for example very simple expression.

In many case using IF function in excel I must use if condition expression when true as value, example: if(condition >=0;condition;expression when false) if (5+3 > 0; 5+3; 0) is there a shorter way for use

Are new, empty record in form have recordset presentation, how to get recordset in form for empty row?

I'll try to give more explanations commenting code Private Sub Dokument_KeyDown(KeyCode As Integer, Shift As Integer) 'Dokument is field defined as attacment type 'I want get scanned document, that stored as pdf file in application folder 'and attach it in current field, whether in existing or...

Thank you for your ansfer, Im use Naps2 scanning software and make following procdure: Private Sub Dokument_KeyDown(KeyCode As Integer, Shift As Integer) Dim currentrs As Recordset2 Dim dokRecordset As Recordset2 Dim BrDok As Integer If Not (KeyCode = 65 Or KeyCode = 83) Then Exit Sub '65...

I have hp scanner whose twain driver has the option to scanning in the pdf document. Microsoft WIA 2.0 have save scanned document only to graphical format. I want automated (on click any button control) to scan multipage document from glass source or ADF to pdf document and attach it to...

Thank you, for your ansfer, this problem occurs in sub-subform, in tab control that occurs sub-tabcontrol, solution is in simplification of forms. It is sad that MS Access can not perform any stunts, but need to think simply.

Hello, I use before insert code procedure to insert default value for one, or more fields in row. It is normal to have these fields are disabled. This event occurs when you try to enter a value in any another field in a row. However , when I finish entering the field going to the event before...

Folowing code returned run time error '6': overflow Dim MeDok As Recordset Set MeDok = CurrentDb.OpenRecordset("SELECT * FROM Dokumenta WHERE " & _ "[dDok] = #" & Format(Me.[ddok], "yyyy-MM-dd") & "# ", dbOpenDynaset) dDok is date field in table Dokumenta me.ddok is date field in form me...

Private Sub check_EmployeeAddress_Click() if me.check_EmployeeAddress then Me.eCurrentAddress1 = Me.ePermanentAddress1 else Me.ePermanentAddress1 = "" end if End Sub

Try me.permanentaddress1 = me.currentaddress1 you copy vice versa from empty field to the filled field

I solved this problem, solution is in fact that next navigation control are level off last navigation controls than are in form, you can create multilevel navigation form, only last level can be in vertical orientation. :p I can describe in detail the solution with screen captures just need to...

How to Creating a Three-Level Navigation Form, First and second level must be in horizontal orientation, third level desirable be to vertical orientation and dependent of level 2. :banghead:

Combination horizontal and vertical navigation form results them what horizontal navigation button offered set off vertical navigation buttons that realized concrete form. Navigation form with two levels offers group set of form in first level. Me need offer grouping vertical navigation...

:banghead: I want create combination of navigation forms, navigation forms with two horizontal level and vertical level that link to navigation buttons in second level of horizontal navigation. Please help me!

I like to share my solution when I find that I can be useful to others in the community , and also would like to thank everyone who participated by giving me advice. I'm always grateful amendments and suggestions for enhancements to the solution. Note: 1. field RedBr is sequential number filed...

Hi, 1. Which event occurs when anything changes on subform (Delete row , add row , perform the sort, Especially when you add a row to be inserted in the current sorting between the rows) 2. I have column sequential number that need updating when occurs any event on subform 3. "On current" is...