Search results

  1. C

    Bloody Microsoft...

    So if you goto to the share drive and then then you would type in the trusted sites: s:/name of folder/name of subfolder I will double check this as i don't have my laptop here to confirm, but i will let you know ASAP.
  2. C

    License agreements

    Hello Thank you for this i will mention within my DB credits.
  3. C

    Importing images to a table

    Good Point... should have thought of that...
  4. C

    Importing images to a table

    Hello I am racking my brians to work out how to upload a jpeg from my c:drive into a field called "image" in a database. I can not workout how to do this, could anyone help??
  5. C

    Time & Billing Beta 1

    hello you selling the database? I design and host websites, so if you want some space let me know? Also could you send me 2000 version so i can have look it and let you know my comments
  6. C

    Bloody Microsoft...

    hello yes all the time at work. Its to do with the internet explorer security. If you goto internet explorer Internet Options and then to Security and click on Trust Sites. You then put the root of your network drive if it is a shared one in here as well as any regular sites you go to. It...
  7. C

    License agreements

    Hello I am in the process of creating my first commercial databse and i was wondering if anyone new where i can get a template of a generic user licence text? Any assistance would be appreciated.
  8. C

    Product Multie Pricing

    hELLO I have create a simular database. What i did was build one query and then had and if statement which said: Net Amount:iif([Total No Items]>5,[Total no Items]*[Price 2],[Total no Items]*[Price 1]) The above is a condensed version of the iif statment has mine had upto 10 different...
  9. C

    One Query 2 Forms

    Hello I need some assistance. I have built a query which i have built two forms which are slightly different. Is there a way to make each form only filter on the data entered in by that form i.e Form 1 entered ABCD Form 2 entered DCAB When open form 2 i only want to see DCAB? Is this...
  10. C

    show forms only

    hello I am creating a database for a client and i only want them to see the forms that i have created so that they can not see the queries or in fact i have used Access. Or may be make it look like a web browser Does any one have any suggestions?
  11. C

    My boss stole my database!

    Happens all the time Hello Its life i am affraid i have created many databases for my company. I made on which would of saved them £16000 a year in man hours and it was a simple database to stop our operation team spending 4 hours a day creating reports with the DB it took 30 seconds to...
  12. C

    Access and Macs

    Thanks Thanks guys for the information.
  13. C

    Access and Macs

    Hello bit of a stupid question. If i create an access database and my friend wants to use it on his apple mac would access work if created on a PC or is there any special patched i need?
  14. C

    If statements & countif(s)

    Hello I have a spreadsheet where i have to count the number of claims which have been made. For example i have cell b2:b6000 inwhich i have a list of valables which would be 601 or 602 i then i have cell g2:g6000 which has claim and no claim. I want to find out the total number of claims for...
  15. C

    If statements & countif(s)

    Hello I have a spreadsheet where i have to count the number of claims which have been made. For example i have cell b2:b6000 inwhich i have a list of valables which would be 601 or 602 i then i have cell g2:g6000 which has claim and no claim. I want to find out the total number of claims for...
  16. C

    Counting Number of days past and present

    Hello I am stumped on how to get a query to do the following: I need to count the number of days which have fallen between a date range and then work the charges incurred both actual and projected. The date range is >date()-7 and date()+7 Is in basic terms the last seven days and the next...
  17. C

    DATES compaison

    Hello I have to work out how much money we owe a supplier. I have a report which in cell E2 i have a the start date. We then get 22 days free in which i have create a cell J2 I then want to find out from the end of the free days to the current day how many days have past and then i want to...
  18. C

    User ID & Password

    Thanks Doc man for your reply.
  19. C

    User ID & Password

    HELLO Yep the code is in the right place, but i am having a major problem working out how to get the code to work so that user just types in the user id and password press ok and then the user then only sees the information as per the Level! So for example in my table i have userid password...
  20. C

    User ID & Password

    I have successfully created a user id & password prompt which works excellently. The database i have created has three forms inwhich two departments access. I have an issue where one department is only allowed to view a search screen and the other department is allowed to enter in information...
Back
Top Bottom