Replies

I’m with Hans — not sure I understand completely either — but have you tried to analyze the results with a Crosstab Query? Sounds like that would help, especially if you include totals.

Kathi

I’m with Hans — not sure I understand completely either — but have you tried to analyze the results with a Crosstab Query? Sounds like that would help, especially if you include totals.

Kathi

Kip,

Thanks for your efforts. I had found the same article that you did, but even after rereading it I’m still not sure it says that he’s still using Access with the tablet. “Once bitten, twice shy” I guess since I was told I was going to be able to do the same thing with WindowsCE version. I’m excited to hear your rave about Office 2003. Since all the tablets being shipped now are XP, I’ll wait until 2003 comes out — heck, the price will have gone down by then anyways, right?

I had this same dilemna some time ago. Although I thought the Auto Dialer would work, I had no success with it. Instead I duplicated the report that I wanted to FAX as a separate report with the Page Setup set to use a my FAX as a Specific Printer. On the form I used a Print Command Button and it automatically launched the default FAX program and I selected the FAX number from that application’s address book.

Well, guys, you gave me just the answers I was expecting. Oh well, it never hurts to ask, right?

JFord,
You can’t find ANY real help in the Access Help files. This made me nuts a few years ago when I upgraded since I was used to everything being in one place. What I’ve discovered is that you actually need to be in the code area to get any real help. I always keep a blank, dummy form open just so I can open it in Design view, and click on the “Code” button. From there you can access the VB Help file. I like the “dummy” form because it doubles as a place to test code that you’re just learning.

I know you already got a satisfactory solution, but I had a similar situation which I handled quite differently. On a Labels form, which allowed the user to select Mailing Labels, File Folder Labels, Shipping Labels, etc. I added a textbox for Starting Row (named StartRow) of the sheet of labels. My support personnel are very conscientious about saving EVERY PENNY so they asked for this. The default, of course, is 1. If they have a sheet with 2 rows of labels already removed they simply change the testbox to the value (number) “3”. In each saved report (1 for each type of label) I put the following code in the OnOpen property:
Me.ReportHeader.Height = (1440 * Forms!PrintLabels!StartRow) – 1440
There are no fields in any of the report headers. 1440 is the conversion between twips (whatever they are!) and inches.

It works perfectly. As all of us loungers have repeatedly discovered, this program always gives us more than one way to skin a cat!!!

Just food for thought
Kathi

I’m not familiar with MarkJ’s calendar, so please don’t shoot me if it doesn’t match my familiarity of the ActiveX control provided by Microsoft.

Assuming you have the code to calculate the date in the second calendar, I would set the Value property of the second calendar to that result. Something like:

me.calendar2.value=me.calendar1.value + (3 days or 4 weeks, etc)

Depending on whether there is a default for calendar1, you would need to put this in OnUpdated property.

Good luck,
Kathi

I’m not sure I understand correctly, but it seems that you want the OpenReport command to be tied to a command button on the form from which you select the records for printing. What prints on the report as you have it now? Is stFormName the form that lets you select the records?
Kathi

I’m relieved to report that my confidence was not ill-placed. Put the code (me.miles = me.miles + 1) in the OnClick property, changed the AutoRepeat property to “Yes” and added a DoCmd.Repaint. Now it is EXACTLY what I wanted.
Thanks!
Kathi

Paul,
Thanks for responding. Your solution was one that I had considered, however I don’t think it works without clicking 10 times to add 10 miles. What I’m looking for is something that lets the “add 1” loop for as long as the button is depressed. I’m thinking maybe a combination of KeyPress, KeyDown, or KeyUp is possible but I’ve never even noticed them before. I’ve seen the type of thing I’m trying to accomplish in so many non-Access applications. I’ll keep plugging away — with the utmost confidence, of course
Kathi

Jennifer,
If you don’t already have one, add a “school” footer – it can be blank if you want – and from the property sheet for the footer, change the Force New Page property to “After Section” (it’s in the Format tab).

Good luck
Kathi

Hey John,

I don’t always have the most elegant solutions, but try this…………………………

Assuming the date of the agreement is named “testdate” the agreement fields would be:

AgreementStDate=testdate+1
AgreementEndDate=CVDate(DatePart(“m”,[testdate]) & “/” & DatePart(“d”,[testdate]) & “/” & (DatePart(“yyyy”,[testdate])+2))

Both fields should have their format set to the appropriate Long Date, Short Date, whatever.

Hope that helps!
Kathi

Shane,

Thank you so much! I knew it had to be simple, but my little brain just couldn’t get there.

Kathi