Search results for query: *

I have code-that opens a report as long as there is data in the tbl. when the user closes the report-a boolean is set to false-so that way it'll signal for the code to continue-but I close the report-and the code is still waiting for the boolean to be changed-it never stops at the on-close of...

thank you-I moved the public statement to a module-how come I can't have in in a button on a form?-if it's public-it's public no? I guess not-but why not-any logic to it? anyhow it's working so thank you

I have a public variable set in a button's code: Option Compare Database Option Explicit Public rptAtt As Boolean in the button's code-i'm calling a report to open up-and on the on-close of the form I'm setting: rptATT=false but when it's coming back to the code-to continue the code-the...

Call printAttendanceRecord

I have a button that calls a report-that button has 2 subs. I want on the onclose of the report-to call the the secondsub-"printReport" but when I call that function I'm getting "compile error sub or function not defined" I'm sure that if I put that sub in a regular module it will be no...

is it possible to add half months in the addDate function? when I try it -it rounds it off.-how can I go about it? (unless the only choice is to add afterwards 15 days?)

july and august-but I think I took care of the problem -I made a for loop and when it hit month of "7" I added 2 months to it. have any more efficient way?

I have to add a certain amt of months to a date -but I need it to calculate it-excluding summer months(2) ex. if startdate is 9/1/05-and I'm adding 9 months-the result should be 6/1/06 but if I'm starting in 4/1/05 and I'm adding 18 months-it should exclude the 2 summers inbetween and the result...

thank you -the first response was helpful-I was just trying to get away with writing code in one place-but I guess I have to call the code from every listbox... btw (by the way) e/t -(everything) and s/t -(something) my next question is that I have a textbox -andthe onclick function calls the...

I have a form with textboxes, list boxes... I need code to be run e/t s/t is clicked on the form - I tried putting the code in the form's onCurrent, beforeUpdate,afterUpdate,onClick,onActivate,afterInsert but none seemed to work -I even tried "form.refresh" in the onclick of every field any...

I have a backend Table in sql-and I use access as the frontend. when I'm trying to add a record using the .addrecord and .update I get an error of "run time error 3146" odbc-call failed any ideas? I opened up the recordset with Select * FROM tbl where ...., dbOpenDynaset, dbInconsistent)...

and then how do I put the value into a variable out of the function? or do I just use "blah" and the value will be there?

what's the syntax for returning a value from a function?

how do I reset a form-without a user clicking on a button-and I want to put the code-before the form is even loaded.

I've been working on it-and did look at w3school but I'm getting this error when loading page: Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /reportcard.asp, line 348 line 348 is conn.execute(sql) and the sql is : sql="UPDATE...

I did set a connection-top of the page-the page that it's going to is the same page-just reloading it the current page. so where would i insert the code? thank you for all your help

here's the code-is the sql statment in the right place because the page wouldn't load thanks <form method="POST" action="results.asp"> <select size="1" name="MOM"> <option value="0">METHODS OF MEASUREMENT:</option><BR> <option value="1">Teacher Made Materials</option><BR> <option...

what do I enter by action-the first line of the form?

thanks -what if I have 4 combo boxes-and each one has to go into another field?

yes-I have to insert 1,2,or 3 into a table-depending on the user's respone thank u