Search results

I am using a Pass Through query to execute a Store Procedure on SQL Server 2000. The Store procedure checks whether the user is a member of the Domain administrators group. Unfortunatel, it returns a null value. If I set the store Procedure to check on any other domain role it works fine, so...

A friend has developed a database at college. All seems pretty well but the query she uses to populate a form and reports is incorrectly displaying the curence. Her main tables are just number fields. The query calculates correctly but her lecturer has told her the query needs to show a £...

I have a pass through query that executes a store procedure that shows the personnel ID number of the person logged in. The personnel Id number is retrieved from a personnel database that we have in existence. The query works fine and retrieves my pers Id ok. I now need to have that result...

I have attached a pic of the table. I am fairly new to Access and need to build a query on a table, as shown. It has the columns: SerialNo, ProgressionID, PersID, Date, Comment, CommentNo. From this I need to show the latest progressionID (i.e. the one with the highest CommentNo and greatest...

I am working on modifying a database that has a register that shows all the relevent information from the main table. There are date text boxes as follows, for each record: Short Term Date, Changed Short Term date Long Term Date, Changed Long Term Date Evidence Target Date, Changed Evidence...

I am fairly new to VBA, having done no fromal training. I have taught myself quite alot and I am pleased with how i am progressing. I am stuck though! I am building a booking system for a friends business, all free of charge as I believe it's a good project to get experience in VBA. The...

Dim rstComment As Recordset Dim strCriteria As String Set rstComment = CurrentDb.OpenRecordset(Me.OpenArgs) strCriteria = strItem & " = " & nNumber & " AND ProgressionID = " & cboProgressionID With rstComment...