Search results

  1. C

    Access Database to Application (EXE file) to CD?

    Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..
  2. C

    Help with tables

    Okay, I'm really stuck at this. I will try to explain my best. I have two tables. The first one is as follows: MP No (Primary key), Sales, Date Entry, Specs, Email The second Table is as follows: MP No, Quantity, Description, DWG, Price There is a "one-to-many" relationship between the two...
  3. C

    Form Code

    I want to know if this is possible. I have a check box name "Sales". I want it so whenever I try to check the box it will ask me for a password. If I input the incorrect password then the box will not be checked. If I put the correct one then it will be checked. Let's say the password to check...
  4. C

    Code

    Hello, I want to put a check box in a form and I want it so I want to check the box it asks me for a password. How do I do this? Thank you!
  5. C

    Form Issue

    I really hope someone can help get through this. I been trying to play with database for a while now and I can't do it. I'll try to explain it my best. First I have one table that has the following fields: MP No. (This is my primary key) Field Type: Number Entry, PO, Contact, Phone, Terms...
  6. C

    Union Query

    So I'm trying to put multiple queries into one table. What's the the code I have to use? I used the following: SELECT SN, GageDescription, CalibrationTolerances, S1, A, S, SO, Tolerance, By, Date, Due, Temperature FROM [#2 (Q)] UNION ALL SELECT SN, GageDescription, CalibrationTolerances, S1, A...
  7. C

    Query

    I want to run a query that shows the Due Dates that are coming up in the next two weeks (the start point would be the current time) So if I run a query today, 8/23/2011 then I would have to see the due dates between 8/23/2011 and 9/06/2011. Is this possible? what would the expression be?
  8. C

    Please Help with Access.

    Hi I don't how to accomplish this but I know there is a way. Let's say this; I have four tables(each table representing an item) and each of them has the following fields: SSN#, Tolerance, Action Taken, S1, S, SA, S/O, By, Date, Due Date, Temperature. I will be adding new records to each...
  9. C

    Updating form from table

    Hi, I'm a total beginner at Access 2007. I created a table which I will update with a new record each week. I also created a form and some of the information form table i wanted it to be in the form. I went to Add Existing Fields and added the field i wanted. The problem that when i create a new...
Back
Top Bottom