Recent content by hays

Hi I've been trying to fix a co-worker's database. The original problem was an absense of dll files on his new computer but I *think* that I have set up the necessary ones. A query of his is simply: UPDATE DISTINCTROW Last_Import SET Last_Import.Import_ID = Date() & " " & Time()...

A co-worker of mine recently upgraded his computer. As a result, an Access database of his fails because it cannot locate Msjter35.dll. The insertion of Msjter35.dll into C:\Windows\System does not work. How would I solve this problem? Is there anyway around this? (such as deactivating...

This is a newbie question but... I have 3 essential pieces of data: the service type (STYP), the service category (SCAT), and the consumption (BILLED_CONSUMP). I'm trying to derive a query where I have STYP, SCAT, and then the sum of BILLED_CONSUMP grouped by STYP then SCAT. I haven't had...

This is a newbie question, but what do I have in place of object constructors (like in Java). And can I have multiple constructors for a single object? (different params?) Thanks.

Hi, I'm working with two recordSets. The first grabs a list of meters and the corresponding maximum for each meter throughout the month. The second grabs different readings for each meter, and only on select days. What I am wanting to do is to come up with a recordSet that has the maximum...

Thanks.

In a subroutine I have the following code: SQL = "select CALENDAR.DATE from CALENDAR where Format CALENDAR.DATE,'mmyyyy')=Format(" & desiredDate & ",'mmyyyy');" Set daysOfMonth = db.OpenRecordset(SQL, dbOpenSnapshot) where desiredDate is either "January 1, 2001&quot...

Thanks.

This is fairly trivial, but in a subroutine I have: DoCmd.RunSQL "INSERT INTO..." This leads to a warning box ("You are are about to append x row(s)") popping up. Since this sub will be run a fair number of times, is there anyway for me to bypass this box, or code in an...