Recent content by Eric6

that would still cause the same problem, it would sum up every record instead of a specific group (which is what i need) Eric

i would also like to know how to do that... it would be a very usefull to allow the user to compact the DB from a custom menu. thanks Eric

Hi, i'd like to know if its possible to change the horizontal size of a textbox. i'm building a report and i want to have a the width of my control to change so that all the text fits in it... access has cangrow and canshrink properties but that only affects the heigh, not the width. does...

There is not code for my report i'll try to draw the layout of my report in design view everything in all caps is a variable [code] ==Project Header============================================ Project: PROJECT ==Name Header============================================= Consultant: NAME...

sorry about the double post

i have a form with 5 listboxes, each box corresponds to a catagory of filters from which the user can select what he wishes to display in the report... my code on the ok button on the form generates the SQL String and opens the report... I tried creating a global variable but since i'm not...

i have a form with 5 listboxes, each box corresponds to a catagory of filters from which the user can select what he wishes to display in the report... my code on the ok button on the form generates the SQL String and opens the report... I tried creating a global variable but since i'm not...

hi Wabba just go in the forms design view, create you combobox or dropdown list and select the control source as the table or you could click the build button [...] next to the control source box and create a small query that isolates the required column. then just save it and the SQL...

no one has a clue?

hi, i'd like to know how i can pass a string containing an SQL String (which varies depending on the users selection) from a form to a Report. the SQL string needs to be used as the RecordSource of that report. I originaly planed on using OpenArgs but the openReport method does not seem to...

Hi, i'm having problems with the Sub and DSub method in my reports. everytime i use it to calculate the total of a field that is not in the detail section, the Sum returns the total of every record in my recordsource instead of the total of my subgroup do you know what i could be doing wrong...

The Sum() method calculates the sum for each record in my query, even when the field that uses sum is in the "footer" of a group... i dont know how to fix it so that it only adds the values in its group any help would be extremely appreciated! i have to get this to work thanks in...

hi, I'm having problems calculating my totals in a report i'm building.... i'm using the Sum() method but i doesn't give me the right results I have a large query contaning the information for the form (i use it as my control source) I then group the data from inside the report. (ps: the...

sorry about the bad grammar guys :) in other words, i just want to know if i can make the fonts in access behave independently from windows thanks

thanks guys :) thats what i thought of doing except that i didn't know you could disable the shortcut keys... there is still one little problem though once i disable the shortcut keys, how will i be able to access the inner workings of the database? i still need to work on it, so i can't...