Recent content by crcastilla

  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

    Anyone help?
  3. C

    Help with tables

    That worked great! When I go to print preview the information on the sub datasheet (third table information) doesn't show though. Anyway to fix that?
  4. C

    Code

    I know this is old but I forgot that I also want it that whenever I try to uncheck the box it will ask me for the same password and I don't put it in correctly then it will not be unchecked.
  5. C

    Help with tables

    Well, this is what I really want to do. You know how when I open my second table there is a plus sign for each row and when I press it the sub table appears (third table)? I want that to appear on my form. I tried to put a sub-form and I select my second table but it does not appear with the...
  6. C

    Help with tables

    Okay, thank you so much for all your help! I have successfully done it. I did what Pat told me to do. I added a primary field in the second table with was a autonumber then I created my third table and made the foreign field to relate by second and third table. I don't know if you understand...
  7. 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...
  8. C

    Form Code

    thank you so much, is there also a way to accomplish my second question? so that the check box it is checked it will appear in another box the date that it was checked?
  9. 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...
  10. C

    Code

    Okay so this is what I typed Private Sub Sales_Click() If InputBox("Enter Password Please") <> "somevalue" Then MsgBox "Password Invalid.", vbOKOnly Cancel = True Exit Sub End If End Sub It does ask me for the password but it still lets me check the box. I want...
  11. C

    Code

    I meant to say so when I try to check the box it will ask me for the password. Please help.
  12. 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!
  13. C

    Form Issue

    Thank you so much. I have a couple more concerns but I think are easy to solve. When I create a form from a query the information appears in one whole "block", is there anyway that I can separate it to move around the information to put it wherever I want. Also, when I create the sub form it...
  14. 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...
  15. C

    Union Query

    I know it's a hell lot 96, I think. I know there was a better way to do it but I wanted to try this. I know it but I would like to know if the code is correct or if it is missing something I will appreciate it so muchh. Thank you again
See more
Back
Top Bottom