Search results

  1. S

    Solved Subform Record Source - Method or data member not found

    @plog : Nope, I still get "Compile error: Method or data member not found". Regarding the query, yeah that's why I didn't post it in my top line post. Essentially, it filters recurring tasks so that I get 1) any tasks that get done every day, 2) any tasks that recur every [whatever day it is...
  2. S

    Solved Subform Record Source - Method or data member not found

    I'm almost wondering if this is a scope-related issue but I can't work out what it would be since I've used MsgBox to verify the query is coming in correctly.
  3. S

    Solved Subform Record Source - Method or data member not found

    A SQL query in the form of a string. The full function is as follows, and it's being run from a module: Function GetDailies() As String Dim dayNum As Integer Dim wkDay, wkNum, mth As String dayNum = day(Date) wkDay = Format(Date, "ddd") mth = Format(Date, "mmm") Select Case dayNum Case...
  4. S

    Solved Subform Record Source - Method or data member not found

    I have a dynamic query which is generated by a function (it updates every day). When my parent report loads, I want it to pull in the subreport using this query. Currently, I'm using this code: Private Sub Report_Load() Dim dailyQ As String dailyQ = GetDailies() S_RecurSub.SourceObject =...
  5. S

    Query that excludes entries from last year if they have registered for current year

    Oh, the subquery is probably perfect. I didn't know what terms to use to Google my problem in this case so I wasn't getting anything useful. Thanks!
  6. S

    Query that excludes entries from last year if they have registered for current year

    I am trying to run a query as a mail merge source. The purpose of this query is to pull up a list of anyone who sponsored an event last year, and to exclude from that list anyone who has already signed up to sponsor the event this year. Essentially, I'm filtering to people who sponsored the...
  7. S

    Query Criteria not pulling properly

    I think that it's easier to understand what plog is talking about with an example and some general concepts. Access is based on the *relationships* between data. For instance, a salesperson may make multiple sales. A dealership may have multiple salespeople, etc. Access makes it easy to keep...
  8. S

    Can I import .csv file in Access from Excel VBA

    Ah, yeah I can understand that...I'm stuck with this frustrating dinosaur of a computer at work so I've started doing neck stretches whenever I'm sitting and waiting for a really big PDF to be sized down. (Can't do anything else while waiting or it hangs up the PC.)
  9. S

    Solved Error referring to object in form with query as record source

    Actually simply the line Me.Requery did it! I guess that in this case, I needed to use Me.Requery insead of Me.Refresh (I'm guessing because the form is pulling from a query.) And now I have two new methods (.Dirty and .Requery) to add to my toolbox. :)
  10. S

    Solved Error referring to object in form with query as record source

    Hrm. Now I'm having issues because when I try to refresh, it doesn't show the change, and trying to force a save doesn't work. Is this a case where I should be using DAO to update the record instead of doing it this way perhaps, and then just refreshing my record when that's run?
  11. S

    Solved Error referring to object in form with query as record source

    As a note, I renamed the thread based on the actual problem so that it's easier for people to locate it when searching the forums for a similar problem.
  12. S

    Solved Error referring to object in form with query as record source

    Got it. I was trusting Access to build the Query for me. Is the issue that I had pulled in [Junction Events-Vendors].Inactive twice in my original query? Also, thank you very much!
  13. S

    Solved Error referring to object in form with query as record source

    Oh, and the code fires when you hit the little "X" icon. (This is meant to be a soft delete that hides a record by making it inactive rather than truly deleting it.)
  14. S

    Solved Error referring to object in form with query as record source

    Here you go! I am currently working on the form labelled "Subform Vendor List". It should write to the "Inactive" field in the "Junction Events-Vendors".
  15. S

    Solved Error referring to object in form with query as record source

    I eventually don't want to have it visible on there, but I put it onto the form for troubleshooting and I am still getting the errors shown here. Yep, stand by.
  16. S

    Can I import .csv file in Access from Excel VBA

    You'd think by the time they had like...20,000 rows someone would have been like "There has to be a better way than this." But the power of inertia is crazy!
  17. S

    Solved Error referring to object in form with query as record source

    Nope. Returned Error: "Microsoft Access can't find the field "Inactive" referred to in your expression."
  18. S

    Can I import .csv file in Access from Excel VBA

    This video walks you through how to import records: How to Import a CSV. This one shows you how to export records: How to Export a CSV.
  19. S

    Solved Error referring to object in form with query as record source

    I have a continuous form filtered to a query, so that it only shows entries where the inactive box is NOT checked. When I click a button, I want the current record to update to change the value of the inactive field to 'true'. The query which is the record source for this particular form looks...
  20. S

    Can I import .csv file in Access from Excel VBA

    Hello, it sounds like you want to use Access to filter down the data, right? Since doing a macro in Excel will take so long to run on such a big dataset. You can easily import to Access by going to External Data > New Data Source > From File > Text File. Filter the data using a query and save...
Top Bottom