Recent content by seekinganswers

Nevermind. The problem was with the shortcut switches.

It's actually a Outlook roving client run time -9 error, subscript out of range.

After migrating to Exchange 2000, Outlook 2000 users with an XP OS are receiving runtime 9 errors. Deleting profile resolves, but there are far too many. Any ideas?

Hi Chris, Thanks! That worked. Sorry I'm getting back to you so late. I got sidetracked. Thanks again!

Hi Fred, Thanks for getting back to me. I tried this earlier by updating all the letter grades to number grades, and didn't get the results I want. This data was downloaded from a Web site as comma quote delimited text and imported into Access, so it is what it is. A student can have anywhere...

I need to show who made honor roll. Seems simple right? So where do I put the criteria which is >="B" AND no "F". I've tried queries and report footers without success. Layout as follows: GradesTbl ID Name Course Teacher Grade MP1 Each student has at least four...

mharroff That sure would be helpful. Of course I've blocked mdb files on the Exchange server due to the risk potential. Could you zip it and send it to mhealy@ccts.tec.nj.us? Thanks!!!!!

As Curly said, "I'm trying to think, but nothins happenin!" If I have an Emp table; EmpID Name Title Date of Hire And a OT Tracking table; OTID EmpID Date of OT Hours worked/refused Number of hours worked Can I get a form to open at the next person who should be asked to work based...

Thanks Randy. I guess I misunderstood. I'll give it a try.

Hi, Thanks for getting back to me Randy. I don't think I explained the problem well enough. The report must be in the format of the current board agenda and look as follows: 12/12/2002 02-50 Athletic Equipment/Smith, J./Athletics Amt. Bid Amt...

I need to find the lowest bid of a line item. Then I need to sum each vendors lowest bid for a report. My Tables: TblBid TblLineItems TblVendor TblBidTrack BidID LineItemID VendorID VendorID BidNo BidID VendName BidID BidDate...

I've tried manipulating what you sent me without success. Would you be willing to take a look at the database? I can zip it and email it.

Thanks for the reply. I'm fooling with this. No success yet. I'll try again tomorrow.

I can't seem to get my head around this one. A public school sends out requests for bids. The vendors fill them in and return them. Upon return from the various vendors each bid is compared line item by line item. If a vendor bids low on line items 1 and 6 that's all the vendor is awarded. My...

I've done this a few times. The SQL for the Lookup is: SELECT TblName.FieldID AS xyz_ID_xyz, [FieldID] & ', ' & [Field2] AS xyz_DispExpr_xyz FROM TblName