Recent content by Dave Sherer

If you just move that expression you have written to the After Update Event Of the field that holds the SaleAmount that should work just fine.

you can try this on the Lost Focus Event If IsNull(Me.TextBox) Then MsgBox "Need To enter Data Here in this field",, "Need Data" Me.TextBox.SetFocus End If This will check if there is data in that required field once it has left lost focus on that field. This Will not on the other had...

I believe this problem is in your referencing make sure that you have the Microsoft Jet 3.5x or 4.0 checked in your refernces and that it is near the top of the list.

I am not to sure what you are say so I will post what I think you are saying. 1) You have a Manufactor Which has a series of products. 2) These products can have Multiple Serial(BarCode) numbers if this correct then what I would do is actually what I did. 1) Create a Manufactor Table with A...

Your are Using the SELECT INTO and that creates a new table. You probaly want to use the UPDATE statement. This way you can us your criteria on the table because it won't erase any records HTH

Good point Rich then the statement would look like this CRITERIA ([Forms]![BirthdayCards]![EnterMonth].Column(0)) and (Year(Now())

I am assuming <--(Bad Word) that you are using a query for your report source I am also assuming that you are using a form to get the date values. If this is the case then in the field that holds the date type the following in the criteria line =Between([Forms]![Form Nmae]![Date Field Start]...

Sorry Last Post I tried some HTML for effect and it did not work Plus I did make one mistake. It is all coreccted now. another way is go to the next open column an type in on the field line MONTH([the table the date is stored in].[The Field name of the date]) Then in the Criteria line put...

another way is go to the next open column an type in on the field line MONTH([the table the date is stored in].[The Field name of the date]) Then in the Criteria line put [Forms]![Form Name]![Field of user input] Example: [color red]FIELD[/color]Month([Child.Birthday]) [color...

after reading raskew comment to jwindon I felt appaled by the rudeness. lets take in consideration that when starting out in anything we know nothing so we do need help. Some of us are able to read and comprehend what we read and use it to our best ability. Others though need a more hands on...