Search results

Pat. That was not the point of my reply and I did say “Given the code and control names supplied…” The point was that Mark posted a class module solution and made the comment “. . . so not much code, and you simply can't do that with a standard module.” I was trying to show that it can be...

Nigel. From post #1 in this thread… >>A couple of the fields are date formats but the source data has them has dd.mm.yyyy<< And that is the specification as supplied by Andrew. Chris.

Nigel. This is what we know:- ---------- The source data is in the format of dd.mm.yyyy You have supplied a sample of 2.5.2013 That is the 2nd of May 2013 The double raw data for that date is 41396 The double raw data for that date does not change with regional settings. ---------- With a...

Given the code and control names supplied… In the On Change event in the property sheet for cboLocationID:- =HandleChange([cboManagerID]) And in a standard module:- Public Function HandleChange(ByRef cbo As ComboBox) cbo.Requery cbo = "" End Function The above works even if the...

Nigel. Try changing your regional settings to English (United States). You will find that 2.5.2013 is still converted to 2/5/2013. In the US, with a known date format of dd.mm.yyyy, 2.5.2013 should produce 5/2/2013. The reason for this is that Access only sees 2.5.2013 and not the intended...

Let’s wait and see if it works. :D Chris.

If the 'Dates' are really in the format of dd.mm.yyyy try:- Public Function ConvertToDate(ByVal vntIn As Variant) As Variant Dim vntTemp As Variant If Len(vntIn) Then vntTemp = Split(vntIn, ".") If UBound(vntTemp) = 2 Then On Error Resume Next...

>>I'm happy with that formatting and that is how the dates are ultimately stored in the table.<< If that is correct then you are storing the ‘Date’ as Text and it should be a Date/Time or Double field data type. I can’t help with your problem because I don’t have Access 2013 and therefore don’t...

Billgyrotech: For this particular topic, could you please confine your replies to this thread? http://www.access-programmers.co.uk/forums/showthread.php?t=250502 Chris.

Zoom Over Line Chart. Rationale:- Line charts can have too much data displayed in them to the point that they become almost useless. With this demo we can drag, drop and resize a Zoom Box, over the main chart, to show the zoomed detail of the main chart in another detail chart. Note:- There...

Mihail. >that nothing will be changed in this window< That is incorrect, some things are changed. Go to that site and copy/paste the contents back to the VB editor. As it stands, the Bytes code box is flawed, it is not perfect. And there is no point in trying to say that all we have to do is...

Maybe this will help:- http://support.microsoft.com/kb/182247 Chris.

Catalin. Why should I not try to see it from Jon’s perspective? If I can advise Jon on some of the problems involved with making the change then that will be less work for Jon. I would like other people to do some of the work and advise Jon as well. Not just say “It would be nice if” and have...

I think it is a matter of balance. We may all want something but would we pay for it? Such a change would cost Jon time (money) even if all he had to do was to find out if it would be cost effective. To find out if it is cost effective one of the things he would have to do is look at both the...

Can someone annotate this code? Certainly…”It is not VBA.” A second annotation: We need to be careful when asking questions. >> I've read it over a few times and I still can't figure out why the underlined isn't redundant...<< The point is that some of the underlined is redundant and some of...

I’m not trying to be entirely negative here but it would take Jon (?) a fair amount of time to make that change. There is still one bug with that display on Bytes: If the line numbers are visible then a copy and paste to the VB editor has a Tab character (4 spaces?) at the start of each line...

To say for sure, I would need to see a copy of the database in Access 2003 version. As a pure guess: Clicking on the detail section may not save changes made to a Text Box. In fact, if one of the Text Boxes is still the Active Control then its After Update event would not have fired and you...

A small Access 2003 demo is attached. Suggest contacting Microsoft. :confused: Chris.

I can’t really say why but it also does that in Access 2003. Wrapping the option group return value in the Val function seems to fix it:- Val(Forms!frmStatus!optStatus) Chris.

Dave. I am talking about this link:- http://access.mvps.org/access/bugs/bugs0005.htm which is the link I posted in post #21. Anyone have any thoughts about that link? Chris.