Search results

  1. A

    #Error in Table. Wont let me Change it.

    This also happens when i am the form view and i am scrolling through the records. A new one was created and is working fine just need to somehow get rid of this entry.
  2. A

    #Error in Table. Wont let me Change it.

    There are 4 users of this db i made sure no one else was in it when i tried to edit the table. Restarted the server and it still gives the error.
  3. A

    #Error in Table. Wont let me Change it.

    I am getting this error (As in pop up from Microsoft) in the form and also in the table. I see what the issue is in the field it has #Error. When i go and try to change it also gives me the same error. I can go ahead and copy the information from the table above into it. But when i go and try to...
  4. A

    Criteria Question on Expression

    Ok thank you I will do that. Then i will be able to sort it since it is using fields and not expressions?
  5. A

    Criteria Question on Expression

    Explain how I would do that in this query? Sorry im a newbie to access. (You probably already figured that out) Thanks again.
  6. A

    Criteria Question on Expression

    I did that in the formula and it still comes up with the prompt.
  7. A

    Criteria Question on Expression

    same deal
  8. A

    Criteria Question on Expression

    Plain English there is that expression. They are being divided together. I want to make it where to where it shows only the percent that are greater than x amount. Here is an example of that formula. expcontribmargin: [4375.52]/[5769.72] that equals 75.84% I want to put in the criteria for...
  9. A

    Criteria Question on Expression

    I have an expression expcontribmargin: [exptotalcontrib]/[exptotalrevenue] Now that comes out as a percentage. I already have everything in but I cant seem to sort it. I need to make two, One about 60% and one below. In the criteria section of access I tried the > and < with the amounts and...
  10. A

    Same value showing up for both Items

    I figured out the problem I didnt put the table_1 into the qry. Thanks for you help guys!
  11. A

    Hey all

    Also from across the pond in the US. Graduated a few years ago i have my ccna so I can help out in the networking area if you guys can lead me the right way in Access! :-)
  12. A

    Over 1 million posts!!

    nice deal its pretty informative around here too!
  13. A

    Word 2010, curser jumping

    To disable the trackpad normally you just have to go into bios and disable it.
  14. A

    vba timer in ppt

    has to be a button somewhere to disable it you would think....
  15. A

    (XP) - Folder windows - blue bar on the left

    You can use different themes to to make it different. I like the zune theme personally
  16. A

    Same value showing up for both Items

    I believe i did what you asked and it still coming up the same. The first value in the report M1C is the correct value. The second one isnt. Did i miss anything?? Only thing i need from the materials table is the cost for that particular ID. Thank You Again!
  17. A

    Same value showing up for both Items

    Thank you for your quick reply! I didnt make the database just getting thrown into this. I will try that later today and reply back
  18. A

    Same value showing up for both Items

    I made a query and there are two tables the report it being pulled from. tblMaterials and tblJobpartrun. The issue is on the tblJobpartrunsheets there are MaterialID1,MaterialID2,MaterialID3,MaterialID4. Which have a relationship with MaterialID. The only thing I want from the tblmaterials is...
  19. A

    Hey all

    My name is Paul I am a IT admin at a company. My concentration is on Networks not data bases hence why I am here looking for some help.
View older results
Back
Top Bottom