Search results

Sorry I forgot to mention that I am using Access 2003

No the number receipts will vary each time the query is run. Here is the code UPDATE tbl_Events INNER JOIN (tbl_Activity INNER JOIN tbl_Contacts ON tbl_Activity.ContactID = tbl_Contacts.ContactID) ON tbl_Events.EventID = tbl_Activity.EventName SET tbl_Activity.ReceiptNumber =...

Ok let me try to explain again cause I think I did not do a good job. I have a query that shows a recordset based on two peices of criteria. The receipt number in these results is blank. I want update the receipt number field of each record starting at a value that has been entered in a form...

Would you know how to make that loop through a set of records in a query to place a value that was increased by one in every record

It is on the pre printed receipt and I need to store it in the activities table where the record is stored.

The issue is not wich records to print. The issue is to update a receipt number to each record that I am going to prnt

I am afraid that is way over my pay grade. I do not even know where to begin

I have a query that is used to collect a recordset from a table for printing receipts. The receipt number needs to match a pre printed form from the government. The receipt numbers are sequential I need a query to populate the receiptnumber field sequencially starting ayt a number specified in...

It is the afterupdate event of the field ScheduledStartDate. Here is the code Private Sub ScheduledStartDate_AfterUpdate() Me.ScheduledEndDate = Me.ScheduledStartDate Me.ActualEndDate = Me.ScheduledSartDate Me.ActualStartDate = Me.ScheduledStartDate End Sub

Close With the code in the afterupdate event it did nothing. When i moved the code to the onexit event it did work to a degree. It did populate the other three fields but it was not visible. You had to either click in the fields to see it or close and reopen the form

Hi I tried exactly this on the afterupdate property and it did nothing. I moved it to the onexit property and it worked, sort of. The values in the other date fields where populated with the date from the first field, you just could not see it. If you click on the individual fields and then...

Ok not sure why they are 1,2,3 and 4 years hence. I need them all to be the same date.

Private Sub ProgramAddScheduledStartDate_AfterUpdate() Forms!pfrm_EventAdd!ScheduledEndDate = Forms!pfrm_EventAdd!ScheduledStartDate Forms!pfrm_EventAdd!ActualEndDate = Forms!pfrm_EventAdd!ScheduledStartDate Forms!pfrm_EventAdd!ActualStartDate =...

I have four date fields in a form. They are most likely all going to be the same date, however there is the possibility of them being different. I would like feild 2, 3 and 4 to automatically take the value of feild 1. I hvae tried Forms!pfrm_EventAdd!ScheduledEndDate =...

Thank you everyone for your help. With your assistance I now have this report looking just the way i want it. Thanks again

Awesome that worked. Now all I have to do is get rid of the leading 0 and the decimal point itself.

Did not work. This is in a report. The field name is TaxReceiptAmount I put in =int([TaxReceiptAmount]) and it showed me the value before the decimal place not the ones after it.

I have a rather unusual need. If I have a vale of $456.12 in a currency field how would I get it to only display the 12 part of the value. In other words just the cents without the decimal place or any or the numbers before it.

That worked awesome. Thanks I don't suppose that you know a way to display only the cents (2 decimal places) in a currency feild

Thank you for this. Unfortunately I know very little about modules and how to use them. If you could give me a little guidance or point me in the right direction I would greatly appreciate it Thanks