Search results

Hello, I am wondering about forms and subforms. I know that you can put a subform in either a datasheet view or form view on a main form, but I personally dislike the way this looks and feels. Here is my solution in theory: I have a main form, Customers that is used for entering new records...

It is an inventory system for a professional fisherman, so that he can manage his rods, reels, and specific bait items. The usage of this particular form is for when he comes home from a tournament or any practice fishing before a tournament to be able to select an item that he may have lost or...

Hello All, I have a database with a main table tbl_Inventory. This table has fields: Inventory_ID Model Maker Category Type Quantity I have a form for editing the quantity of broken or lost Inventory Items. This form consists of three combo boxes in which the selection adds criteria for a...

Okay, I have a main navigation form that contains a subform based off a query that shows upcoming events. On my main navigation form I can open a data entry form to add new events. I need to use a macro upon closing the data entry form for new events that refreshes the query and subform based...

You know what, I am just too uneducated in VBA to do anything without you giving me very explicit step by step directions. I think it would be of benefit to both of us if I just put my project on hold for now, step away from all this frustration, and take the time to learn the basics of VB...

Yes, the subforms are all built and named according to "sfrm"+Catagory. Not sure what you mean by commenting out the code and hard-coding the name of one of the subforms in the sourceobject. Sorry, you probably feel like you're spoon feeding me this stuff.

More specifically, it is a Run-time error '2101': The setting you entered isn't valid for this property. What am I doing wrong now?

Thank you! Alright, I have successfully done this. Now, when I put the code in my On Current for the main form, I get a runtime error. I am not exactly sure why. What I have is the main form combo box you named AssetTypeID I have named Catagory. My subforms are named sfrmRods, sfrmReels, etc...

So, in my main Assets form, I would add a subform. This subform would then need to have a subform control named subformcontainer? how do I do that?

And just to be totally honest, I am no good with anything code. I am a college student just getting started so please don't get upset with my lack of understanding!

Me.SubFormContainer.SourceObject = "sfrm" & Me.AssetTypeID Can you please explain exactly how this particular part works? The me part seems to be a Macro. Is this right?

Alright, I need to set up a database for tracking fishing supplies inventory. The problem is that for each type of asset (rods, reels, jigs, hooks, etc.) there are different combinations of attributes that need to be entered. Eventually I would like to be able to create a form for adding new...

Let me try rephrasing my question in a different way. I will just describe the form that I envision being able to use: Upon the form opening, you have the ability to enter the name of the new asset and a combo box to select the type of asset that it is. Then you click a "Next" command button...

Alright, I set up my tables this way, but now I keep getting "The expression is typed incorrectly" notification.

CraigDolphin, this is exactly what I needed! Thanks a ton!

Alright, so here is my current dilemma: I need a table for all inventory items and their quantity. The problem is creating individual tables for each type of inventory item (i.e. rods, reels, spinnerbaits, worms, etc.). I need to be able to make entries into specific item tables because each...

Okay, so would you suggest that I use a query as the beginning of form or forget the query and simply use the table bait?

To jdraw: No, he wouldn't be keeping up with each fish that he caught. Only weather or not he won or lost the tournament. The idea is to track how much money he has paid to enter tournaments vs how much he has been able to win back over time. This is just a little bit extra though. The real...

I am developing a database for a friend to track his inventory of fishing equipment. In this database, there is a table called "Bait." This table holds records for each bait he owns and includes a field called "Quantity" that indicates how many he has of said bait. There is currently a form that...

Hello, I am designing a Database for my best friend who is a professional fisherman. While he is a very talented fisherman, he is extremely unorganized and unable to maximize his fishing assets. In my estimation he needs a program that will aid him in keeping up with his equipment and help him...