Use of CurrentDb.OpenRecordset in VBA

See also questions close to this topic

• VBA: why I cannot use "=" to transfer data from one sheet to another sheet?

  I want to use "=" operator to transfer data from "Sheet1" to "Sheet2" because it is fast. However, the following code doesn't work:

  Sheets("Sheet2").range(cells(1, 1),cells(1,5)).value = Sheets("Sheet1")
  .range(cells(1, 1),cells(1,5)).value
  

  Why?
• Delete hidden rows in auto-filter in coauthoring spreadsheet

  What I want to do is to reset the filter then delete all the rows below row 9.

  This should be a easy task, but this is a coauthoring spreadsheet, i want to avoid using ActiveSheet.ShowAllData as this will require all people to refresh the spreadsheet.

  I tried to use keybd_event to simulate ALT+A+C to clear the filter, but it dosen't quite work.

  keybd_event VK_Alt, 0, 0, 0
  keybd_event VK_A, 0, 0, 0
  keybd_event VK_A, 0, KEYEVENTF_KEYUP, 0
  keybd_event VK_Alt, 0, KEYEVENTF_KEYUP, 0
  keybd_event VK_C, 0, 0, 0
  keybd_event VK_C, 0, KEYEVENTF_KEYUP, 0
  
  Worksheets(1).Rows(9 & ":" & Worksheets(1).Rows.Count).Delete
  

  My thought is when the marco simulate alt+a+c, the hidden rows do not show until the whole macro is finished. So it only delete those visible rows, and after the macro finished, those hidden rows come out.

  Dose anyone know better ways to do it? Any help would be appreciated! Thanks!
• How to play windows media player in VBA, starting from a spesific duration

  I am doing a project of video based analysis. I want to know how to play a windows media player in excel using vba, for a specific time, such as playing the video from duration 00.06 until 00.14. Because the current state that I have known is playing the video using vba code from 00.00 to the end of the duration.

  Thank you, your help will be much appreciated
• System.Data.OleDb.OleDbException: Undefined function 'ConcatRelated' in expression

  I'm working on a c# winform software, connecting to local MS Access db (.mdb)

  Connection string used is Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb and it's kinda considered a requirement, Ace is not an option.

  I'm trying to use the function ConcatRelated but keep encountering error: System.Data.OleDb.OleDbException (0x80040E14): Undefined function 'ConcatRelated' in expression.

  My query below:

  string carColumnsAndTable = "SELECT c.Id, cust.CustomerName as InsuredName, c.CarPlate as VehicleNo, c.CarMake as Make, c.CarModel as Model, c.CarYear as VehicleYear, c.CarCc as CC, c.CarChasisNumber as Chasis, c.CarEngineNumber as EngineNumber,  "
      + "ConcatRelated('d.DebtorName', 'CarDebtor cd left join Debtor d on cd.DebtorId = d.Id', 'cd.CarId = ' & [c.Id]) as Debtor "
      + "FROM ((Car as c) left join Customer as cust on c.CustomerId = cust.Id) ";
  

  And function setup as in screenshot below:

  

  Query works fine in ms access:

  

  Anyone got any clue on what I should do to resolve this?
• Subtracting 2 table columns using SQL in MS Access

  I need help subtracting 2 table columns' values using SQL in MS Access.
• Select statement unable to find argument name misspelled

  My table sec1202 has four columns: row_id, col_1, col_2, and col_3.

  I have been given this task:

  Write a select statement that groups the rows by the value in col_1 and for each group determines the sum of the values in col_3.

  Here is a screen shot of the SEC1202 table

  

  Here is my code:

  select col_1, count(col_3) as column_three_values,
  from sec1202
  group by col_3;
  

  Here is the error:

  The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect

  Any help would be greatly appreciated!