Search results

For those of you in KY or traveling through around Petersburg, the Creation Museum delivers an amazing view on evolution/natural selection. Not to mislead anyone, it is Bible based but it is centered around animals, dinosaurs specifically, and it is really a great show to go and see even if you...

I think you are confused at what a "Field" is. A field is what a column would be in Excel, it represents a certain value of a record, which is a row. That being said, your radio button or check box should uncheck itself if you click it again. You said you were using possible mutiple...

Nm all, I found it. =)

Natal was such a better name. They changed it and lost me. I'm hoping the Playstation Move is where it's at but the remotes for it are....well....inappropriate at best.

I'm sure this is simple but, how do I change the default form opened when I start my db? Thanks

I don't think I'm understanding how the criteria works. DLookUp("[In Stock]","Inventory") This should look up all values in the [In Stock] field which is contained in the "Inventory" table correct? If so, that is correct. Now I want my criteria to list only the [In Stock] value of my...

=DLookUp("In Stock","Inventory",[Manufacturer Part Number=CurrentRecord]) I think I'm getting closer now but now I get #NAME? error. I tried it without the Criterea as well and that give me #Error

My form is already created. It already displays all of the inventory properties with the exception of the stock levels. Here is my form. http://c.imagehost.org/0844/accessform.jpg The "In Stock" box needs to contain the value from another table (Transactions). Each record in the...

Forms are used to add data to your table so yes, you could. You could have multiple forms if you have different people adding different information in but that would be better handled with pages within the same form if you ask me.

I have three tables. Inventory, Transactions, Transaction Types. My goal is to have a form that views details on the inventory as well as allowing the form to add/delete inventory as needed. I don't know what the hell I'm doing so I am asking a bit at a time to understand so please bear with...

On my form, I have a inactive window that I want to display the sum of a particular part number qty. My records are as follows. Mnf Part................Transaction Qty Part 1...................transaction amount Part 2.................. transaction amount Part 1.................. transaction...

I have an inventory table. I have a form to look at the data. I want to give the user the ability to add more of any particular inventory in the "In Stock" Field of the inventory table. I realize that "In Stock" needs to be made up of two other fields which are in a table named transactions and...

Thats a great idea, thanks!

Oh, thank you. The error went away but I can still edit old records so I'm not sure what that did. :(

Bob, My Objects are as follows. Form = frm_ComponentDetails Table = tbl_Inventory I have tried the following; Me.AllowEdits = Not Me.NewRecord frm_ComponentDetails.AllowEdits = Not ComponentDetails.NewRecord tbl_Inventory.AllowEdits = Not Inventory.NewRecord All return the same error...

Is there a way to lock down just the old records? I have a form to insert new records and I want to have the ability to see old records but not edit them. I also have an inventory adjustment page within the form. When I turn editing capabilities off on the form, I lose the ability to update my...

Yeah, I figured it out. I was trying to make it harder than it was again.

I have a form with a PackType and a PackQty input box. I want the boxes to update fields in a table called Packaging. My PackTypes field includes Reel, Tube and Single. The problem is that sometimes values for reel and tube can vary. Any suggestions on what I'm not doing right here? Thanks...

Bob, Here is an example of what I have so far. Are you saying I should create a table for the product combo box? If so, wouldn't that create the redundancy that access is supposed to eliminate? It has been a long time since I have tried to use Access but I hope to learn while I work. Thanks...

Folks, I could use a bit of help with my DB. I have an inventory table set up with the following basic fields. [Mfr Part #], [Qty], [Location],[Product]=(Combo Box) All was well on my reports but someone said it wasn't wise to design the table with multiple choice fields and that they should be...