Search results for query: *

Hello All, I've been having a hard time trying to figure out why some values, which happen to be foreign keys, are not passing between my stored procedure and my code on a button click event. I keep receiving the error, "Procedure or Function 'sp_OrderTracking_Update_UpdateItem' expects...

Hello All, Thanks for your posts. The thing is, my comboboxes are populating correctly. What I need them to do is if another item is selected from any of them, I'd like to save the new item (i.e. new depot, freight forwarder, dispatcher) to the database as an update to that particular location...

Thanks everyone. We can only hope to achieve the same status as cjard one day:)

InertiaM, Thanks.........I caught that too and changed it to @Email, but it made no difference....any other suggestions, please?

Hi ss7thirty and All, Yup, everything in my stored procedure matches up. Here it is; could you please advise: ALTER PROCEDURE dbo.sp_OrderTracking_Update_UpdateItem ( @site varchar(30), @siteRefnbr varchar(5), @aac varchar(10), @phoneNbr varchar(20), @faxNbr varchar(20), @depot...

Hello All, I'm back! Hoping you can help me with this one. I have an app I'm working on with multiple forms. One of the forms, frmLocationInfo, has textboxes and comboboxes which are automatically populated based on a combobox selection from a previous form, frmLocations. I've been able to get...

BackColor Property Hi JuggaloBrotha, There is an option for textbox properties, called "BackColor". If you click on the dropdown arrow and select the "Web" tab, at the top of the list is an option for "Transparent". Hope that helps :)

Hi MattP, Thanks for your reply. I tried adding the "BEGIN" and "END", but I'm still receiving the "Procedure sp_OrderTracking_Update_UpdateItem has no parameters and arguments were supplied." error. Do you have any other ideas as to what's causing this? Thanks in advance!

Hello All, I would appreciate if you could please advise on the problem I'm running into while attempting to get my app to update a database. I'm using a stored procedure, but am receiving a "Procedure sp_OrderTracking_Update_UpdateItem has no parameters and arguments were supplied" error. Here...

jmcilhinney, Thanks for the advice. I will give it a try. Regarding the 3rd step you've suggested, what if I'm not using databinding?

Hi jmcilhinney, Okay, so I've uncommented out the part I think is behind the save, but now I'm receiving the error, "Update unable to find TableMapping['Locations'] or DataTable 'Locations'." Any clue as to what's causing this? :confused: Here is my code for this as of right now: Private Sub...

Hi jmcilhinney, Thanks for your reply. The database is actually attached to a SQL server. What would you suggest in this case? Thanks in advance.

Hi All, I would appreciate your assistance with the following task: I'm trying to edit and save changes made to a row of a SQL table via Windows form textboxes. Right now when I run the app, I try to make a change to one of the textboxes, I click on the Save/Close button, but when I go to the...

Hi techwiz24, I've actually done something similar to this recently. I would imagine that your comboboxes are pulling from a table. Could you please provide your table structure and from that, I'll be able to show code to populate the 2nd combobox based on what is selected in the first. It has...

Hello All, I would greatly appreciate your assistance with this issue. I'm trying to concatenate nonnull multiple columns from a database into the text property of a combobox. Right now, I'm receiving an "IndexOutOfRangeException was unhandled name, address1, address2". The line in red is where...

Hi MattP and All, Please pardon my ignorance as I am a novice to Vb.Net. Could you please advise at to which lines should be substitued with the code you've provided? Thanks.

Hello All, Was wondering if I could please get some assistance with this. I have a frm1 and frm2. frm1 has a combobox, cboLocations, from which a location is selected and then the "Ok" button is clicked upon which frm2 loads. frm2 contains textboxes and other comboboxes, which all should...

Hi jm, This is actually not homework, but a project I've been given to upgrade an app from VB6 to VB.Net. I was advised not to use data binding by a senior person here. I would go to her for further advice, but she has her own projects and don't want to bother her, so that's why I'm hoping to...

Hello Everyone, Could someone please advise on how to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the...

Hi JM, How would I pass a value from frm1 to the input parameter? I'm trying to pass the depot_refnbr, which would come along with the selection made on the combobox there for Location into the @Depot_Nbr parameter. I'm then trying to pass this value to @CorrespDepot to have frm2's Depot...