Search results

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

Anyone help?

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?

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.

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

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

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

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?

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

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

I meant to say so when I try to check the box it will ask me for the password. Please help.

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!

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

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

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

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

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?

Yes I'm sorry, I won't do that again! lol. Anyhow well if a form or report can do this for me then I'll be glad to know how to accomplish it and the reason why each item has it's own table it is because each item goes through the same exact process each two weeks and their information changes...

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

Ok just so you understand it better for example, you see the Heading S1 on the table and you see the S1 on the form? When I put the first record on the table it said the S1 was 34 and I will update that info weekly. The updated information which is the second record has a 45. How can make it...