Recent content by Jonno

Hi there Thanks for the info - will revisit the code. But I agree that the code isn't causing the issue - I suspect the problem is with how Outlook is handling large quantities of email at the same time - when I run this on an email by email basis ( omitting the .send command) the problem...

Hi Has anyone experienced the following problem - I've set up a piece of VBA code to loop through and email various recipients data, in the form of records within the email body. This works fine, but occasionally produces an error whereby the email output body lines are duplicated spuriously...

Thanks guys! Maxmangion - everything is sluggish here..... Hopefully I will have moved on in four thousand years, so I guess this database will be ok for a bit! Cheers Jon

Paul I guess a way of doing it would be to make small a form with no border at all, guess the closest you can and keep making adjustments until it disappears into the background and you have a good enough match, then you have your colour numbers from the properties. Jon

Ladies/Gents forgive me if this question has already been answered a thousand times, maybe my search skills are worse than I thought. Is there a limit that Autonumbers generated will reach, after which it stops, or is it infinity? The reason I ask is that I have a database with a table inc...

What is the difference in functionality between the two? :confused:

Hi Pat I have a loop which counts the entries in a listbox and performs a function the number of times corresponding to the number of rows in the box - Dim countstaff As Integer Dim Counter As Integer countstaff = Me!List14.ListCount Dim Check Check = True: Counter =...

:D Thanks! :D

Morning everybody. Could someone please tell me if its possible with code to refer to a specific line/row in a list box, e.g. From Listbox1 I want the data in row 3/column 2 for example. I know you can reference the column in a listbox. Hope this makes sense!

Can you expand rich?

The problem is that the listbox is using a separate query as its source, and the column I wish to sum is a calculated field, tried this before but couldn't get it working. I assumed this wasn't possible using a query as source data.

Hi all Is it possible to Sum the values in one particular column in a listbox, within either a form or report, and have the result in a textbox on the form or on the report?

Could anyone give me a clue as to why my a form in my A97 Dbase would change from data entry? = 'yes' to 'no' for no apparent reason, other than interference by another user? This has happened twice in 2 months, seemingly with no reason/set of circumstances. The form has been in use for months...

namliam, you are very helpful - thanks. :D

Afternoon everyone I have had a search on this and couldn't really find what I was after, forgive me if it sits blaringly obviously in a previous post. I have a table called "Xmaster", with a name field "Staff" and a time field called "from". There is a form "Star1" which has the textbox...