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

Thanks for the prompt help I have just done my first access course (last week) and realise this. With this database though, I am working on something that was developed years ago. I remember from the course about reserved words, but forgot. I will now address this. As for the Max()...

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

Thanks Very Much! It appears to be working. I can see how it's been done. I have finally got a VBA course sorted for the end of the month at QA IT Training in London. Hopefully, one day I will be as good as yourself. Cheers Dave

Check this out - It works great!!! http://www.fontstuff.com/access/acctut09.htm Dave

It Didn't Work For Me It may be because I have developed in Access 97 and the code you may have entered isn't working for me. When I opened it some dates had been removed from the list, I got excited, but then I entered a new booking, saved it and then enetered another on the same date; the...

It's Not Woking For Me Thanks for your help. It's not working for me. I have attached the database. The query is qryTimeChecking. If you look at the form you will see what I am trying to do. For a particular date, I don't want to show a time that's already been allocated to a booking...

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

I can't speak to the lad that wrote it because he is abroad. He's back next week; I just wanted to get on with it. I realise it's something to do with the OpenArgs. I am resourseful, so hopefully I will suss it out before he comes back. My boss and the QA man have put a case together now, so...

This is the forms complete code: Option Compare Database Option Explicit Private Sub cmdCancel_Click() On Error GoTo Err_cmdCancel_Click DoCmd.Close ' closes the frmEnterComment form Exit_cmdCancel_Click: Exit Sub Err_cmdCancel_Click: Beep MsgBox Err.Description...

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