Search results

  1. C

    Delete record using VBA

    It seems to be much easier to add something to an Access database than remove it. How can I remove an entry from an access database? I will know the primary key value for the record I want deleted.
  2. C

    VBA count sheets excel from Access

    I created a function in excel to give the sheets count worksheet level and pointed access to the cell to get the sheet count. Maybe not the best way but it works.
  3. C

    VBA count sheets excel from Access

    Excel.Application.ActiveWorkbook.Sheets(Sheets.Count) doesn't work gives Method of sheets error.
  4. C

    Table Name array macro

    I have code that does that but can't figure out how to get the data into an array at that point. always get some sort of error.
  5. C

    Access VBA Query Criteria

    Well the purpose of this database will be to track attendance on a week by week basis. With employee name and ID being tracked along with any marks against attendance.
  6. C

    Table Name array macro

    I need a macro that looks at all the names of the given database, excluses the Msys tables and then stores them into an array. I'm still not totally understanding how to create arrays. Maybe this is simple but I'm not yet there. Can anyone help?
  7. C

    Access VBA Query Criteria

    I'm not sure if I was clear in that a new query would be needed on a per week basis. Or is this what you are talking about? Is my brain so stuck in "excel" that I'm not truly grasping what I should be attempting to do in access?
  8. C

    Access VBA Query Criteria

    Using something I found on this forum I was able to get a different error message. See below for the new code I've tried. Private Sub cmbSubmit_Click() Dim TheDbPath As String Dim QueryName As String Dim SQLStr As String Dim Crt1 As String Crt1 = "ABS" 'First...
  9. C

    Query Criteria Problem

    I tried to adapt what was posted by this user to suit my needs. This is what I came up with along with the error I'm getting. Run-time error '-2147217908 (80040e0c)': Command text was not set for the command object Crt1 = "ABS" strSQL = "SELECT Weekof17July2011.EmployeeName...
  10. C

    Access VBA Query Criteria

    I've found many threads on the internet that have similar questions; however I have not yet been able to adapt any of other users problems to suit my needs as I am just trying to learn Access VBA, I've become decent with excel VBA but that is not helping me very much here. The problem I've...
View older results
Back
Top Bottom