BleepingComputer.com: Need Help with Access 2007

Hello everyone. First off, i'm new to access, i've never used it before, but i'm helping a friend at the office.
We are using access 2007 on a pc running vista.
I've surfed the internet for a while trying to understand how to run a macro with a SQL query in it, but i just can't seem able to make it work. It keeps saying that i'm trying to use a function that office can't recognize.
The macro is a button that, when clicked, runs a certain code I made as a tester (which is probably the problem). The function code is:

Function Revisar_Calendario()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim qdef As DAO.QueryDef
Dim consulta As String

Set db = CurrentDb
consulta = "SELECT Plazo FROM Actividades WHERE Plazo - Date < 7 Days"
Set rst = db.OpenRecordset("consulta plazos")
End Function

The idea is to go through a table and gather the items which are coming to a certain date (and, if possible, send an email alerting the participants, which shouldn't prove very hard once i get the hand of the syntax)

Please, if someone could guide me a bit, it would be wonderful. I've searched for tutorials, but haven't had any luck with the ones i've found, so if anyone has a tip there, that's also greatly appreciated

~Pedro
---------------------
I guess that instead of "7 days" i should use "Date - 7" or something of the sort? I never understood very well the dating systems...

This post has been edited by petocities: 15 January 2009 - 11:11 AM

Hello petocities,

You might want to start by going to this website: Martin Green's Access Tips

It has help me get through some rough spots with SQL in VB code. The areas marked Access and SQL Part 1 (thru) 4 should be of interest to you.

glnbnz, on Jan 15 2009, 04:54 PM, said:

cheers mate ;D

Ok, i've been through the page posted before, but i still can't manage to handle access 2007 pretty well. It just keep giving me trouble with forms and subforms (Office access cant find the field referred to in your expression), and i don't know how to fix the problem. Also, i can't seem to be able to make the code in the macro work.
First it the problem with the forms. I have a form with subforms. The first one is supposed to show data from a company (name, etc). The subform that is giving me trouble (by saying that access can't find the field bla bla) is a subform that should show (and it does!) info from activities within the company.

the other problem i have is that i can't run the code i posted before (probably it has to be corrected) because access says that it has a function name that can't be found!

Function Revisar_Calendario()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim qdef As DAO.QueryDef
Dim consulta As String

Set db = CurrentDb
consulta = "SELECT Plazo FROM Actividades WHERE Plazo - int(Now()) < int(#12/30/2020#)"
Set rst = db.OpenRecordset("consulta plazos")
End Function

please, i need precise ways in how to fix this, because i seem to be skipping something that i haven't noticed through the tutorials

This post has been edited by petocities: 19 January 2009 - 11:07 AM