Search results

Hi Jon, Thank you for the help. When I found that a two button OK/Abort box was not available I opted for a standard box with a keyboard abort instruction. As you suggested I used the Statement in lieu of Function syntax. Final code is shown below. Best regards Brian Dim rst As...

Hi, I'm using this code to power a form button which previews reports generated from a filtered list of instruments. The feeder query is a date order listing of instruments which are of a number of types each type requiring a different report. The code steps through the list matching the...

Thank you all for the very prompt replies. About all I can say is "I was afraid of that!!" Adam - thanks for tip on VBA. I had not thought of that. Brian

Hi, This should be an easy one but I can't figure it out. I have both Office 2003 and 2007 on my machine. There is not problem in calling up either version of either Excel or Word but if I call for Access 2003 after using 2007 the Installer runs and similarly if I call for 2007 after running...

Thank you - I've just had word that I have to leave the office. Will down load and have a look at this tomorrow.

Hi, Only found this message when I was back tracking looking for something a few minutes ago. Well its good to be away but good to get back as well. I had about 17 yrs away. worked in UK, Canada (briefly), Australia but prefer NZ to any of them! I've use Access for a long time in a very...

Well - I stayed in the office a little longer. The working code needed a small change to: Code: Dim rst As Recordset Dim stDocName As String Set rst = Me.RecordsetClone rst.MoveFirst Do Select Case rst!ExType1 Case "d"...

Not sure that I follow but I'll think about it. What does the top line say - the one that is hidden behind the cloud? Is this a Word table? (I'm a Wordperfect user)

It had to be something easy!! I have to stop now so will test tomorrow morning. Thank you very much indeed. You have no idea how much time I've spent on this. Hey - while I have you attention - and this is an easy one. How do you get the code on your replies into that neat little box with...

It is just a descriptive name. I treated the Select Case statement as I would a file that I was naming. By no means convinced that it was what I should be doing but the stuff that I read said it could be any string or number.

Bob, That is one of the options I have tried. I've set up the query to select one "d" type device and one "n" type device. When both d and n have quote marks it prints the EN report, when neither or only the d are quoted it prints both on the D report. Also I've tried it with an IIf function...

Hi, A week or two back, with some invaluable help from this forum, I installed a button on a form which enabled me to produce a set of prints being one of each of a number of records selected by the backing query to that form. This saved me a great deal of time. Since then I've added a Select...

Just a quick "Hi" from the right side of the ditch. Thank you very much for the assistance. Although I stuck to the code nearest to my own on in order to same time I was very interested in the totally different way in which you approached the problem. Will look at it in detail as soon as I...

Thank you to both HiTechCoach and Kiwiman. Two quite different approaches and this makes it very interesting. We have people staying for the weekend so time is limited until Monday. So I'll have a look at both a little later on and feed back to you. Best Regards - Brian

I am setting up a button on a form to print a group of of records which have been filtered by the form's underlying query. For test purposes the number of records has been limited to two. The report comprises two pages. The intention is that the procedure will call the report, print the first...

Thank you Paul. Will look up the references you've given me. Best regards, Brian

I am operating a database which tracks maintenance and inspection history for electrical equipment and instruments at a chemical plant. The database includes references to manufacturer's data sheets and test certificates carried out by external agencies. This information is readily available...

Col Thanks for the reply. My apologies for the delay in getting back to you - have been out of the office since posting my query and have only just had a look to see what may have turned up. Brian

I want to make groups of records in a table read only. This is to protect existing records from being altered when new records which are started from copies of the earlier records are being added to the table. Does anyone have any ideas?

Bob Your advice of a couple of days ago together with my response refer. Having seen how you used the form for controlling printing I've pulled an existing form from my main database. The revised test database is attached. I've added a couple of command buttons and used the button wizard to...