Search results

I have reveretd to creating a new workbook at present purely because I can't seem to add a worksheet to an existing book... Feeble, but true :o

Thanks for this, Adam. I had already tried to use your code and it works really well the first time but I can't seem to adapt it to add a sheet to an existing spreadsheet or to adapt the code I had previously to add a sheet and rename it. I have tried tinkering with Set wkbk =...

I am exporting versions of a table from Access to Excel each month and would like to use an existing workbook by adding a new sheet (and naming the sheet appropriately). I have drawn a blank so far. Any advice or pointers gratefull received. Thanks for your support

I had a similar problem and with help from the board ended up with: Dim strList As String Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tblMyTable") ' Concatenate the field I am interested in Do While Not rs.EOF strList = strList & ", " &...

Thanks - that has worked... I'll have a tinker to see if I can make it look a bit more button-like when it is clicked. It's a pity to lose the letter image but that's purely cosmetic and your idea has done the trick. Thanks for your help - and fast help at that ! :)

I have a form which contains a continuous subform. Next to every record in the subform is a button which opens an email to the contact in the current record. We don't have e-mail addresses for some contacts so I'd like the button to be invisible for those records. Using... Private Sub...

Huge thanks to you both... your document was really helpful, David, and it now works like a dream using a combination of the ideas you suggested. I have learnt something along the way, too. I really appreciate your patience and help

Yes - it opens fine. I have tried searching for the error message and have played with this code based on one of the postings: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Dim vabQuery As String Dim para1 As QueryDef vabQuery = "FindEMails" Set para1 =...

Thanks very much to you both for such a speedy reply. When it gets to Set rs = CurrentDb.OpenRecordset("qryFindEMails") I get error message 3061. "Too few parameters. Expected 1" David's function doesn't seem to use a parameter... Not sure how to proceed

I have a query, qryFindEMails with a field containing e-mail addresses. I want to combine these e-mails into a string: email1-at-wherever.com; email2-at-wherever.com; email3-at-wherever.com ... and then append this string to a textbox on a form. (I have removed all the @ symbols hereas they...

Thank you for the feedback. I can see what you mean about concatenated fields. When I tried to use a compound key I got in a mess when I tried to use a bound column in a list box, so at the moment I still have it set up using, as you rightly say, poor practice. Added to that, I have explained...

I have a form containing data as follows SchYear Subject GpBased (Yes/No) GpCount At the press of a button, I'd like to be able to append new records to a separate table, "Classes", where the key field, SubjSetCode, is filled with: SchYear & "/" & Subject1 SchYear & "/" & Subject2 SchYear &...

That's brilliant, thank you Thank you so much. I know some (self-taught) VBA but would never have managed what you have done & following it through has been really interesting. I have used the VBA approach for the sake of speed and it works beautifully Thanks again Sally

Thanks for the reply In answer to your questions: Is StudentID a text field or a numeric field? Numeric What is the data type of the Duration field? Short time How is duration entered in the field? In minutes e.g. "90" The following info determines whether to use a Totals Query or a temporary...

I have a database storing exam info: Studentid exam date session duration Some exams are actually due in the same session on the same day, so a student may be doing 20 exams, two or three of which are due in the same session. I therefore need to combine those records into Studentid...

Thanks for the help - certainly your other thread convinces me that a query would be better... I tried your revised code to start with and I get no error messages, but nothing happens. As you explained, a query qould be better, so I tried running a query on double click: UPDATE [Students And...

I have a form containing a listbox (lstGroupList) containing all the subject groups for a particular student (selected in a further listbox) and a listbox containing all the possible groups for the student (lstFullGroupList). I'd like to be able to select an existing group in lstGroupList and a...

Thank you both... I shall take it home and come back to you about it, if that's OK. I really appreciate your time and patience. Your demo is getting the sums right, Fizzio, but I'll look at both ideas as it seems to have problems with large chunks of text. Thanks for the clarification of the...

Sorry - I'm confused here. I have tried setting up a loop as you suggested but I'm getting subscript out of range errors. If you have time, I'd be grateful for a little more help! Thanks very much Sally

The word count works, thank you, but the sentence count (replacing " " with "." in the Split function) gives one too many some of the time.