Search results

I am using Access 2003 and want to add the Outlook library so that I can work with sending emails. My instructions say to use Tools / References but I don't see that in Access 2003. How do I add the Outlook library? Robert

John: OK, I like the look of that calendar. I am not clear how I would use that in my application though. How do I do that? Robert

I am looking at the ActiveX calendar control. It displays a nice calendar, but what can I do with it? I want the user to be able to click on a date and then make an entry on that date. Can I do that with this control? Robert

I have been asked to add a calendar to an existing application. Does anyone have the basis of a calendar program? In particular, how do I set each month out on the calendar grid, and then move around the grid with the cursor? Robert

Where can I get a document that explains how to use SendObject to send emails from Access? Robert

That's OK. I completed it by calling an append query in a loop, advancing the number in a control on the form for each loop. It works perfectly. Robert

Mark: There are many thousands of circuit boards, each with a numeric label. We already have tables with dates in stock of these boards, date of testing and sometimes date of repair etc. All that is long established and cannot be changed. I am adding a new table with the name of the tech...

I have a form on which there are two controls, first label number and last label number. Say these values are 1000 and 3000. Then a button which will create a record for each label between these two values. How do I create a sequential list of records like this, each with a label number (and...

That worked perfectly. Thanks so much! Robert

I have a form which displays an inventory record. The user can click a button to display the next or previous record. But there may be hundreds of records in the set, so this is slow. I would like to allow the user to jump to a specific record number, which they enter. How do I jump to a...

I have a form that is run by a query. What the query does is take a date from the form, and returns a date that is the end of the month, one year, three years and five years hence. I use dateadd() three times to get the new dates. The query runs fine. It gives me the three correct dates. But...

Jdraw: Here is the query: SELECT Max(ATTHRESHOLD.THRESHOLD) AS MaxOfTHRESHOLD, ATTHRESHOLD.THRESHECI FROM ATTHRESHOLD WHERE (((ATTHRESHOLD.THRESHDATE) Between [Enter the start date] And [Enter the end date])) GROUP BY ATTHRESHOLD.THRESHECI; This works fine except that because I am using...

I have a simple query designed to look up a maximum price of a range of items, and give the date of that price. There are three fields, price, item number and date. I am doing a MAX on the price, and a GROUP on the item number, so that gives the maximum price of that item, right? Then I want to...

Is it possible to send email from an Access application? I think I looked at this some time ago but could not get it to work. Is there an issue about linking to Outlook? Robert

That worked perfectly. Thanks!

I have a report where each record is on a new page. But the records are different lengths, so sometimes a new record will start on the same page as the previous record. How do I force a new page for each record? Robert

OK, that worked! All I was trying to do was to turn off the subreport based on two parameters. Making it not visible is easier. Robert

Paul: Where else could I set the subreport source object? Robert

I have a report with a subreport. I want to change the subreport's source object based on a couple of criteria, like this: If Right([DTACTIONFAIL], 6) <> "credit" And Right([DTACTIONFAIL], 11) <> "Replacement" Then Me.DTScanFAIL.SourceObject = Form.DTSCanEmpty End If I tried this on both...

I have a simple delete query which is supposed to delete records in one table if a match is found in another table. Here is the query: DELETE ENTR_HECIS.HECI, ENTR_HECIS.PARTNUMBER FROM ENTR_HECIS LEFT JOIN BELLCO ON ENTR_HECIS.HECI = BELLCO.HECI WHERE (((ENTR_HECIS.PARTNUMBER)=[PARTNUM]))...