Search results

I have a problem I need to know where to find the currency format that would show the words of the whole dollar amount For example if the field containe $4,125.50 I would like it to print Four Thousand One Hundred Twenty Five This is for a tax receipt and it MUST be in that format. Gotta love...

That Worked Perfectly Thanks

I believe so but how do i tell the second form to go to a new record. I tried the code at the beginning of this post but it did not work

They are not identical records. They are two separate forms based on two separate tables. On the save command button in the first form I have placed several 'setvalue' commands that update the second form. I need to save the current record that is displayed in the second form and then clear the...

There is no relationship between the forms but both are bound to separate tables.

I have a command button that i need to be able to save the current record in a completely different form and then start a new record in that same form. I tried Forms!hfrm_PerSerOrgSerAssoc.Form.NewRecord but that did not work. Can anyone assist me with this one Thanks

Thanks everyone for your input. By using dmax before and after the append I was able to come up with the valuse I needed.

Using them in a delete query if an invoice has to be regenerated. Long story but I inherited this database that was originally and sql db gated to access....

Would this not get me only the one id that was at the end of the append. There are between 40 and 50 records appended each time and the number is never the same

Ok this is a bit of a weird one. I have an append query that appends records from one table to another. The second table's Primary key is an autonumber field. I need to capture the ID's that are created when the append is done. Any suggestions would be greatly appreciated.

I could not get Max option in the query or DMax() function used in the query to work but TOP 1 with records in DESC worked perfectly. Many Thanks

What I need is only one record to show that being the one with the highest value in a specific field.

What is a TOP 1 query

Not a report or form. I need to use this record to append to another table using the values in this record as a basis for some calculations for the appended record

SELECT tbl_ProgramInvoiceLineItem.ServiceID, tbl_ProgramInvoiceLineItem.ProgInvLineItemCount, tbl_ProgramInvoiceLineItem.ProgServiceAssocID, tbl_ProgramInvoiceLineItem.ProgInvID, tbl_ProgramInvoiceLineItem.ProgInvLineItemCount, tbl_ProgramInvoiceLineItem.ProgInvLineItemUnitCost...

I am having trouble trying show ONLY the record with the highest value in a specific field. The query shows the record set that I wish to grab the record from but I can not figure out how to show only the record with the highest value in a specific field I know this is probably easy. I have...

I know I my=ust be having a bit of a brain fart but how do you number the lines in the detail section of a report. I have searched the forum and did not see any relavant info

Ok but how do I get the custom toolbar and blank menubar to be visible on my report when the first code has turned all toolbars and menubars off. Do I use the opposite code on open to show all toolbars and menubars and the reverse it on close. That seems a bit cumbersome.

Hello Thanks for your input but neither solution seems to work. Because I have disabled all toolbars and menus with the first piece of code selecting a custom toolbar in the report properties has no effect.

I have followed the instructions in post http://www.access-programmers.co.uk/forums/showthread.php?t=100810&highlight=menubar In the onOpen evet in my splash screen I have place Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i And on the onOpen event in...