Search results for query: *

Randy I'll check my code and get back. My Add Record control now picks up the incremented value with the corrected Dmax expression but I'm going to check your code. thanks Hymn: The control for DTnumber is the first in the form. I'm not sure where to apply the afterdate event procedure thanks

Thanks folks: Hymn: Thanks Do you mean if you have a form control that opens the form you want to increment you place the code in the "after update" event of the first form? Think I'm confused? Randy700 Thanks I replaced controlname with "DTNumber" (correct control)in the code . I...

Thank you Hymn I corrected the code as you suggested but unfortunately there was no change. The form opened to the first DTNumber. I'm trying to open the form ready for new data with the next available DTNumber showing in the form. Thanks again for your help.

Hello: I have a text box on a form who's control source is the primary key field of a table. I would like the form to open to the next value (to add a new record). The following expression sets the default value for the Data of this text box. (DMax('[DTNumber]','[Sypher Drawing Transmittal...

Thanks again Bob. It was abit confusung because the field is a text field so I first tried "" to check for a empty string but that didn't work on it's own. another simple but valuable Tip Thanks Bob for making a decent product better. In the big picture, shouldn't Microsoft owe you guys...

Thanks Bob, it worked great. I'm wondering..why do I need an or statement? Are "IsNull" and "" not considered to be the same with ,1,0))setting the count? Thanks again, Bob

We have a report where we, among other things, add the total number of particular values of field over a monthly time period. We have documents that are given a status value (SDComment); "approved", "rejected", "Resubmit" etc. and we then total each category(status)for that month in the report...

yes all other response dates, beside the ones in April, were blank in the report. I call a blank field in the report a null which is incorrect because the field is not null in the table. It grabbed all the received dates prior to this month and reported everything, except for all the response...

pwise Thank you pwise. It ran with some strange results. It picks up every record from last month to the first month (over 2 years ago)and if their response date is not April (in this case) it makes their response date a null (a blank field in the report). All response dates in April reported...

Pwise Your Activities query is almost identical to what I'm after. This must be another common report function of a database I would think. I can get the correct month but not the null values (no response date)of all previous months besides the current. Could you take a a quick look at my...

Thanks pwise I was using the 'or' statement the wrong way, ie. just adding ="Is Null" . Thank you, I'm sure this format will work.

Thank you pwise However.. I get a "Data Type Misatch in criteria expression" when I place "IsNull" in the 'or' field in the query design page. also when I use the 'and' statement to add the isnull in the criteria expression I have nothing returned in the report and all my count/sum boxes in...

Hello: I have a monthly report based on a query , grouped by submittal number, that sorts documents by the date they were responded to. The criteria of the SDSRDate (Response date) is set to filter only the previous months responses. The report is grouped by SD number (submitted transmittal...

Thanks so much, Bob. Both for the great start to a set up for the calender, as well as, the flag to Jimmy. Thanks, Larry

I have a report based on a query that sets the date range for monthly reports. Can I use the calender control to set the dates in the criteria "Between [Enter Start Date of Month:] And [Enter End of Month Date:]" in the query instead of typing in the actual dates in the pop-forms? Thanks for...

My apologies to all.I've re-read other threads and solved the problem. I've added a SD# group header and a text box (say text48)setting it's control source to -1.It's also set invisible and grouped overall. In the report footer I added another textbox with it's control source set to =text48...

Hello Everyone: I've re-read most threads similar to my problem but I'm still having trouble counting the total number of sorted groups generated in a report . Here's what I have. A report based on a query that sorts month,by week date and sorts/groups by a document transmittal number...

Thank you HTH I will build the public function you suggest and give it a try. Best Regards LDP

Thank you both. Yes it is the same concept of an invoice. They are actually transmittals from an project management office. I cannot set the datatype to autonumber, out of 830 records in this table 3 or 4 had to be suffixed with a decimal to represent a re-issue of the document. This is also...

Hello Everyone: I would like to increment the numeric value of a particular control on a form by one then move the focus to another control when I open this form for data input only. The related table is indexed and the number to be automatically increased is a primary key. This would set...