access vba

  1. A

    Run time error 31532- Microsoft Access cannot export the data.

    Hi, I am using below code to export table from access 2016 to excel but getting error saying: Run time error 31532: Microsoft Access cannot export the data Public Function ExportToexcel_DD() Dim output_fl As String stName = "\PRO" output_fl = CurrentProject.Path & stName &...
  2. A

    MS Acces vba function to get thursday as first day of week in current month and Wednesday as last week in current month.

    Function for get Thursday as first day of week in current week month, this function returning first week as Thursday but first week of month in last month, But K need it will return only current month. For example if 1st date of month is on Tuesday it will return 1st date of month. Function...
  3. L

    Access Maximum Function: Return the second highest value across a series of 10 fields

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  4. A

    Slowing code down?

    I'm writing vba to .addnew then .update a table. Once this is done, I want to clear the fields on the form that was used to update the table. SOMETIMES the longtext field is cleared before it's written to the table. If I take out the code that clears the fields, this is fixed. Why is it...
  5. jdsouza

    Shift Local MS Access database file to Web Server

    I have an Excel project which uses MS ACCESS for data storage. Works fine. The issue is that ... The project is used by multiple persons in multiple locations, making synchronization of data tedious (each one has to export what they have done via proprietary files and similarly import changes...
  6. T

    Excel Formula as a Access Expression

    Most of the formula functions I have used in this Excel doc. are not available as a Access expression. So to achieve what I have here > Retail rounding up to specific numbers (as well as calculating the retail) I have to start over in access Can anyone help or maybe I have to go to a access...
  7. A

    DLookup Format Issue

    I can't figure this one out. I keep stumbling my way through DLookups... Please help! x = Nz(DLookup("ID1", "AttendanceEvents", "EventDate= #" & txtRmvP & "# and USRI = ' " & fOSUserName() & " ' and (EventTypeCode = 'P' or EventTypeCode = 'SS-P' "), 0) I'm getting a mix of errors when I try...
  8. N

    Adding Unnecessary Blank row on import from Access 2010 (Windows 7)

    Private Sub cmdCreateChart_Click()Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Dim objXL As Object Dim lngLastDataRow As Long Set objXL = CreateObject("Excel.Application") Set dbs = CurrentDb 'Get the parameter query Set qdf = dbs.QueryDefs("qryCharts") 'Open a...
  9. S

    Run Access VBA from Excel or Run Excel VBA from Access?

    Hi, I have a report that I am automating. The process consists in an Excel VBA Macro that gives the format to some excel files and saves them in an specific folder for access to take these files and import them into the corresponding tables. I was able to automate this process through an Excel...
  10. S

    Need to Compact and Repair from VBA code

    Hi, I have a VBA code that deletes some old data from my database and uploads the new data into it from some excel files. The thing is that the macro stops in the middle and brings me the error that the database reached it maximum capacity but when I click the Compact and Repair button the DB...
  11. H

    equivalent code from Access VBA to Excel VBA

    is there an equivalent code for DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ in excel vba? this is the code im trying to currently use in excel VBA: Private Sub CommandButton2_Click() Dim fDialog As FileDialog Dim varFile As Variant Set fDialog =...
  12. A

    Import the data from EXcel

    Hi Guys, I have a button in Access Database, but i don`t have a functionality. I need whenever i press "Import Button" it will automatically open the filer and i will navigate to select multiple files of excel anywhere in my hard drive. when i import the data it will automatically import all...
  13. A

    Access Query

    Hi, I need a favor from you guys, I already made a button in Access, I need to import the files from excel through that button on Macro, whenever we click the button it have to be import the excel files in database by matching the two columns. here is the example Database: Col A Col B...
  14. A

    Searching Criteria

    Hi Guys, Thanks in advance for helping me before, I need your help again guys. I have a database with me with 5 columns in it with the name of Name, Age, Address, Phone number and Position. I need a searching criteria for them to make the reports. I made the form on excel with the text boxes...
  15. W

    CurrentDb.Execute returning 'Too few parameters' error.

    I have been building a Sub in a standalone database and have run into an issue with running a query native to the same database. I have in the same sub as part of an If function, another CurrentDb.Execute and it works fine; however, when it gets to the next part of the Sub, the secondary...
  16. S

    Need help in debugging this vba code.

    Hi, I'm very very new to access vba. Here's what I did(I'll explain with an example) - (NOTE: If status is inactive then column 32, 33 should be "No" and red. If status is "Active" then only next strings should be searched in column 13) Example - columns are - Status(4th column), Group(13th...
  17. H

    Run Access VBA Script from Excel

    Every day I run a VBA script in Excel. As soon as the Excel script is done running, I open Access and run another VBA script. I would like to add something at the end of my Excel VBA script to run the VBA script in Access. Any thoughts on how to do this? I am using Office 2007.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top