Recent content by Kiernan

Worked like a champ. Couldn't have asked for more. Thanks again, Remou.

I'll give that a go. Thanks!

I have another question, related to the first. I'd like to conditionally format a future date based off the current date. ie: something expires 30-Oct-07, I want it to show red 3 months before the date in the field. The field is M4_Expiration. Again, thanks in advance!

Hey, guys. I need help with a field that I'll want conditional formatting on a form and a report. Specifically, I have an event that happened with a date. I need the field to format to red if it's been 9 months or more since that date. For example, I have a field EPR_Closeout and a medium...

Still no luck after enabling the Guest account and setting no password. This PC is just determined that I'm not going to be able to access the primary drive.

Thanks for the suggestions, guys. However, neither worked. Actually, disabling simple file sharing immediately puts the whole PC into password mode when browsing to it from another PC no matter what the permissions are set to. Turning it back to simple at least lets me have access to the...

I just set up a brand new PC on my local workgroup. I have three PCs on this workgroup: Homepc, Gamepc, and Laptop. I've enabled file and print sharing on all machines. From the new machine (Homepc) I can browse the other shared drives just fine. No issues. However, when I try to browse...

I need to put multiple records into one detail area of a report. I'm using a bitmap as a background for a form and can't change that, so I need to list multiple records on top of it. If I just put in a bunch of LastName boxes, I get a bunch of Smith down the page. How do I make it pull the...

I have a database that I tried to run a compact and repair on. During the process, I got a ton of delayed write failed errors. Now the DB will not open. I get a message saying 'AOIndex' is not an index in this table. I've tried to run a decompile, another compact and repair, the JetCompact...

I put one drop on the HS, rub it in so it fills any scratches, then wipe it off. You should be left with a little residual silver paste. Then put one drop on the CPU and smear it around for full coverage about the thickness of a piece of paper. Then mount the HS. Just remember to clean the...

Or, better yet, is there a way to make one detail space in a report display multiple records? If I create all the rows in the display area and put the LastName source in the places I want, all I get is a run of Smiths, rather than subsequent records. How can I get it to display them all in one...

Maxtor has a new 16 MB cache HDD for ATA and SATA. I'm running one now and have been nothing but impressed. BTW, this Maxtor is a replacement for a 200 GB Western Digital that died. My WD was still under warranty through them and they're replacing it for me for free. You may want to check...

I'm trying to replicate a form we utilize at work. The form has 19 rows for individual names with data to be placed next to the names. Most people hand write the information into the blank forms. All of the information needed to fill in the form is found in a database we use, so I want to...

BNPMike, Thanks for your suggestion. However, that is a bit over my head. Any other ideas?

I have an Excel spreadsheet that performs numerous calculations based on user input. I have a database that requires the output information from the spreadsheet. Right now, we're typing the information into the spreadsheet, then manually transferring the information to our database. The...