Search results

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

I appreciate the help. I think there something wrong with my computer (setup). Even my combo box objects don't work properly, (at least I think they don't). Awhile back I tried doing something with bookmarks, and it never worked. I bring it to school and it worked fine... Here's a pic of one...

I still get an "arguement has too many parameters" error. At the moment I'm downloading some vb service pack 5, not sure if will help, but I've run out of ideas.

Hi, I am trying to execute a stored procedure that take in 1 (datetime) parameter. Everytime I try and execute it I get the following error, which makes no sense to me. "Procedure 'Shipping' expects parameter '@ShipDate, which was not supplied. Any help is appreciated, thanks. Here is the...

** Solved Hi, I was just wondering what goes into a data dictionary. Which of the following should be included in a data dictonary - tables - constraints - triggers - stored procedures - queries I'm sure the first two apply, but I'm not sure about the last three. Any help is appreciated, thanks.

I completely forgot about setting the rowsource="". That might do the trick. ** Ya, that works. I was so ticked off the .clear thing didn't work, I forgot all aobut the rowsource :) God, access can be annoying. Thanks