Recent content by rnutts

Hi I am trying to send tasks to other people using access vba. I had used before in my database but was using early binding and now through version issues of office I am trying to recreate the code using late binding, however I am getting various problems with certain lines of code. Primarily...

Good morning I have a piece of code which creates a spreadsheet using acOutputQuery The coee then opens the spreadsheet and formats .activesheet . Finally I want to turn the filter to 'on' for the spreadsheet but am struggling with the line of code I have tried...

I have been having some problems with Missing Object Libraries in my database, and having searched this forum have realised that the solution appears to be to convert references for Excel, Word and Outlook in vba to Late Binding I believe I have done this throughout my project but am still...

The module is called from the before update event of the control. Call AuditTrail(Me,EnquiryNumber)

Thanks for the answer The problem is occuring further up the code. The code is not recognising that there is any change in the value (old v current)when the user removes the value from the field(backspace or delete) I have tried putting various message boxes in the code to see what is...

Hi I am trying to create an audit trail of changes to control values on forms within a database. I have found a method on the internet, which has a module to insert the relevant information into a table called Audit. The problem I have found with the code is that if the control is 'blank' or...

Hi I have a database created in Access 2000 File Format using Access 2003. Due to upgrades at work we all now have Access 2010. Database is still a Access 2000 database I have created some reports using the Access 2010 version, these reports only export the report headers to excel. Reports that...

I have a form (frmEnquirySearch) which is based upon a query (qryEnquirySearch), the form is used to search Enquirys and I have a unbound control on the form. This was referenced in the criteria section of the query where I had a field called search that basically created a string of all the...

Hallo I have a form which is used to create job sheets, where the control JobNumber is the primary key in tblnapswork As more than one user can be entering at one time I need to prevent duplicate job numbers being given out by the system. I have a module which should trap the Error 3022 and...

I am still no further on than yesterday. I have the second loop working on another cmd button (code below) but I have no idea how to collect the variable into a string and then use that string outside of the loop I have searched these and other forums for posts I can relate to my own, but...

I am getting a message stating that I have a Do Loop Running which is not terminated. I have looked at vba help and cannot see why the second loop (below) keeps giving this error [code] Set rst = CurrentDb.OpenRecordset(strsql2) intUpBound = rst.RecordCount...

Ok so the taunt worked and I read further into the article where I got the code and have changed as follows. I still presume it could be preetier but at least the taunt took me out of my comfort zone [code]Set rst = CurrentDb.OpenRecordset(strsql2) rst.MoveLast...

Have managed to get working using an array, the code for which I found on the internet and have adapted to get what I want. It may not be pretty but it works see below [Code]Set rst = CurrentDb.OpenRecordset(strsql2) rst.MoveFirst If Len(Me.JobNumber &...

Ok now that I have managed, with a lot of help, got the appointments working, my boss wants more We create appointments within outlook using the code above and running a loop, however we have also subjobs linked to the main job and within the 'body' of the appointment he wants a summary of all...

Thanks again, like I said I had tried rs. and had completely missed you had said rs! in your original post. As you already know it works like a dream now Once again thanks Richard