Search results for query: *

I have a form with a number of member records. I want to print a document for each of these members with their data in it (the merge works fine), and then close the document, but this seems not to work well . This is the code I use, any comments are welcome . Dim objWord As Word.Application...

I'm haveing a table with a birthday, stored as 12.11 for the 12th of november . I'm trying to make a query, to select only records with a birthday between dates d1 and d2, but Access always tells me that the query is too complex to evaluate. Sometimes, I succeed in retrieving the query, but...

I'm developing a form in wich I dinamicly create a query. This query causes me trouble (2001 runtime error : You cancelled last operation) and I'd like to save the query I created at runtime, to find out what's wrong with it in the query window. I tried to message it, but this way I cannot copy...

I made a little application, and for testing everthing (forms, tables) was located in the same mdb file. Now I have to separate the forms from the data, and I cannot realy find how to do this. The recordsource of the form was set at runtime (depending on a few criteria) , I hope I'll still be...

Thanks guys !

All, I have a table with member data. I wanna retrieve all member that have their birthday in the next n weeks. I have one problem i cannot get solved : Today + 1 week shows me the correct data. Today + 2 weeks also works well (combining datepart and dateadd functions to compare the dates)...

All, This is what I wanna do : (newbie question ....) I made a form, based on a query. In that form, I have a header part containing a text box, and a detail part containing record information from a query. In this query, the text box from the header is part of the where clause. Problem is...

Thanks, the DateAdd function is what I was looking for. Is there a way to use this to compare dates only regarding the day and month (without year) ? Reason to do this is to compare the month and day of a birthdate with the actual day and month.

All, I try to make a query to show only records of people that are born in the next week . I found something working like this : SELECT members.* FROM members WHERE (((DatePart("y",[members].[BirthDate])) Between DatePart("y",Date()) And...