Search results

Yes, add the related table to your query and select the occupation field from that table instead of the occupationID field.

How about an expression field in the query? IIf([Mo] = Month(Date()), [MyRecommendationField], "") ...or something like that, depending on how you have your month stored.

Can't you use the Replace() function in your query or in the report text box? Like: MyManipulatedString: Replace([MyFieldName], "_", ": ") ...as a query field.

So make the page footer fatter...it works from the bottom up, right?

Don't you think "Id[]" is a strange name for a control? Why do you need to name it with the "[]"?

The page footer is in a constant position at the bottom of each page. Can't you put your total there?

Quick and easy way is: File/Save As Look at the top right of the save as dialog for the "Tools" dropdown. Select "General Options" Enter a "password to modify". Click OK

DoCmd.OpenReport "rptSummary", acViewPreview

Make group header/footer for the field that distinguishes each invoice. (Right click report in design view/select sorting & grouping) Then, under "force new page" select before or after section. (Play with the settings here, and you will get what you want.)

Update: (My interim fix) I set the default view to readonly. On the empty item template, I added a label ("No assignment loaded")... and a button ("Create new assignment") with code: Me.DetailsView1.ChangeMode(DetailsViewMode.Insert) That may actually be the best answer, since the original...

Thanks again for all the help, Kodo.

Here's what worked: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [PositionFillUpdated] ON [dbo].[tblPositionFill] AFTER INSERT AS declare @LastID int SELECT @LastID = (select PositionFillID from INSERTED) BEGIN SET NOCOUNT ON; update tblpositionfill set todate =...

I just tried it, and it didn't work. It didn't error on execute, either. I'm travelling out to ND today for the week, don't know if I'll be on the forum (unless I can get internet connx at hotel). Thanks for the help so far!

The DetailsView is using a datasource on tblPositionFill (this will add a record to that bridging table to 'assign' a person to a position)...it is tied to the gridview selected record. The gridview pulls data from Pers table left join on PositionFIll table, so people not assigned don't have an...

...No, I tried that second one that I posted, and it errors on execute. I can't see what's wrong with the first statement that I posted, but it doesn't work.

OK here's what I have now... ALTER TRIGGER [PositionFillInserted] ON [dbo].[tblPositionFill] AFTER INSERT AS DECLARE @LastID int Select @LastID=PositionFillID from Inserted BEGIN SET NOCOUNT ON; UPDATE tblPositionFill SET ToDate = (SELECT FromDate FROM tblPositionFill...

In my DetailsView, when there is no matching record, I want to switch it to Insert Mode. I have tried If Me.DetailsView1.Rows.Count = 0 Then Me.DetailsView1.DefaultMode = DetailsViewMode.Insert Else Me.DetailsView1.DefaultMode = DetailsViewMode.ReadOnly End If but that doesn't work...

Where do I put the DECLARE statement? Up top?

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