Recent content by ascaife

Won't that just loop the table results in one letter? I would like to produce one latter for every student in one mailerge. Is that possible?

Thank you. That's excellent. I think, with my very limited VBA knowledge I can probably fumble my way around getting this to work for one record at a time, but how would I get it to loop on every record in my query.

I have a database for tracking, among other things, student debt for units completed. Four times a year, we produce a letter for each student, detailing the unit of study completed that quarter, how much they owe, and various other info for that quarter. We use Albert Kallal's mail merge...

Thanks for your response Paul. After some further reading, I agree it probably wouldn't be the best idea to store multiple values in the one field. I had a look at the sample database though and can't really see how I could apply this to my database. Would you mind elaborating on how I...

I have an Access 2007 db and I have just migrated the backend to SQL 2008. My multiselect listbox has stopped working. Does anyone know of an alternative method to store multiple values? It's an enquiry database and the listbox is used to tick courses of interest for prospective students.

I think it has something to do with the autonumber recordID somehow. Just tried another approach which was to place the subform directly on my form as a bound control and got the same message, then another message saying I was trying to assign a duplicate value (which I believe was to the...

I have a form with a number of subforms but instead of using tabs, I inserted an unbound subform where the sourceobject changes depending on the command button clicked. The data displays correctly, however, every time I go to add a new record, I get the error: "You tried to assign the null...

Is it possible to create section headers within a combo box? I have a few fields linked to value lists but I would like to segment the contents to make them more readable. I don't want to use cascading combos if i can help it.

Hi George, Thanks for the response. You're right, publisher is great but I'm really looking to add this in to my existing access 2007 database so they can use the records already contained in it. I'm also hoping to hook it up to a camera using WIA so I can live capture into the system...

I have a small app for school use and was wondering if anyone knows of a way (or even better, can point me to a sample) that I can create a form that includes a few controls necessary to design an id card. Basically, I want my users to be able to go into the form and add fields from a table...

Thanks for all your contributions everyone, and especially for the sample database, certainly lets me see things clearer and will no doubt come in handy. Since I'm distributing a split database, I can leave the design for now then just change the front end later if required.

Thanks for the support, I would be completely lost without the help of all the kind souls who contribute to this forum. It seems that using Me.TAC.Text or just TAC.Text solves the problem. Any ideas why?

Sorry to keep stuffing this up. The results on this are pretty random. It lets me enter a z with other characters, then brings up the message box only when I go to delete the z. It will also let me enter zzz and brings up messagebox on the third z, then deletes the last two. Private Sub...

Awesome, that makes perfect sense. Thanks to both of you guys.

Just sorted it. Seems I needed " " around 201 and 202