Search results

Thanks Bob but no luck - However I just had the "a hah" light come on. The record needs to be there before you can retrieve it. I am trying to produce a list of everyone who is having/had a birthday in the past seven or the next seven days. The reason it is not producing any results is...

Hi In a query I am trying to return all dates (birth dates) within seven days either side of the current date. The properties of the field and the query are set to Medium Date and the criteria I am using in the query is: Between Date()-7 And Date()+7 and returns nothing. I have tried...

Hi, I am using Access and Word 2003. I have a query listing a number of people [Witness] and a number of questions [Question] for each of those people. Because I need the flexibility of a Word document I have created a mail merge document (based on MS KB Q294686) that uses the query to...

I am not too sure if the question was seen to be too hard, too basic or too confusing to not attract any responses. Anyway I have persevered and found a work around. Knowing how frustrating it is to see a problem described here and similar to the one you are trying to nut out, but the answer...

Hi, From this forum I have been able to include a double click on a listbox to view the selected record in a form. However I am having difficulty filtering records on a continuous form by double clicking a listbox field. The subform is populated by a query and while initially I need to have...

Thanks Rich. Using Control Source makes the difference. Obviously the problem has been operator error!

Experiment with the code result. As promised, this is for the information of Bob and Roy if you are interested, I do not expect a response. I experimented with the combinations and please excuse any errors in my description of the problem. I am a part time access user tinkering with programs...

ChronoDate is a date/time field. I initially had Chronoday as a date/time field but after the errors I thought I would try a text field and convert etc. With more time permitting over the weekend (yes Roy the week 'ends' tomorrow Saturday) I will try the suggested combinations and post the...

Tried that Bob but kept getting the same error as antonyx. I will try again with a clearer head when I experiment with Rich's suggestion.

Thank you Roy, I used the system suggestion and works fine now. I will also experiment with the "better" method suggested by Rich. I had no success the first time around. Thanks again. Allan

Follow Up to Displaying the day of a given date. Hi, antonyx described my problem perfectly and KeithG's code works except the returned value is one day out (the day after the actual date). Can anybody provide a solution please? I have a need to record events on numerous dates in the past...

Tks Bob, Still on "L" plates for posting and building a db! Allan

Hi Grnzbra, That was the original code result. Thanks for the question however I found my error and included the correction as an edit at the start of my original post. Apologies if this caused confusion and the edit was not the correct protocol. Allan

Delete Reference: Trying combinations I found one that works!!! The second line should read: Me.Filter = "AdminDateCompleted Is Null" Hi, I want to filter records from a form with a button to isolate all incompleted tasks. Incomplete tasks are identified with an empty field...

I require to publish a report from Access (A2000 but running in Office XP) in Word and save it in that format. On occasions a report generated will consist of two full pages with one Memo field (narrative of the event recorded in the d'base) capable of extending the report to the second page or...

Wally I overcame the same problem by creating a second form (using the same query as the main form (frmSearches). ) and inserting the secondary form (frmNotes_short) as a subform. The ID (SearchID) for the main from being the link. I included some fields (file number, name of organisation)...

Sorry for the bother - operator error. During a process of elimation (by starting at the beginning) I found in the query for the main table used in the main form, I had inadvertantly included the table used to store the information for the subform, thereby duplicating it with the sub form...

Tks. Had not seen that question and responses but there were others along the same lines but could not provide me with answers. There is a one to many relationship and I have checked the cascade delete. Still a mystery to me.

I am working in A2000 and consider myself a novice Access user. I have one form in the d/base with a subform imbedded. The form derives the information from a query getting information from two tables (One main table the other a town/postcode table). When I delete a record from the form the...

I use A2K but also require A97 to maintain some older d/bases on other computers (friends and sporting clubs) not yet upgraded. I deleted some rarely used programs the other day to make room on C drive, Visio was the only MS program deleted. Yesterday, on attempting to add another control...