Search results

Ok, thanks!

I have an EventNote form that can be opened by clicking on the Note icon from another form or it can be opened when in EventDetail. I put the below code on the OK button: ' User wants to save and close the form If CurrentProject.AllForms("fdlgEventDetail").IsLoaded Then If Not...

Got it, thanks! And, the error doesn't happen all the time where I could pin point when and stuff.

Using Access 2007 on Vista. No, I don't know what line is causing the problem. How do I tell it to "Break on Unhandled errors"? Are you saying to remove the error handling stuff from the all the code above?

Sometimes I get the below error message when I open a form; I can't figure out what causes it; I have to close, compact db, and reopen until it goes away. The expression On Click you entered as the event property setting produced the following error: Object or class does not support the set of...

Well, the below seems to be working: EventJobPosting: IIf(DLookUp("DocumenterAttachment","Documenter","EventID = " & [EventID] & " AND [DocumentTypeID]=10") Is Not Null,"C:\Users\LMCC007\Pictures\paperclip -- tiny.bmp",Null) Do you'll see anything different with the above code that I don't...

Yes, it's numeric. No lookups in table. You guys have hit me over the head about that even though all the classes and books teach it that way--I no longer use lookups at table level; they are created in the form. I even removed the multi-fields in the table.

Still get Error#. Here is my code from another table that is working: EventNote: IIf(DLookUp("EventNoteID","EventNote","EventID = " & [EventID]) Is Not Null,"C:\Users\LMCC007\Pictures\Note.bmp",Null) Why does this code works and not the other?

I get #Error. Here is the SQL text: SELECT Event.EventID, Company.CompanyID, IIf([Company]![CompanyName]="","Company ID " & [Company]![CompanyID],[Company]![CompanyName]) AS Company, DLookUp("Documenter.FileName","Documenter","EventID = " & [EventID] & " AND DocumentTypeID = 10") AS...

I get the #Error with both. I change the last to: EventJobListing: IIf(DCount("*","Documenter","EventID = " & [EventID] & " AND DocumentTypeID = 10")=0,Null,"lovely") and it seems to be working. You know the code I first posted is being used in another query and it is working fine. That's...

#Error Query gets #Error when I hit Run! I am trying to say: 1) Check to see if Documenter.FileName is not empty 2) If it is not empty, look for DocumentTypeID 10 3) Display image icon Below is the code I'm using: EventJobListing: IIf(DLookUp("Documenter.FileName","Documenter","EventID...

Thanks boblarson, I did: If Not IsNull(Forms!frmViewJobList!txtCompanyID) Then... in my form on the On Load Event. That did it. Thanks for your reply!

If (Forms!frmViewJobList!txtCompanyID Is Null) Then

Now it gives me Error # 424: Object Required

When the below code runs and there is no data, I get Error #3075 -- Syntax error (missing operator) in query expression '[CompanyID] = And [ActivityID] = 1'. Public Function JobTotal(ByVal strActivity As Integer) As Integer JobTotal = DCount("[ActivityID]", "Event", "[CompanyID]= " &...

I just found out from Access 2007 Bible that Crosstab queries are not updateable, so that's not what I need for this form.

To get a quick glimpse of all the events. Then once the form is working; they can double click an event from the list to see the details.

Now, I can't get it to work with my form. I created subformforFORM using Query1_Crosstab1 query and it's not working. Meaning: 1. Keep losing the master and child links 2. I tried using Nz([EventTypeID], 0), but it does nothing. Basically, I want all the fields to show whether it is...

Thanks, I'll read it later when my brain settles down.

How do check the locking parameters??