Recent content by akaivyleaf

Thanks for this bit of code... let me play with what you've offered up and see where I come in. I'll post more as I progress.

I don't think you can write a blanket select statement that will get what you want. The best you can do, if you included a comma in the fullname field, is to separate everything into at least two separate colums Last Name which would be everything before the comma, and then First name and...

I have a database that keeps extensive data on response times, by date. I want to get the top 14 people who responded to EACH incident on a selected date. (There could be instances of 7 or 10 incidents per date and 14+ people responding to each incident) I believe that some incantation of Top...

Thank you both for the excellent tip. They both worked and accomplished my goal. I appreciate it.

Hi all, I would like to convert a general number into a time format dynamically. Currently time is put in without colons separating the hours, minutes and seconds. It appears as such: 95904 I need the number to appear as 9:59:04 Is there an easy way of converting this text into a time format?

I want to password protect a powerpoint presentation or at the very minimum, make the file read only. Can this be done? I have a number of enterprising co-workers who like to tinker with things and make changes-often inappropriately. Can I by chance, make a file that has to be stored on a...

Yes but to put the information in the Wrkgdadm.exe is the problem that I'm having. No work around for that?

Any more suggestions? I can't set up security again as I don't have access to the Workgroupadmin file. Plus some users have been able to keep 97 on their machine so the database has to be used on dual systems. Is that going to create further problems?

Yes I have a record source, the table or the form... but there is no data in the table... Thus the form, and report are blank. Sharon

I know I've asked before, and received an answer but I can't find it in my search so if you don't mind let me ask again, and be prepared to print the solution. I know that I shouldn't print a form, but we have monitors that go out in the field and would like to take a blank report in paper...

Including the security, or would I have to set that up again. I guess my biggest concern with converting anything is that I cannot access the wrkgadm.exe file as my network locks me out of anything remotely address administration of something on the network. My fear is that converting anything...

That means that you have both 97 and 2000 running on your machine? That also means that you can still access the wrkgadm.exe file? I can't do either. Such a joy working with IT when they decide what you need to do your job, but that's another rant. If you are saying that you don't have 97 on...

Has anybody done this? I have a database that was created in 97 and works like a charm. Security has been set, users are able to log in and out etc... Now our IT department has rolled out 2000 enterprise wide. I've attempted to open the database and get an error that states: The current user...

Maybe I need to modify my original request. In light of what was said above I wouldn't have to use a begin date at all when I'm trying to find all those person who don't have an end date at all or ended 4/1/01 or later. How would I write that? This is my formula so far which returns all the...

I want to be able to show records from the database where the beginning date is between 04/01/01 and 6/30/01 and exclude those records that in that date range that have an ending date that is greater than 3/30/01. I can of get the report to work with either of these statements but not with...