Search results

oops [This message has been edited by RpbertS (edited 06-07-2001).]

hi, when a form I have loads up and not all fields are filled in I get a runtime error '13' how can I trap this error and change the message or just not display it? thanks

Ive been trying to set up Allen Browne's, abrowne@odyssey.apana.org.au I just cant seem to get it to do anything is there any other examples or sample databases out there? thanks

anyone have a sample dbase showing how to autokick someone if they have been inactive for 10 minutes? thanks please send to wallyg135@yahoo.com

okay I have a subform on a form. how would I undo all changes (and deletions if possible) on the main and subform via a command button on the main form. All i know is: me.undo and setting the commands button cancel property to true but that doesnt help much. well thanks for any help,

this is not working heres my code: txtname= SELECT managers.mlastname, managers.MM FROM managers WHERE (((managers.MM)= Forms![intro]!txtmm.value)); what I want is: txtname to display the name where managers.mm = txtmm on the intro form. any guidance?

Hi I'm using running sum to get a total in the detail of one of my reports, how do I only get it to show the last value (the highest one), and not one after every field? should I move the detail into another kinda of grouping? its getting a little confusing now. thanks for any help,

hi okay, I have a form that has a combo box on it and a text box. When I select the a value you in the combo box I'd like the matching information to appear in the text box. The combo box is getting its data from one table that has only 2 fields in it. Report Name and Report Description...

okay heres my code: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec If IsFormOpen("associate/project") = True Then DoCmd.ApplyFilter , "LastName = Forms![Associate/Project]![txtlast]" End If On Error GoTo Err_Form_Load DoCmd.ApplyFilter , "LastName =...

Okay I have a running sum on a report that gives me totals on the bottom, also when certain conditions are met some records are not shown/printed but the problem is when this happens the running sum totals are still adding up the records that are not shown..is there a way to skip the certain...

Hi on a find button I have a message box that pops up and gives basic instructions to the user, what I would like is to have a small popup form open and give the instructions that also supplies a checkbox or whatever and when it is checked it would not display that form again. all I need...

Hi I have a quick question you guys/gals maybe will be able to answer. how the heck does vba handle controls ? My probelm: I have a report that when a certain condition is met I want certain controls to not be visible when printed. ---------code---- If Subprojects.Value = "" Then...

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

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

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