Search results

  1. onur_can

    No Such Interface Supported

    Have you gotten the latest office updates? It may also be caused by the missing dll file. After running the command prompt (cmd) as administrator, enter the following code. regsvr32 c: \ windows \ system32 \ actxprxy.dll and check again.
  2. onur_can

    Hello every one

    Hello welcome.
  3. onur_can

    Solved Update table

    Open the Relationships window. Double-click the relationship line between the two tables and in the window that appears, select the option to update related fields consecutively and save and close.
  4. onur_can

    Hello

    Hi Welcome Aboard! I hope we can be useful.
  5. onur_can

    How do I create the table below

    id - Automatic Number name - Short Text dateofpayments - Date/Time credit - Integer debit - Integer totals - Integer You can create it.
  6. onur_can

    Solved Access not opening in editable version

    Check the security settings again. If necessary, remove the Trusted location and add it again.
  7. onur_can

    Relationships for Dummies

    read this article thoroughly. Table Relations Guide see also Table design
  8. onur_can

    First Letter of Word to upper case

    Can you pass the compilation error?
  9. onur_can

    I hate Access

    First of all, welcome. I can't help but say that. I've been working with access for many years. Meaningless and illogical events happened to me. But instead of blaming access, I always looked inside myself. I wonder where I'm making the mistake. These errors started to decrease over time. And I...
  10. onur_can

    DLookup with LEFT and RIGHT

  11. onur_can

    DLookup with LEFT and RIGHT

    the following sub procedure will help you. Public Sub PartCaption() '------------------------- ' onur_can ' www.accessapplication.blogspot.com '------------------------------------ Dim PartCaptionImport As String Dim PartCaptionLeftImport As String Dim PartCaptionRightImport As String...
  12. onur_can

    Default view in Forms

    Private Sub cmdSingleForm_Click() DoCmd.OpenForm "Form2", acDesign, , , , acHidden Forms!Form2.DefaultView = 0 DoCmd.Close acForm, "Form2", acSaveYes DoCmd.OpenForm "Form2" End Sub Private Sub cmdContinuousForm_Click() DoCmd.OpenForm "Form2", acDesign, , , , acHidden Forms!Form2.DefaultView = 1...
  13. onur_can

    Default view in Forms

    Burada kontrol edebilirsiniz.
  14. onur_can

    Default view in Forms

    you must open it from another form in design mode. such code may have been written. Private Sub Form_Open(Cancel As Integer) Me.Form.DefaultView = 2 End Sub
  15. onur_can

    Format Date

    do not include the / signs in your format. Start Date: Format([IW73 TBL with SN]![Start Date],"yyyy/mm/dd") Start Date: Format([IW73 TBL with SN]![Start Date],"yyyy mm dd")
  16. onur_can

    Drop Down Box is blank

    The combo box runs according to the value in the first column of the query found in the row source of the combo box. Whatever you used in the first column, you should show it as a criterion. Of course there are some exceptions. What are these exceptions? Let's say that the box that you open will...
  17. onur_can

    Creating a Password Generation form : (Problem)

    I do not encounter any problems when I use DAO.
  18. onur_can

    Creating a Password Generation form : (Problem)

    It is better to use DAO instead of ADODB
  19. onur_can

    Defining Variables

    Create a module so that you can use the variable in all forms and define a global variable inside this module. You can set the value of this variable no matter which form you go, you get a value in all forms and even in all reports. Global ReportVariableID As Integer
  20. onur_can

    Solved Is it possible to incorporate a query parameter in VBA?

    In the query design window, set [Enter Serial Number] to the criterion line of the serial number field.
Back
Top Bottom