Search results

ok, I have a trigger set up to grab a value from the deleted table ALTER TRIGGER ECShipment_Update_Cartmember ON dbo.ECShipment FOR DELETE AS DECLARE @cartmemberid bigint set @cartmemberid=(SELECT top 1 shipment_cartmemberid from DELETED) exec spECMergeCartMembers @cartmemberid the...

(VB.NET 2.0) This demonstration builds off the last demonsration (xml serialization) and uses the same People class. In this demonstration you will see how to use the binding source object to bind to an instantiated People object and bind the data to a GridView as well as binding text boxes to...

VB.NET 2.0 This example written in VB.NET will show you how to take data from a form, instantiate and populate an object and then serialize the data into an well formed XML Document. It will display the raw xml in a text box and then load the xml data into a dataset which will be bound to a grid...

I'm trying to setup a paging query in SQL server 2000 and I'm having a real pain in the butt time with it. What I want to do is pass in the text of the query and execute it. So @SQLFrom would contain " From [tablename] " but I keep getting [Microsoft][ODBC SQL Server Driver][SQL...

Getting stored procedure source text? Hello, I was wondering if anyone knew how to obtain the source text (i.e Select x from table) of a stored procedure using any SQL server commands or functions.. Thanks.

http://msdn.microsoft.com/vstudio/express/default.aspx MS if offering their express products for free!! you have one year to download them before you can no longer obtain the free versions. The version you download will be free for ever.. it does NOT expire after the one year term is up. The 1...

http://www.neowin.net/comments.php?id=30382&category=main Access looks great!

http://download.microsoft.com/download/1/a/9/1a9a2039-70e3-4e92-b977-756fe884f731/Office2003SP1-kb842532-client-enu.exe

any know where I can find one? I want to be able to record voice to an MP3 file and then store the file either in the database (I know the caveats) or on the filesystem. Thanks.

Ok, I am trying something new here and it works partly. The result is that the forms record source is set and the rows that it displays are the proper count, but no data displays in them. I was working on helping someone else out in the forum when this idea hit me as a good solution, but I can't...

Is there any way to clear a message box after it's popped up without user intervention. I have a form with an onTimer event that checks the db for certain criteria. If it exists then a msgbox is popped. Problem is, if the user walks away and doesn't click "ok" on the box, I need to terminate...

I have a list box in which my users can select multiple names from. Then they print a word document that is populated with their selections profile information. It also runs a query for a report on this person. My issue is that if the report has no data, I don't it to print out, but I want it to...

Sometimes I can do BLAH= forms.[formname].[control] when I type forms. I get a list of the forms in my db. other times when I do it I get Application Count Item Parent as choices. What's going on?

Did a search on the forum and found nothing but failure with trying to use the rowsource property. If this can't be done with embedded charts so I can update the rowsource on the fly, is there a different way to do this? I guess I could always create two different reports for each type of...

Coming from the web world, we have a way to maintain state with sessions and cookies etc. Is there an equivalent in VBA? We also have things like application variables that are able to be accessed by all users. Is there a way to set application wide variables similar to ASP? If you have links...

Ok, There has got to be an easier way to do this. After devl'ing a db, I covert it to an MDE, but invariably, there's some glitches here and there. What is the best way to recreate the MDE without having to import the tables and recreate the relationships in the original database. Every time...

Using Access2002 My report uses onActivate. Can I not grab the value of the openArgs when using onActivate? I am using this to collect my values on the form: Private Sub PrintBySingleDepartment_Click() Dim i As Variant, DeptID As Variant For Each i In Me.DeptList.ItemsSelected...