Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Remeartificer

    Help!!! Removed spare Harddrive but PC now wont boot?

    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?
  2. Remeartificer

    Help!!! Removed spare Harddrive but PC now wont boot?

    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...
  3. Remeartificer

    Need help with the "IF" command Please

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

    Need help with the "IF" command Please

    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?
  5. Remeartificer

    Need help with the "IF" command Please

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

    Need help with the "IF" command Please

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

    Need help with the "IF" command Please

    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...
  8. Remeartificer

    Need help with the "IF" command Please

    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...
  9. Remeartificer

    Switchboard - How do I password protect a button?

    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...
  10. Remeartificer

    Switchboard - How do I change the horrible template?

    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?
  11. Remeartificer

    Can anyone recommend a good source of info for expressions?

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

    Can anyone recommend a good source of info for expressions?

    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.
  13. Remeartificer

    Can someone help me with a Report expression please?

    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
  14. Remeartificer

    Outlook meeting invite - Update problem

    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...
  15. Remeartificer

    Can someone help me with a Report expression please?

    =IIf([reportdecision] = "Accepted", Sum(
  16. Remeartificer

    Can someone help me with a Report expression please?

    Can someone help me with a Report expression please? I have a report that gets printed in response to a company quote. The report has a changeable heading at the top that either says aprooved or Cancellation. If the Quote is accepted then the quote amount is shown in this report. If the quote...
  17. Remeartificer

    What do the dots mean: src="../img

    Cheers for the response. After a few hours last night I finally managed to track down the culprit that was responsible. It turned out to be the insert image option of "relative to". By default it was selected to "document", but as soon as I changed it to site it sorted the problem out. Did I...
  18. Remeartificer

    What do the dots mean: src="../img

    I use a secure server for the work website so I do not have FTP. Instead my company gives me a slow horrible bit of in-house software to use. So I opt to use DreamWeaver and then copy and paste the code back in online. I have used Teleport Pro to copy my website onto my HDD. However, when I...
  19. Remeartificer

    Automatic Subject Line - How do I reply?

    Nope, it is all quiet on this question front. Pity :(
  20. Remeartificer

    Hiding data on a report?

    I am not 100% sure of what you mean. Can you expand a little please? Thanks :)

Part and Inventory Search

Back
Top