Search results

Doc. This may be where we differ… I do not believe it is sufficient to say "I have observed other behaviour" and then go on to make suggestions based on that observation. I test things and there are times I don’t believe the results and so I test them again. There are also times when I ask...

Hi Pat. They are monochrome bitmaps (quite small) and were inserted using ‘Create from file’. Chris.

Pat. Does the attachment work for you? Chris.

http://social.msdn.microsoft.com/Forums/office/en-US/e12a48d2-cec0-4792-9ae7-342d827e61ca/access-97-sr2b-causes-massive-registry-corruptionwin-7 Chris.

Helystra. You might consider asking one question at a time in a new thread. The people trying to help you vary in their level of expertise in any given area. They should not be required to read through all of a thread such as this one. Try to be explicit and concise with a single thought, it...

>>If someone wants to box, they are only hurting themselves.<< Not if they are any good at it. :D Chris.

>>7 types of weights<< Of course I’m guessing here but what happens if you ever need 8 or 9 or…? You would not want to keep changing the Form so they might as well be in a subform. There is a small A2003 demo attached which brings all weights forward when a new one-side record is created. It...

Galaxiom. They are all bubble and froth; they couldn’t understand it if it bit them on the arse. For them it’s all repeat, repeat, repeat with no understanding. They have no idea what they are saying. In the short term they might get offended and complain or simply run away. In the long term...

Doc. In reality I do not mind being called a liar, if you did or not say so. What I do mind are posts which state fussy facts and your last post seems to be full of them. Some of the wording in your reply is bordering on the ridiculous. “Complex sensitivity to context” what a load of crap.Do...

Pat. If they can be converted to monochrome bitmaps they can be inserted directly using ‘Create from file’. Chris.

Nobody seems to want to have a crack at it so here is a result. We could also use the database properties but that might be too much work for some… Option Explicit Option Compare Text Public con As New clsCon Sub TestIt() Dim strPropName As String Dim strPropText As String Dim...

Global variables are not lost on error under any circumstance. If an unhandled error occurs in an MDB or ACCDB file we can enter debug mode and the global variable still has its value. The error has occurred but the global variable has maintained its value. Furthermore, if global variables...

If you want to drive the Shortcut Menus from table data there is a late bound demo here:- http://www.access-programmers.co.uk/forums/showthread.php?t=202673 Chris.

Mark. No, I am not free to dispute your interpretation simply because you have not given one. And that is one of the problems with making blanket statements like “VBA does not support inheritance.” Clearly it does, at least to some degree. But it certainly could give VBA a bad reputation and...

Mark. The problem I’m speaking of has just been demonstrated. You have posted links to Wiki articles as if to say “Here, Chris, learn all about it.” Well, I had read those articles many times before but I do not go around needlessly throwing big words into conversations. Quite frankly I find...

Understanding the past may very well depend on how we understand the present. Sean Carroll on the Higgs field… (He is a good speaker.) 27 minutes and 55 seconds into this… http://www.youtube.com/watch?v=RwdY7Eqyguo Worth watching the whole thing but it still doesn’t mean it’s the whole...

Mark. Why do you say that it’s “Too bad VBA doesn't support inheritance.” Without defining what you mean by inheritance it becomes rather ambiguous and if you do define what you mean by inheritance then it becomes just your interpretation. And I don’t want a heap of Wiki articles to read...

There might be something else going on here but by the description it seems this would do:- Public Sub LockControls(ByRef frm As Form) Dim ctl As Control For Each ctl In frm Select Case TypeName(ctl) Case "Textbox", "Combobox", "Listbox"...

I can not open the attachment by Apr Pillai, which is a pity because they are usually very good. So I’m just going to go with the assumption that the Form should show a summary of one week of bookings, in the style of a continuous Form. This is not a continuous Form but, hopefully, it looks...

wksNew is the correct pointer for Range because it has already been Set as in:- Set wksNew = appExcel.Worksheets("qWeeklyJobStatusReportExcel") So, if the Header has already been deleted, then:- wksNew.Range("E" & lngRows) = "=SUM(E6:E" & lngRows - 1 & ")" else increase lngRows by one...