@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...
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
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()
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...
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...
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.)
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. :)
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?