Search results for query: *

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...

sounds fun :) i think i tried the security wizard but the results were, shall i say, i little too secure... ;) i'll check out that topic in the help file thanks Eric

hi, i'm developing a system for my boss, everything going ok... i made every form so that is fits perfectly inside a screen with an 800x600 resolution, everything was going fine until i tested it on her system... the forms wouldn't fit in a single screen anymore, i did some research and...

hi, i would like to protect the system i'm programming with user accounts. I would want the user to enter his/her username and password when the database first opens... depending on the username, the system would enable and disable buttons on the main menu hence restricting access to some...

the thing is, it wont reach the lastrec - 1 unless the remove button has been pushed and as soon as it enters the if, its set back to false i dont see how that could stop access from warning the user

here is the code for my remove button If IsNull(Me.Function) Or IsNull(Me.Project) Then MsgBox "You cannot remove an incomplete entry" & vbCrLf & "Make sure Project and Function have values Before trying to remove the entry.", vbExclamation, "Complete Entry...