Search results

does anyone know how to control the visibility on minmaxbuttons with visual basics and without using "form properties" or a generic command button? i only want minimized button to be visible and maximized and closed not visible. thanks to all in advance! [This message has been edited by gino...

lookup the requery in help file. me.form.requery will be helpful to refresh the record based on combobox. insert the requery in the after update event.......... have your query criteria based on the unbound combobox field for example: [forms]![yourform].[yourcombobox] i suggest having the...

i forgot to mention. does this database have a front and backend? also, how is the security set? i ask these questions because if there is no restriction on users modifying forms then this will be a common problem. also, if you don't have a frontend then all users will share one corrupted...

yes, that error sucks. sorry for my language. i came across this many times. it happens sometimes when you change the form and do not click on save. usually access prompts you to save if you forget to save changes, but when access doesn't prompt you get this error message. i am guessing...

tabs, command buttons, etc are set to system colors. learning this i've set all my forms to system colors so users can change colors by modifying their windows display properties. my users are happy about this because they can be very moody at times about colors. to learn more about this...

look up requery in access help. very good explanation found there. me.form.requery you could use this in an afterupdate, onclick, etc.....

i need to have a save option for users to save reports to whatever format they wish, but i don't want users to use Save As/Export in the menu bar. if users use this option they have the option of saving to external or current database. any better way of accomplishing this? my main goal is...

i'm sorry to reply so late. got caught up at work. try requery. put this in a command button on your main form Me.subform.Requery after filling in unbound fields requery should update the query you created. Your sub form should update. [This message has been edited by gino (edited...

for nulls i sometimes use the iif function. for example: iif([yourfield]=0,0,calculation if not null) it works very well for me.

thanks, i never used the wizards before but i guess its time for me to use them.

i never made a report so complicated before so all of your assistance would be great. i have a date field that is based on one day. i want to pull the date field and have it to total by month. also, i need to be able to pull this report by range. am i going to have to create mulitple queries...

your subform should be based on the query you designed.......

open your form properties..rather than the object itself. click on the top left box in design view of your form to open your form properties. [This message has been edited by gino (edited 08-17-2000).]

first of all what is the name of your calendar? this is what i posted "in the onLoad or onOpen event insert this code" did you insert the code in your onLoad or onOpen event? this will not work in the onUpdate event. let us know if you need anymore help.... [This message has been edited by...

the find command (Ctrl+F) is MSAccess default finding tool therefore it limits your options. yes, an unbound text box is the better route on finding a specific record. use a query to find specific records. in this case you insert this code under ItemID criteria in your query...

i don't know how you set up your database but this happend about a month ago in my office. some users had different "frontend" versions then others. i built a code to force every user on the network to download the latest upgrade i've created. also, be aware of NTFS permissions. be sure the...

are you talking about the scale of a chart? if you are open in design view then double click the chart then click on the scale. a dialog box will appear to modify necessary changes. not sure if i am helping but good luck

in the onLoad or onOpen event insert this code: me.calendar.value=date this should work............ no if statement needed! [This message has been edited by gino (edited 08-17-2000).]

first have the command button not enabled in the properties. second put this code in the appropiate event where you need this validation to take action. if me.sexfield ="female" then me.commandbutton.enabled = true else 'do nothing end if i'm thinking maybe in the OnOpen event! modify this...

yes you can export all reports to rtf, text, html, and so on but they all don't keep its original format. i'm thinking if there was a way of keeping all of its original format. i have charts on my reports and they disappear when exported. does anyone know how to do this? the only way i can...