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

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

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?)

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

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

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 want the user to be able to choose from a list and according to the value-I want to insert a value in a table. ex. user can choose from apple/banana/pear. if the user chooses apple-then enter 1 in the field, banana-2,pear-3. I need the user to choose from many different lists-before they press...

I have to create a page that the consumer rates many different items-what's the best way to go about creating this page/drop down menu? thank you

how do I select all the fields on the form in code-because I want to move the top value of the fields?

I have a form that I use only the detail section of it-and in the detail section I have 30 fields-now-depending on the value of one of the fields-I want all the fields to move up/down accordingly-so I guess the best would be to make the top margin higher or lower (instead of coding for each...

I have a table with fields 1-31 (for days of months) I have code running through to determine what info to enter into what day of the month (not all fields get a value) so I have a variable that I ca set for 1-31-how can I code so that the value should go into the right field my code is now ...

Is there a way to combine 2 tables-from 2 different databases-they are both students table but they also both have their own autonumber for id-so many numbers are duplicated. thank you in advance

I want to update 1 field in a record on the website-here is the code-but it's not doing a/t. I'm fairly new to this so I'd appreciate help. (do I have to list all fields-even though I'm just working with one?) heres the code: Select Case a Case "I": ' Get a record to display tkey=key...

what I need to do is this: take a dob from a table and see according to the month which due dates I need for it. ex the 4 months that the reports are due are nov, feb, may, and aug. now if a child's dob is in october then the first will be due on nov 1, the 2nd on feb 1st,and so on. but if a...

I have a report with a subreport. but I only want the subreport to show if a certain field on the report is not null. where and how do I code it? thanks

I have the following code which results in a runtime error 2465 application-defined or object-defined error pubform is a subform-and I want s/t to occur when it has no data-what is wrong with my code If forms![frmProcess_Sessions]![Pubform].Report.HasData = 0 Then MsgBox "no records-go on"...

if I have a table with 4 fields (a1,a2,a3,a4) how do I get the max value from the 4 fields (ex. if a1 is 2/1/03 and a2 is 2/5/03 I want the latest day 2/5/03 to come up-for a certain record?