Search results

Tkx.But that tells me how to do it manually,which I mentioned in my post,a nd which of course is easy to do. (Clik the mouse etc.) I need to do this automatically from a button.

Other than having to manually hide/unhide columns in a (subform) datasheet view,is it possible with some CODE to do this on clik of a button etc. Please help with some code ideas if u think it is possible. The advantage of hide/unhide in a datasheet is the columns self adjust,whereas forms are...

Looking further at this crazy problem,it may well be because my subform is displayed in datasheet format. I like that because if u do take a column out the others move over,to fill the space like in a spreadsheet. So really the question is can I hide/unhide columns in a datasheet,with a...

On loading a subform,in a form I have a number of hidden columns in the subform,which I would like to make visible,(and hide some others),upon clicking a button. I have tried all sorts of options,but have been unable to get them to appear or disappear. Any help would be appreciated.

Fizzio!! Many tks. Item "b" hidden fields is an interesting idea. I will experiment around with that and see how it goes. (The fields in the table are the same in both modes auto/manual..it s just i need to bring in to view the fields with manual data,which are not needed in auto mode.In other...

I,m stuck at mom on the best way to achieve this. Basically i have 2 modes in my prog,Auto &manual. Auto is pc generated,manual allows me to insert and calculate using some different data. I need to be able to switch the view on the current form(subform) so that when I go to manual mode ,the...

I think I have found my own solution so dont worry. After working at thisfor a whole day,by changing the "+1" at the end of the statement to +.01,it now finds in correct order/number. What i obviously hadnt realised was the +1 meant there had to be a diff of 1 between each item ,whereas I have...

I have been trying to rank a table,using the format suggested in MS download examples Qrysmp97.mdb. It ranks in order but CANT COUNT properly Here is the results I am getting Name Margin POS (rank) aa 1 3 bb 1.900 6 cc 2.8 6 dd 2.2 6 ee...

Jack: Great stuff.Works perfectly Many thanks. Ps I do read the help files extensively but sometimes u just get lost...or suffer a mental block on a prob.

I want to create a calculated field in my query,by finding the greater of 2 other fields (in the same table). I am having some trouble getting the syntax right. Anyone got a simple answer pls.

PAT. Thanks yr view and help. I have just switched over from lotus approach,which despite all its bugs,was in many instances a bit more intuitive than access,so i'm struggling here,and all help is appreciated. Yes I think yr right,I will ultimately have to put that in code,(its a bit unstable...

Wizcow !!! BRILLIANT !!!! Many thanks works great. Will have a look at Pat's view as well,its just so nice to be able to move on. Actually I intend to save the changed/deleted items to a new temp table and the with the use of "if" statement be able to reverse the changes,with a similar...

I am looking for a way that when i clik/or dblclik,on a field in a record (in a form/datasheet)it will delete the existing text and replace it with another "preset" text expression. From that expression I also need it to delete or clear values from 1 or 2 other columns so that a recalculation...

Tks yr reply. The problem is the underlying table is made up of continuos forms,but only one is displayed at a time, and I want to calculate only on the (sub) form figures displayed. However i will take a rain chek,on this as I may have solved the problem by referring to a "control in a subform"...

So i have a form in view (actually a form and subform),extracted from a Main Table by query. The form in view has a tab which has additional results arising from the query. However I need to "capture" only the current item in view to enable summary calcs,(add/sum/etc),so as not to perform them...

I want to open my pivot chart directly from a button. At the moment I can only get the button to open the form ,and then u have to clik on pivot chart view. Tks.

Ok Folks : I have got this working Thanks

On a form containing only 1 entry : [myformname]![fieldname] including this as criteria in a query finds the correct items. The question is how to define this criteria to select the correct [fieldname] from a form with multiple entries. At the mom this action on a multiple field form puts up a...

Further to my earlier post,some progression has been made. Using the following code I can now with a dble click get the query to open a dialogue box and when the name is inserted it does the correct query. "[forms]![myfilename subform2]![myfieldname]![myfieldname_label]" So has anyone got an...

I am trying to set up a query (very similar to a combobox query),except I want (if possible) to be able to select an item (Name) from a row in a table field. I have it so it will now run but it finds everything in the queried table,not the selected field name. I use a run code item from a macro...