Search results for query: *

Ok, thanks a lot Daniel. It works but not where I want it to. The main concern with a freezing action is when program is *painting* the screen and I can't use it = no effect. I guess I should use some API from GDI. Anyway, I keep the trick ;-) Have a good day, Yvon

Even if you start a form with a table, as soon you use the 3-points-button in the recordset property of that form, Access will ask you if you want to replace the table with a query. Answer yes, and a query design screen will apear where you define what you need. Closing that design query...

Hi all, Is there a way to "freeze" a form in order to peform some updates and then "release" it. This is needed to avoid a flashing screen as far I'm using a lot of small picture to show warning messages. Instead to use sentences, I'm using yellow and/or red squares close...

Hi Bill, Many thanks for your answer it's exactly what I need and it works. Have a good day, Yvon

Hi all, Using MSAccess 97, I'm wondering to know if there is a way to export/copy/transfert a custom menubar defined in one DB to another one. Menubar was developed in a "test" DB and need now to be placed in "production". Thanks for all, Yvon

Hi all, Do you ever experience the following message in Access 97 : &quot;<form name> can't create any more controls on this form or report&quot; I know, my form is very big with a lot of controls. Already had this message and split in 2 forms. But today, I delete some controls (cut) from one...

Many thanks BSman for your response. Indeed I've worked in that direction. What I have done : I generate 1 query with the first five fields (col) are what the user select and in the correct sequence. Never used to print but only for sort purpose. All others fields are what I need to print...

Hello, I have an application working with market, product, etc ... with 5 levels. I would like to produce reports depending on user's choice and let them choice if they want by Market/Product or Product/Market etc... I would prefer to generate the report by modifying the sort/grouping, and also...

Check with this sample and it work: If ctl.ControlType = acTextBox Then ' Define control properties. With ctl .SetFocus .Enabled = True .Height = 400 .SpecialEffect = 0 End With...

Sorells, Don't worry about time waste ... I know how it is frustrating. Your late answer recall me another strange behavour in Access at least 97 (don't know about other version). When an error is pointed and you don't see why, I allways do a &quot;Compile all modules&quot; and most of the time...

Hello I would try this : dim ctl as control For Each ctl in Me.Controls if me.ctl.name <> me.CkNeeded.name then Me.Ctl.Enabled = False endif Next ctl Hope this help, Yvon Duvivier

Does it give an error message or just run without result ? Another tricky thing is all those ((( )))) Also had some problem with that :-) Did you try : WHERE ((([Lookup:Walls].Bed)=True)) from the working sql Regards, Yvon

Hello Try to put a &quot;;&quot; at the end of your lstTask_List.RowSource definition. This is the only diff I can see and already this type of problem : put or don't put a &quot;;&quot; Hope this help Yvon Duvivier

Hello Checked in your base and date1 & date2 should first converted in a date format before getting the diff. I place this on &quot;Detalj_Format&quot; event : Me.Dat1 = CDate(Left([Datum1], 4) & &quot;/&quot; & Mid([Datum1], 5, 2) & &quot;/&quot; & Right([Datum1], 2)) Me.dat2 =...