Recent content by Chrstine Pearce

Mile-O-Phile out there? RE: Passing data from one form to another Thanks for that, Pat. I wouldn't have known to do that and will come in very useful for other routines I'll have to write in the neare future. However, it doesn't really address the current problem, which is one Mile-O-Phile is...

Me again. Attached is my file, prepared per your instructions. I can't thank you enough for taking the time to help me! Regards, Christine

Oh NOooo, Mile-o-Phile... I am running Access 2002! I don't think it is possible to save it in older versions! Am I sunk? :( Christine ... now panicking

Thank you for being patient with me! I will try to answer each question as you posted them. Ok, I'm guessing CAR is an acronym for some sort of complaint or problem reporting. ---Yes, Corrective Action System. CarNumber: - primary key (autonumber????) ---Yes, it is an autonumber...

Re: Re: Please Help Quick! Continuing Problem passing data from one form to another Hi again. The primary key in the CAR table is CARNumber. Other fields in the CAR table include: CARDate SourceCode ReasonCode UrgencyCode ProblemDescription Product Customer Process Manager (employee name)...

Thanks for responding so quickly, Mile-o-Phile. The link is one to many. In the CAR table, there is a field called RequestorID. The link between the Employees table and CAR table is between EmployeeID and RequestorID. (This is because there will be more employees listed in the CAR table for...

I've been struggling with this problem all week, so if there's anyone who can respond quickly I'd be much obliged as I’m about ready to shed a tear or two over this! I have set up the following. (Note I've included ONLY the field names relevant to my problem.) A table called CAR with a...

Fizzio, DAH! - I see now what you meant by the follow hyperlink method - it's not a command! At any rate, I figured it out!!!! :- Private Sub Attachment_Click() If IsNull(Attachment) Then DoCmd.RunCommand acCmdInsertHyperlink Else ' Do nothing: the hyperlink opens automatically...

Fizzio, I don't see that there is such a think as a "acCmdFollowHyperlink", if this is what you meant me to do. Cheers, Christine

I table has a field called Attachment, formatted as a Hyperlink. The field appears on my form with an On Click Event Procedure. Private Sub Attachment_Click() If IsNull(Attachment) Then DoCmd.RunCommand acCmdInsertHyperlink Else DoCmd.RunCommand acCmdOpenHyperlink End If End Sub...

Thanks for your quick response, AlienRay! Your suggestion is good, but there is actually alot more info available to the user than I included in my plea for help, which would make the combo box quite large. In addition, with over 100 employees the box would be really long, and in the current...

Hi there. I'm a frustrated FoxPro coder tried to come to grips with Access -- I don't understand it at all! Please help! In a form called frmCreateCAR, a user wants to automatically complete contact details: Name Phone Email Mobile Do do this, the user clicks a buton named...