Search results

I think I understand that, but the problem is that I have duplicate Invoice Numbers and needed a way to track a particular invoice. Some invoice numbers, depending on the vendor can "roll over" once a month. Without a date, I couldn't determine a way to insure that the invoices are matched. I...

The main form updates one table and the sub form updates another. They both require the date. There's probably a better way of doing that but other than creating a temporary table to store the values and then appending to the appropriate tables, I couldn't come up with anything as efficient.

David R, The InvoiceDate field will not be today's date. Invoices are received a week after the Invoice is generated. Therefore, the user has to input the correct InvoiceDate on the form. I have solved the problem, although it's probably not the best way. Thanks,

It's not a field name. I was just trying to keep the example simple. The actual field is InvoiceDate. I have found a way around the problem by using the "beforeupdate" event and the same code. However, I don't think that I should have to do that.

I have a main and a sub form that I am working with. I have a date field on the main form that I want to be displayed on the subform without the user having to enter it for each subform line. I have coded the "Oncurrent" event for the subform with: If Me.Newrecord then...

Hi Helena, Actually, I did change it to IsNull but this didn't help. I finally solved it by deleting the form and rebuilding it. I haven't changed the code at all and it works like it should. There must've been something corrupted within the form that prevented was preventing the code from...

I am having trouble with code that has to be a simple error but I can't determine what it is. I have a form that is linked to a query with one field. I want to evaluate that field and if it is null, perform an action and if it is not null, perform another action. The query and linked field on...

Actually you can us SNP as the constant with Access2000. I'm not sure what version you have but I found this in A2K and it doesn't appear to be documented. Instead of DoCmd.SendObject acReport, "ReportName", "RichTextFormat(*.rtf)", _ "EmailAddress", , , "OptionalSubject", "OptionalText", True...

You can do all them. The easiest way that I know would be to create a form with a text box to hold the "Entered Date" and use this for criteria and formulas. You could hide the text box to make the form more appealing and add code that runs the report upon opening the form. You can also use this...

Thanks for the info. I have many tables in the database. Again, I was trying to keep the example simple since it didn't require details of other tables. I only needed to enter data in this table. The one-many relationship does not come into play with entering the data on this form. Thanks to...

Pat, You are correct, there is other info but I was trying to keep the example as simple as possible yet contain everything that I need done. I simply need to be able to enter data into ONE table using a form but having repeating values for two fields and allow me to enter data for a field...

This should be about as simple as it gets, yet I can't determine how to do it. I have a table with form that I want to enter data. The fields in the table are: Invoice, InvoiceDate, & Amount. The Invoice and InvoiceDate will be the same for 50 or so entries. On a form, how can I just enter...

I have an expression that I am trying to reference as criteria in the same query. Is this even possible? I think I know how to do that with a form and unbound textbox but if there is an easier way inside the query, I would rather do that. The SQL is: SELECT [Enter Qtr] AS Qtr, [Enter Year] AS...