Search results

Not helping me :(

I want to color the background of a text box, in a continuous form, based on the color codes stored in the text box itself. I know ConditionalFormat is the only way, as this is a continuous form How can it be done? I want it to be done on the "FormOpen" event. Thanks

Thank you actually for now I realy needed the Me.CurrentSectionTop :) but your answer pointed me also to what I asked for. As I know the Detail.Height the Me.CurrentSectionTop and the current record number it's easy to calculate how many records are to the top of the form and how many are...

how can I know the number of "top" (hidden) records in a continuous form, when I scroll the records ?

Yes, i need to it by code. It is possible to do it like this; Me.lbl1.forecolor = selectedColor Me.lbl2.forecolor = selectedColor Me.lbl3.forecolor = selectedColor ... But i prefer do it for all objects in specific section, even without knowing the objects names

Is there any quick way to apply format (ForeColor) for all objects in a specific section on a report? Something like: for each Object in me.Section1 ... .... Next Object

Ouch As I had this error in a Conditional Formatting my guess it's a similar case. In my case A and C are Sums of Singles. Thanks I think this case can be closed now.

I don't understand how does it explain that Round(Number) + Round(Number) could give a totally not rounded number like 100.0000xxx Won't it be simpler, in this case, to round the result again? just to void this error ? Round( Round(Number1) + Round(Number2) )

Don't look at the specific numbers the weird thing is that Round(Number) + Round(Number) could give a totally not rounded number like 100.0000xxx

it should give me 6.1 2.50 should round to 2.5, and 3.56 should round to 3.6 This is what I know about math but just remember where I started this discussion Round(me.Field1, 1) + Round(me.Field2, 1) could give me 100.00000375 :mad: This makes no sense at all I guess I can use...

Can I use Cdec(Round(Me.Field1, 1) + Cdec(Round(Me.Field2, 1) Will this give me the correct result that I need ? I wand 2.33 + 4.54 to be 6.8 not 6.9 (Round of 6.87)

Yes, Data is very impotent to me. It seems that copying to another field before changing will work :)

Thanks How can I convert from Single to Decimal without loosing data ?

How can it be ? :oops: Round(me.Field1, 1) + Round(me.Field2, 1) = 100.00000375

what does it mean MSXML2.ServerXMLHTTP.3.0, MSXML2.XMLHTTP60 ... ? what is the difference ? for me it failed in some cases, so I changed to URLDownloadToFile

I hoped not to download the file. This works well so I'll go with it. this is what I did before moving to read the file directly using MSXML2.ServerXMLHTTP.3.0 but, as said, it failed with SSL I already moved to URLDownloadToFile for downloading files.

Is it possible to read a text file from HTTPS not using CreateObject("MSXML2.ServerXMLHTTP.3.0") ? though it might work well for HTTP files it will fail for HTTPS. What I actually need is reading a small TXT file that include a version number. reading a small and simple XML file can be an...

Thank you :love: This one do the job I'm sure other suggestions like loop the DoEvents until form is closed, as suggested by @CJ_London will work too :)

Thanks a lot :) This seems to be too complex. I'll try to find a simpler solution, in Access

I did. Not working :(