Search results for query: *

thanks for anyone who may have contemplated this question but i think im pointed in the right direction in that I think that these are bespoke 3rd party window modifications. So far Im taking a look at http://access.mvps.org/access/toc.htm. http://www.tek-tips.com/viewthread.cfm?qid=1722721

I recently saw Windows 7 screen with a desktop menu using "Access Forms"?. Brightly coloured tastefully iridescent even. Bout 5x 8 cm tucked into the rhs top of the screen. THey have options for entereing Customer Joc details start date of the job etc. Ive got no idea what they were and how...

It IS Chinese I've discovered. Thanks Anyway.

I am trying to make sense of some code that I downloaded but the comments appear garbled eg: /*--------------------------------------* Ãû ³Æ: patternDetect2 Êä Èë: ¸ÅÂÊA,B,C,D,E Êä ³ö: ÊÖÊÆÀàÐÍpattern ¹¦ ÄÜ: ¸ù¾ÝÊÖÊÆÐòÁÐÔÚÄ£ÐÍÖеĸÅÂÊÀ´ÅжÏÊÖÊÆÀàÐÍ...

Not sure if this will help. thread707-1470989

Oh I didn't realize what you were saying. I cleared the unbound text box and sure enough I could place data in it from the Detail_Format event. A very useful simple tip - I'm not sure why it works but I am most grateful.

yes i agree. I'm just giving a cut-down example. The unbound text box actually collects its value from many bound text box controls and the required expression is very complex tho i will have to do that if there is no way to do it from code. I just need to determine if its possible in principle...

I can create an unbound text box in the detail section of my report. This text box refers to another control on the report called "Person" when I place this expression in the unbound text box... =IIf([Person]="ed",1,2) .. sure enough it gives 1 whenever the Person control is "ed" and 2...

mmm... thanks

I have produced an report/invoice from the table of data. (It contains some subreports as well.) After the report/invoice appears, I might like to modify the data on the report itself- and then maybe save it as an individual modified invoice. Any ideas how to modify the contents of a report??

I want to print my Access VBA code in colour. I usually copy the code - module by module and paste it into Word where I have written a "Pretty Print" routine to automatically print it colour code formatted. This takes ages when I have lot of modules. I got a bit excited when I noticed that...

thanks for your - I would have liked to code something but that should keep me busy for the moment.

I want to format lots of text boxes which are already on my form to .423 height and Font Tahoma size 8. The format painter does the height only. Is there a way - maybe from code (but presumably in design view) of applying formatting in one go to text boxes for example that I place on the form...

Well Thanks. Looks like we'll never know but meanwhile tabular continuous forms could keep me busy.

Does =IIf([SchemeRef]=52,[Delivered],0) work? how about =IIf([SchemeRef]=52,[Delivered],"") ?(not sure what Type of data [Delivered] is.) how about =IIf(-1,"dummy","") =IIf(0,[Delivered],"") ? etc etc to try to isolate the error.

not sure why you need the Sum. esp if its a text field? I guess the main thing is that Iff takes 3 arguments not 2.

I make a "Datasheet" form based upon a table in 2007. The field heading of this Datasheet form are a light brown. I want to print the form. When I Print Preview it, the colours change slightly but I still have the light brown headings across the top. Are they some sort of "system" colour? Is...

Well thanks for that. I never noticed that you can only enforce RI from the Relationship window. And I guess that the Join Type set at the the Relationship window is just the default?

We can 1. set up relationships between two tables eg a one to many and eg set the join type to 1,2 or 3 and save this layout. We can then 2. make a query for the same two tables and maybe choose a different Join type. I don't understand why we need to perform 1. above. Does this just set...

By the way I wonder just why Current comes to fire more than once?