Search results for query: *

I have a master 'Case' form with a list box for individuals in case. When you click on cmdAddInd button, you go to popup form that allows you to add ind from other case or add a new ind... Once selection is made, clock on 'Add' button & goes to popAdultNew to enter info... Sequence...

Many thanks--- will try that.....

This may be a silly question but I have a sub that loops thru each record in a table & either updates some fields if some conditions are met or moves on to next record. Criteria is somewhat complicated & based on select case statements of several fields. Problem when I was testing was that if...

I think that you can only get the variable value from another form only if that form is still open. Variable in form in which value is set should be declared as Public blnAnswer As Boolean and should not be redeclared in your other form (the one that retrieves the value & uses it)

I will try that approach... I'm still curious though about why sql statement was truncated as I have other complex forms & will need to take this little quirk into consideration... Many thanks.

I have a form created in 2002 Access to be run on Access 2000 (I set to 2000 file format). Forms runs fine on XP computer but first time I oepn the form on 2000 machine, the record source sql on the form is truncated & form can't run. This is a pretty complicated form pulling data from a...

Thanks--The only thing I'm not sure of is where would I put the code for the controlsource. I tried in the report 'on open' event but it doesn't seem to work...

I'm not sure this is possible but... I have a subreport which contains 1 field--this is a statement containing various fields in subreport row source. I tried setting value (me.field ="..."] in vbo in on open event but that doesnt seem to work. Reason I want to do this is that I...

I have looked thru previous posts but cannot seem to find the answer. I have a form linked to several tables-uses unbound fields. tblTempChild is main form & holds child info until it is processed or deleted. - cmdChild button goes to sub to add new child to tblTempChild. - User gets a 2...

When I want to test for null or empty or whatever on date, I use: If Len(datefield)<1 or isnull(datefield) (code for actions if date is not entered) Else (code or actions if date is entered) End if I'm sure there's a better way but this seems to work & avoids...

I have used this code in the 'on click' event of command button. Since I want to replace the existing tables, I delete them first with DoCmd.RunSQL &quot;DELETE FROM tblCase;&quot; DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, &quot;tblCase&quot;, &quot;(your path &...

Thanks for suggestions but I'm still not sure... my form is unbound so I save using docmd.runsql & sql statement. I append the record to the table first with some basic info from another form/table & then give the user a screen/form to add additional info. I don't get the message when I append...

All of a sudden I'm getting this message when I try to save record changes a second time from a particular form: &quot;Another user edited this record & saved the changes before you attempted to save your changes; re-edit the record.&quot; I am the only user---database is only on one computer...

What about.... Docmd.OpenForm &quot;InspectFindings&quot;,,,&quot;FindingNum = '&quot; & me.txtSearchFindingNumber & &quot;'&quot; I think I have the right # of commas... you don't need to enter quotes on arguments you don't need. Just watch the apostrophes, single & double quotes on your...

May I ask how you did it???? Thanks.

What about lbldifferenceAR.Caption = FormatCurrency([SumOfSumOfAR] - LastAR, 2)

So what you're saying is just to ignore the error message... fine with me but I just wanted to make sure it wouldn't cause some other sort of problem!

ok-I can check for 'null' date field but how would write code? (Date fields are among other fields being added) Right now the sql statement looks something like this: &quot;INSERT INTO tblTempPlace(npTranID, ......, npOFacOut, ...)SELECT '&quot; ... Nz(me.txtFacOut) & &quot;' AS npOFacOut...

I have an unbound form from which data entered by user is saved to various tables when user clicks on 'save' command buttons. Among the fields are several date fields that do not have to be entered in all circumstances. I use an SQL statement & docmd.runsql but if date field remains null, I...

I think this is what you mean: strSQL1 = &quot;SELECT tblTempAdult.adLast & ', ' & tblTempAdult.adFirst AS AdultName, tblTempAdult.adBD AS Birthdate, tblTempAdult.adSx AS Sex, tblTempAdult.adCin AS CIN, tblTempAdult.adSS AS [SocialSecurity#], Nz(adPANum) AS [PA#]&quot; strSQL2 = &quot; FROM...