Search results

Thanks to all the responders above. Not sure what I do to formally record thanks as there seems no button to click! What I didn't mention is that once a month I send a email to all 500 by Mailchimp and this is generally successful. Even this fails to deliver on a reliable basis. Some recipients...

I have written some VBA code to send a personalised email with a personalised PDF attachment to 500 members of an organisation. It works! However, I am concerned that the spam police will get involved and classify many or all of these as spam. Has anyone any ideas on whether this is likely to...

Thanks guys! All working without vba.

I have an excel spreadsheet from a bank, from which I can extract membership renewal payments. My task is to update the membership table with dates and amounts paid. What would be the best approach to this task?

The user uses the delete key, but I am not sure that this difference matters. Is there no way of redisplaying the missing data before answering the deletion confirmation message?

I have a subform with multiple line entries. When highlighting one entry and pressing 'Delete', Access asks to confirm the deletion. However, the displayed details have been cleared. They are reinstated in the 'No' option is clicked, but how can I stop the displayed data being cleared first. It...

Ho ho ho is certainly more seasonal but it implies some jollity. Hey ho is more resigned, along the lines of 'will I ever really understand what its all about'!

I didn't understand either and since my code now works I didn't spend too much time ploughing through it. As an ex-COBOL programmer from the 1960 I found some of the concepts difficult and found a lack of easy reference material to learn from. COBOL, FORTRAN, BASIC all had a limited set of...

This makes me even more confused since I have now got it working but not in the way these references explain - in fact my solution contradicts these references. I have cut down my code to the bare essentials to test and I am testing on my own system where I have two Outlook 2013 accounts. the...

I have written VBA code which sends out emails with customised attachments to all addressees in an Access 2010 table. The person sending this emails has multiple Outlook accounts. I have tried using the .sendusingaccount feature but I keep getting errors. Can anyone help? Dim dbName As...

Title says it all!

Yes, they have the same pro perties and yes, it's the same source field. That's what makes it so strange!

I have an Access 2010 table which contains a field holding email an address. The format is ShortText. On most forms the field contents are shown in standard format, but on a couple the field displays in blue and underlined. The format of the field on each form has Hyperlink set to No. The filed...

Paul thanks for the response and apologies for the delay. I inspected the generated SQL and all fields were qualified with table name prefixes. I deleted the VBA code and recreated it and it now works. Goodness knows why!

I have a report that requires 3 queries to generate the data required. I then have created a VBA routine to automate the generation of about 70 short reports, each one detailing members of a group. These are then emailed to the group leader for updating. This has worked well up until now, when I...

I can't at the moment, users are on holiday! when I try it, I get long delays, system not responding messages and some screen flashing, to fast to read, and then the system seems to run. I haven't yet tried all 20 forms, 30 queries and 15 reports, so I can't be certain it is all OK. So the...

I have developed and deployed a Access 2010 application. I recently bought a new desktop with Access 2013 installed. My 2 users get error messages and flashing screens when they open the latest 2013 format database in 2010. Can anyone advise on whether I have to revert to 2010 to continue...

Thanks guys. In the end it was all about testing for blank and null fields!

I must be dumb but I cannot see how conditional formatting can help. It seems to require minimum and maximum values and does not seem to allow me to format one field based on the content of another. Am I missing something?

Based on the contents of Control B such as a particular word.