Recent content by chobo321321

I'm trying to create a trigger that be able to update the UnitsOnHand (field) in the tblproduct table when an order is inserted, modified, or deleted in the tblOrder table. If an order is added it should take away from unitsonhand. If an order is modified it should add or take away depending on...

I tried the sample database with the labels over the buttons, and it works perfectly, it even keeps the button effect :)

Thanks for the suggestions, and samples. I thought adding a little color would have been easier :)

I'm trying to add some life to my form by using some different colors, but I can't figure out how to change the color of a button. Does anyone know how to do this? Thanks

Thanks for the help, the afterupdate and requery method worked perfectly :)

I found out the recordsource is being set, and if I put in a specific value for the (lstorder) it will display that record in the subform fields. But, I am having problems getting the record in the subform to switch when I select a different record in the listbox. In my textbook it says to put...

Hi, I'm having a hard time setting the recordsource in a subform dynamically. here's what I have Main Form code: Public Sub Form_Current() Me.s_frmPurchaseOrder.Form.RecordSource = "EXEC spProductList " & Me!lstOrder Debug.Print s_frmPurchaseOrder.Form.RecordSource End Sub The debug...

I finally got it to work using a module. For some reason it doesn't allow me to declare an array in the general declaration sections, but I could declare it in a module, and it holds the value of the array. Are modules ok to use for VB or is that bad coding practice?

Thanks for the help. I'll keep trying your way, if I can't get it, I'll have to find another way (without arrays). I though passing values between two event procedures would have been a little easier, but after searching around it seems to be a nightmare.

Here's what I am trying to do. Your way might work for this, but I find it confusing (logically) because I can't figure out how to use that to make strArray available to the lstCustSearch procedure. All I want is just to have access to the array (like a global variable). The array values are...

Anyway to pass array this? Hi, I was wondering what is the best way to pass the contents of an array from one procedure to another. Any help is appreciated, thanks. ** I think the title of the post was misleading, so I changed it.

I put the code in, but no msgbox displays when I click the button. This isn't even an issue about code anymore, I trust you when you say it works on your end. There is something screwed up on my end. I have tested access 2003, and xp on different computers (one that had a fresh install of...

Ya, that was what I was looking for. When you run that does it return anything (records?), or would I need to add some code to display what was returned. When I run it, it does nothing, so I'm not sure if it works or not. Thanks.

Would you know how to supply the parameter manually to the execute statement? I have been trying, but I'm not sure if I am using the right syntax. Thanks for all your help. I must be missing some file, or setting, because I installed Access XP on a computer that was recently formated and I get...

I tried that decomplile/recompile, and it had no problems with it. I didn't notice any changes to the file. I also cut and paste the code you posted, and I get the following error message. Run-time error '-2147217904 (80040e10)': Procedure 'Shipping' expects parameter '@Shipping', which was...