Search results

hey louise yah I'd be much saner to if a solution could be found Im going to ask the people in the VBA forum if they know how access handles controls because it appears to be very different than how VB handles it, so check that forum also maybe will get an answer there. Rpb

it's set to all records..shux you had my hopes up to. any more ideas?

simple solution have format as currency, the default value to 0 and make sure the decimal place is left on AUTO and you'll be all set

Hi on a continuous subform I have two combo boxes, projectname and subprojectname, these are linked to 2 tables and based on what project is selected I want only the certain subprojects associated with that project to be available in the subprojectname combobox. this is my code so far...

Hi on a continuous subform I have two combo boxes, projectname and subprojectname, these are linked to 2 tables and based on what project is selected I want only the certain subprojects associated with that project to be available in the subprojectname combobox. this is my code so far...

hi, I have a subform on a form and I'd like to refresh the form from within the subform whenver tab is pressed this may not be possible to do on tab if its not can it be done on keypress? or something similar to that? thanks for the time, Rpb

hi I have a report that whena certain condition is met I want certain controls to not be visible when printed. ---------code---- If Subprojects.Value = "" Then GroupHeader1.Visible = False End If --------code----- pretty simple, I expected the whole header and the controls in it to be...

if it is asking you for a parameter value it usually means you have a field in the report that is linked incorrectly. I would go into the design view of the report and see if you can find a field that matches the name in the error message and delete that (dont forget to back up) then try to run...

Hi, Is it possible to change the print margins of a report through anyway other than manually doing it? thanks for the time, Rpb

hi, I have a table that stores a project name and the subprojects of that project, they are both primary keys. in the table they look like this ---------- proj1 sub1 proj1 sub2 etc. ---------- my question is this on a form there are 2 combo boxes next to each other one holds the project and one...

You have your form which saves everything to tables and now you want report so the next step would be to go the the reports tab and click on te "new" button and pick Report Wizard. this should help you get started. if this is not the informatin you were looking for just ignore me or post back...

yes thanks, I need to check for Null values for 2 fileds in a subform. as you probaly know when you get a null value error it says. "Index or Primary key can't contain a Null Value" Im an intern here and when I showed my manager the form he got a null value error (which I had warned him...

Did you put all reports in a dropdown and then when its selected have it either print or preview? thats what I'd like plse let me know . thanks, Rpb

Well I think if I understand your question this is what you would have to do. enter this code: Private Sub optionbuttonname_Click() If optionbuttonname.value = true then newsletterdatebox.enabled =false Else newletterdatebox.enabled = true End sub optionbuttonname is your option...

Is there a way to change the text displayed in an error message? thanks, Rpb

Hi I have a form wiht a dropdown and when you want to add something tothat dropdown you switch to another form save the info. to the table and exit back to the original form, I included a refresh button on the original form but my manager would prefer this automated. I have added this code...

Hi, alright i have a meeting to show the datbase of today. Just added a simple caluclation to a report it adds the sums of query and displays it in a field. you cannot open the report now because it says "out of memory" it offers no help on this help if you can! thanks Rpb

okay thanks for the info. pat it gave me a few ideas I believe I can get it to work. Tracey-As soon as I finish up the rest of the dbase ill work on that and post a reply if I am successful thanks, Rpb

Hi, hopefully someone here can help. I have a bunch of different types of reports for one dbase, and was trying to figure out a way for them to be in a dropdown. Is this possible? thanks for the time, Rpb

is there anyway in code to check for a null value in a field and if there is one change the value? I can handle changin the value =) but am not sure what the syntax is or how to reference a null value...if that makes sense. well thanks for the time, Rpb