docmd.setwarnings

  1. D

    Update the imported fields with Replace function

    Hi, Just want to have your opinion on how to resolve the issue, i have Text field to upload in my Table "Short Text", and i need to update the field SI_ICXX to remove spaces, however, i think it automatically converted to Numbers. Sample SI field(Short Text):12333 02 01 i need to update as...
  2. B

    Get Path store in Access Table

    I want the code to get the path from an access table. Table Name= (tblExportsImports) Field Name = (DailyReport_Export) Example: Set xlWb = .Workbooks.Open (tblExportsImports.DailyReport_Export) Code: Private Sub cmdSummaryReport_Click() DoCmd.SetWarnings False...
  3. A

    Proper User of Turning DoCmd.SetWarnings

    Hi all, Just a question, no real specific issue (at the moment). What are the best practices for turning DoCmd.SetWarnings to True vs. False? I've seen some programmers set it to false, run a couple lines of code, then set it back to true, and do that repeatedly throughout a program. My...
  4. H

    Importing .csv File and changing the Database parameter and file names to variables

    Hi all I will like to change the Database and File name to be variable on the below code Thanks in advance. Sub ImportCSVFile() DeleteTable 'Browse for Folder Dim selectedFolder With Application.FileDialog(msoFileDialogFolderPicker) .Show selectedFolder =...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top