Recent content by LLB

THAT IT!!! ... it's pulling the Null records too.... but I need those so I changed the criteria to Not Like "MTC*" or Is Null and it works. Thank you.

In my query I want to filter a field to exclude all records that start with "MTC" so I used the Not Like "MTC*" in my criteria. In my list of 100 records I know there are only 6 that meet this criteria but when I run it my results only have 56 records. (The other 38 went to Neverland) If I...

I threw the calc fields onto my main query for my reports and the criteria filter into the sub query within the report and it worked great. Thanks for the quick help.

My ultimate goal was to create a list of projects where the estimate is less than one thousand dollars. I have two different estimate fields to draw the data from. Estimate 2 should be used if it exists and if not, use estimate 1. My query had 3 calculated expressions: 1) Estimate1...

Did it again.... Only this time I don't have the 2nd monitor enabled. I can toggle the window on and off but it's not there. Very frustrating. Any thoughts?

Thank you... ended up doing that and it works now.... still not sure how I did it so that I don't do it again. (But that pretty much describes how I get through most of my day) Thanks again.

I don't know what I did.... and this is probably a stupid question.... but today when I went in to work on my reports the Grouping and Sorting box has disappeared off my screen. I can toggle it on and off but doesn't show up. It must be off the limits of my monitor but the scroll bars don't...

Any new thoughts on this. Still having the problem. It is in the report footer, and even if I have Access automatically insert it, it will display the error instead of the page numbers. I appriciate any and all insight.:)

I have a table with several date fields. All the fields are formatted to medium date, but the data is being saved in to different ways. Some records are yy-mmm-dd and some are dd-mmm-yy. Each field has at least a few inconsistent dates but not always in the same record. I can't figure out...

I tried removing the calc'ed fields from the query, no change. I tried creating a new query with only the fields I needed, no change. As I said before, this works on my main admin form, and when I noticed that the query for the main admin form had only the primary table in it and no secondary...

I have a main administrator interface with a similar data entry form (no sub form there) to which I added the update filed with my original code and it works great. This is what I used in the "before update" event: If Me.txtUserUpdateDate < Now() - 1 Or IsNull(Me.txtUserUpdateDate) Then...

Sorry Bob, I only have A97 at work. Let me see if I can explain this without fumbling too much....(newbie here) You are rigth, the recourdsource is not updateable. I don't know how it got that way. This is a form with a sub form. The main form fields are locked out because they are entered...

Bob, thanks for the reply. I pulled my original code from another one of my databases that I inherited and it works there. But I did take your advise and rename the control, but it still does not work even in a simple form: Private Sub Form_BeforeUpdate(Cancel As Integer)...

I can't even get the simplest code to work. Private Sub Form_BeforeUpdate(Cancel As Integer) Me.UPDATE = Now() End Sub It does not work for Before or After update event.

Similar Problem I am trying add an update date to my form as well. I have used this code: Private Sub Form_BeforeUpdate(Cancel As Integer) 'Checks to see if the entered update date is valid. If not valid, sets it to current date. If Me.UPDATE < Now() - 1 Or IsNull(Me.UPDATE) Then...