Replies

Works for me!

I realize this is probably a stupid question, but just so we’re clear; you’re not thinking of the “Malicious software removal tool”, are you? That one doesn’t hang around when it’s “installed” every month by Windows Update.

You said “…I selected the range…”. Are you, perhaps, using Excel, not Access (if that’s the case, you still need to provide more detail, but you should also ask in the Excel forum, not the Access one)?

I agree with HansV – why? However, if you REALLY want to do it that way, one solution that comes to mind is to lock all controls except the first in your form definition (since you need a starting point) and then have the Exit event of each control unlock the “next” control and and the Enter event lock the “previous” control. That would still allow the user to click in the “next” control, but he wouldn’t be able to click in any of the others.

Yes, they’re turned on. In any case, I’m not getting any error messages pertaining to related records (like I’ve had in other databases when I haven’t turned on cascaded deletes). As well, it’s also happened when only a record in the subform is selected and deleted (so cascading deletes would be immaterial in that case).

You are putting in an actual page break, correct?

If you’re calculating the Standard Margin, why do you have the formula in the Selling Price cell? I don’t see anything in your description prior to the table that would necessitate a circular reference in either system.

Certainly, but I’m only referring to the specific concern of those four (five?) itsy-bitsy “system” text files. If you don’t KNOW that a file is useless (and a concern here is whether some program somewhere might be prehistoric enough to expect those particular files to be there) and the file takes up negligible space, then leave it be.

I agree 1000% that all the readme’s, EULAs, installation log files, etc. can be tossed.

I wouldn’t call 4 files “a lot”, and taking up a miniscule fraction of a percent of your disk space (assuming you have a typical disk these days that already has a lot of stuff on it), is pretty close to “not taking up any space”.

I don’t use a separate FTP client for sending stuff to my web space (a different ISP than AOL, but I doubt that would matter). It’s one of the few things I use Internet Explorer rather than Firefox for (I had problems once in Firefox even with the appropriate extension and didn’t bother trying to figure the problem out since I was so used to FTP’ing with IE).

I just type ftp:ftp.shaw.ca in the IE address bar (the ftp: is the important part – the part after the colon is specific to my ISP), enter my id and password, and drag and drop files.

I agree for the most part (the only thing I ever ask datediff for are the days between two dates and then for any other units I do my own calculations). However, there would be a “gotcha” in calculating the number of workdays – what about holidays? Since Access is not confined to the US, it wouldn’t be practical for datediff to take holidays into account, reducing the utility of automatically calculating the number of workdays between two dates.

Or use single quotes if you don’t want to remember the magic number for double quotes.

varHours = DMax(“Hours”, “tblSomething”, “EquipmentID = ‘” & Me.EquipmentID & “‘”)

That sure sounds like you’ve mucked up a criteria in a query (which may be part of the report) rather than anything having to do with your sorting.

I’m suspicious of your…

If TypeOf ctl Is Label Then
‘do nothing
Else
…
although I don’t have time to experiment. Seems to me you should be checking for several other control types that don’t have values as well (for instance, lines).

Try
Like [Forms]![Aging Detail Query Prompt]![Condo] & “*”