Search results

OK, I got it to work with this... ALTER TRIGGER [PositionFillInserted] ON [dbo].[tblPositionFill] AFTER INSERT AS BEGIN SET NOCOUNT ON; UPDATE tblPositionFill SET ToDate = (SELECT FromDate FROM tblPositionFill WHERE PositionFillID = @@identity) WHERE PersID = (SELECT...

Here's where I got to last night... I am using SQL Express 2005. I found this 'scope_identity()' function on the web. It's supposed to grab the identity value from the last transaction. I don't think it's working yet. CREATE TRIGGER [PositionFillInserted] ON [dbo].[tblPositionFill]...

Yeah, one of those...GetString...GetRows. Thanks Tim, for getting my back.

Glad to hear you got it up and running. Big thanks to Kodo.

The #1 choice of web-ifying Access would be via ADO connection. You can make Active Server Pages to interact with the database, or you can take the .NET plunge to present your info on the web. Perhaps you could define exactly what functionality you want for your web visitors, and we can help...

My details view shows current job position by linking a person to a position in a bridging table called tblPositionFill. The fields in that table are: PositionFillID (PK) PositionID (FK) PersID (FK) FromDate (DateTime) ToDate (DateTime) What I would like to do is either: 1. Prevent user from...

Look at the GetString method of the Recordset object in VBA help.

Kodo knows 1000% more than I do about this. Did you create and run the batch file that he suggested? To make a batch file: (my apologies if you know this already) create a new .txt document and rename it RegDotNet.bat Right click on it and select Edit Paste the command line from Kodo's post...

I like Pat's idea. (which will do exactly what you want, but with one table) You can store the number as an absolute (positive) and add a field for the sign...in which you would store 1 or -1 The user would not have to enter it, it could be derived from context, i.e...if it's recorded on the...

Thank you for that. In the cold light of morning, I don't think I'm THAT far from understanding this. I know about class modules in Access, but those are created for you and neatly organized behind their respective objects. I guess the idea is a bit too abstract for me in the .net...

OK, (both of you)...lets take it one step at a time: Ken, I have a test for you to see if your server will process ASP pages. John, There are some idiosynchrosies (?sp) to the SQL Server 2005 Express...I got it running, so any other domestic ape can do so. ASP test: You should have a...

I believe the current version of IIS is 6.0 I can't say whether the .net framework requires a certain version, as I've only run 6.0

You probably haven't loaded the .net framework. If you go to Add/Remove Programs, the .net framework is listed as "Microsoft .net Framework 1.1" or "Microsoft .net Framwork 2.0" (or both).

There is no ASP service. IIS processes it out of the box.

Yeah, I missed the lesson on "Classes". Dude, it's like you're talking Greek, so it must be that you have drastically overestimated my understanding of this OOP stuff. As far as my problem, I am having some luck now with putting a details view on the same page with a gridview and using the...

In your Losses text box, in the afterUpdate event, you could do: Me.txtLosses = Me.txtLosses * -1

I did this once for a similar situation: In the table that feeds your combo box, add a record where the value for the combo box will be "*". If you have separate value and text for your combo box, you can make the text "All". Set the value of the combo to "*" either in the form_load or...

Are your combo box values coming from a value list or a table?

Kodo, you are SUCH a showoff. (but I dig your avatar, and you are helping me with my .NET struggles, so I forgive you.)

Yeah, I tried that in the preload event: Protected Sub Page_PreLoad(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreLoad Dim Pers As Integer Pers = Request.QueryString("PersID") End Sub But where (and in what syntax) do I put that var in the...