Recent content by Remeartificer

Just found a old HDD in the cupboard and attached it as the 2nd HDD and it seems to boot up OK. Why does this PC insist on a 2nd HDD before it will boot up?

HI folks Gave the mother my spare PC which has 2 HDD's. C & F. Win XP installed on C. Now want the F Drive back to fit in my PC. Looked in Windows Explorer and the F drive is empty. Formatted the F drive and all went OK. Removed F Drive and then rebooted. Machine failed to reboot, saying...

I need something like >0 but not = [Form2QuoteAmount], "Pending", But I also need to inc the open & closed part. Please help :)

Yep, happy that this is working. But now want to add to it: So far I have a status showing OPEN, CLOSED. But I now want to add PENDING. So any amount under the quote amount, but not zero, needs to change the status to PENDING. Any suggestions?

Revised: =IIf([PaidAmount]=[Form2QuoteAmount],"Closed","Open") I think this is working.....

Would it be simply: =IIf([PaidAmount]=[Form2QuoteAmount],"Open","Closed") ?

Many thanks for your reply Remou. May I ask another question now I have seen your solution? The person I am setting this up for has now said that occasionally he makes part-payments, which would mean that the account wouldnt be closed if only half was paid. I would now need a formula that...

Need help with the "IF" command Please I have a table called "tblTasks" In this table I have two fields: "Status" and "PaymentDate" My aim is to acheive the following: If the field for payment date is left empty then the status will read "OPEN", but if there is a date entered then status...

Switchboard - How do I password protect a button? I have searched how & low and I am now pulling my hair out. 9 out of 10 answers I have googled waffle on and explain poorly. Basically I need to protect one button on my "Main Switchboard" so the idiots cant access a form. When the idiot clicks...

I want to use the Access Switchboard to make it easier to control the Database navigation etc... By default, it uses the horribly designed switchboard form that comes by default. Is there a way of getting Access to use a template of my choosing?

Apologies. Learning as I go on. Lesson learnt and thanks :)

I am determined to get to grips with expressions in my database. Can anyone recommend a good site where I can see some tutorials and examples etc..? Thank you.

AlexMidd Well firstly I have to say sorry for doubting you. I have done the sad thing and brought the file home to test again and it worked :) Secondly, I would like to say a huge thanks for sticking with me. It was much appreciated. Kind regards

Outlook 2002 meeting invite - Update problem I work within a place where you have to have "Internet-allowed" at the start of all your subject headings to allow it to go outside of the company. When I send out an invite for a meeting I simply type in "Internet-allowed" and all is lovely. The...

=IIf([reportdecision] = "Accepted", Sum(