Search results for query: *

Thanks for the tip. I'll give that a try (possibly next week, as its just about time to go home for the day) Much thanks

That sounds like a good idea, but for some odd reason I'm having trouble finding anywhere that tells how to do that. Also, does it make a difference on how you do it if its part of a sharepoint portal page?

Datagrid the first section of the table: /code dgCustomer = New DataGrid Dim newColumn As BoundColumn Dim btnColumnSelect As ButtonColumn dgCustomer.AllowPaging = False dgCustomer.HeaderStyle.Font.Bold = False dgCustomer.HeaderStyle.BackColor =...

Yeah, that describes it good.

Its the passing of information between webparts, especially webparts on seperate pages, that I dont know how to do. He basically wants the list of customers on the main page, and the fact sheet to show up on a second page. What is a good resource to looking up how to do this?

I have a web part that pulls information from a database, puts it into a table and displays in on the web page. My boss wants me to take the table with the information in it and put it into another web page. I'm using vb.net 2003 to do the writing, and I'm fairly new to this side of things, and...

I am creating a webpart that will take ultimately take user information and display it in another web part or in a new window. My problems are these: 1) I can't seem to figure out how to use a button to trigger an action in the web part. Basically, I want to make is so that I push a button and...

Try adding the dll to the GAC. I was unable to solve this problem until I found the GAC and figured out how to put stuff in there. basically, control panel->administrative tools->.net configuration 1.1->Assembly cache just browse to where the dll file is located and add it...

I removed the identity from the id fields (Since they don't matter) and that seems to have fixed the error. also I set it to After Delete because it wasnt deleting with For Delete... Alter TRIGGER [tblCustomerComments_delete] ON [JL].[dbo].[tblCustomerComments] AFTER DELETE AS insert...

Alrighty then, Basicly the setup is SQL Server 2000. the main database is 'JL' and the insert into database is 'JLDel' so the trigger should look something like: Create TRIGGER [deletecopy] ON [JL].[dbo].[tblCustomerComments] FOR DELETE AS insert [JLDel].[dbo].[tblCustomerComments] select *...

I want to set up a system so that when a user tries to delete a record from the database it automatically moves the record to a mirror database, to act kind of like a recycle bin, so that in case someone accidently pushes the wrong button, we wont loose valuable information. I know I can use...

I should add that I'm trying to connect to a SQL server 2000 database... which is on the same machine as the sharpoint server. Sharepoint is also using a sql database on this same server, just a different one from the customer database.

We have a customer database that I would like to be able to pull information from in order to display realtime reports in a sharepoint web part. I'm writing the web part in VB.Net 2003, and I HATE FrontPage (plus we don't want to use it because of the ghosting issue) I've tried several...

incase this helps at all, (if not, ignore) here is the view structure: ALTER VIEW dbo.qrySearchFields AS SELECT dbo.tblCustomers.CustomerName, dbo.tblCustomerPhone.PhoneNum AS PhoneNumber, dbo.tblCustomerTypeLineItems.CustomerTypeID AS CustomerTypes...

OK, so I get the alias thing, but will that work in a view? I'm using the view to look up stuff in a VB6 program, so I just have to figure out how to rewrite it so that the program can write the sql statement for me to get what I want. The guy that origionally wrote it had customer type in a...

I have a view qrySearchFields with several tables in it, including tblCustomer (CustomerID, CustomerName, CustomerPhone) and tblCustomerTypeLineItems (CustomerTypeLineItemID, CustomerID, CustomerTypeID) so if I do a select on the view SELECT * FROM qrySearchFields WHERE CustomerTypeID = '33'...

I have a linked server setup between MS SQL Server 2000 and MySql, and it works great for normal things like selects, inserts, deletes, etc. However, when I tried setting up a trigger to update it automatically, I ran into problems. The trigger looks like: Create trigger subscription_insert on...

I have a VB6 program that was assigned to me to work on, and the guy that started creating it did a poor job designing how it worked. At the moment it uses a stored sql authentication username and password that is embedded in the VB6 code that is used by everybody, and then attempts to control...

hopefully the record selection formula editor can do what I want, but if there are other ways to do it, then that would be cool too :)

I'm going to look into that record selection, but for this report the counts and stuff arent what I'm looking for. basically I want to export the report into excel so I can then put it through our mailing program. here is a sample of what would be returned: DeVore Motors - Rex DeMoss OR...