Search results

Some times my memo fields will not save additional information. The text is long but not that long--it is about one to two pages. I created a save record button using a macro to see if that would save the text, but I get the following error message: Could not update; currently locked by...

Hey vbaInet, You must like confusing me. The link you gave me to the Requery with bookmark by Baldy Web does not work for this form. Actually, the above code works. There is just two problems; they are: 1) If you delete the first record, you get: Error: Not a valid book. Error Number...

No--been to busy looking up recordset.bookmark stuff. I was looking for a quick answer but ended up spending the day reading the many, many, many post re bookmarks. Anyway, I got stop because I am so behind on other tasks. Now I see why so many databases are hard to use--not that user...

What's wrong with the design. In all my classes and being train I was told you create forms from a table or query. Use unbound forms to filter or search specific fields. You have to be more basic with me--I'm no where near a tech guru--more of a end-user of Access.

Isn't this like the one I told you I tried but had trouble with? That is: Dim CompanyID As Long ' variable placeholder CompanyID = Me!txtCompanyID ' ID of record '... do whatever DoCmd.OpenForm ("frmViewEventHistory"), acNormal, , "CompanyID=" &...

I am not following you here. The forms are: fmainCompany -- Record Source = Company (1--main form--will always be opened--open other forms by clicking buttons) fdlgEventDetail -- Record Source = Event (2--used to add new events) frmViewEventHistory -- Record Source = qryF_EventHistoryList...

Yes, it is. All the event stuff is coming from the event table.

I tried the bookmark code, but it's not updating fmainCompany. Below is what I did: 1) Put the below code in the fdlgEventDetailDeleteEdit form in On Unload Event. Private Sub Form_Unload(Cancel As Integer) On Error GoTo ErrorHandler Dim bkMark As String If...

Actually vbaInet, you are correct. I found the code below and tried to make it work for me but was unsuccessful: Private Sub cmdEventHistory_Click() On Error GoTo ErrorHandler Dim CompanyID As Long ' variable placeholder CompanyID = Me!txtCompanyID ' ID of...

I reread it again and still do not understand what you are talking. I searched the web and do not understand the stuff I found. Tried some of the examples but nothing happened--still when you requery it goes back to Record # 1. Also, this must be a huge problem because one forum I happened...

I'm not getting it. I have to understand what Me.Recordset.Bookmark does/means. When I think of bookmark, I think of marking a place to come back to. (And, it's Friday night--my brain is wondering--I didn't plan on getting into something like this weekend.)

Not getting it. And the instructions for Form.Bookmark Property goes into ADO and DAO all that stuff. I'll look some more and maybe by tomorrow it'll come to me or know how to do it.

Yeah, I just did. That's a lot of coding--beyond me.

Lost Focus when requering frmViewEventHistory is a continuous form with Pop Up = Yes and Modal = Yes. While viewing the form and you double click a row it will open fdlgEventDetails form (that is also Pop Up = yes and Modal = Yes). That’s okay. After closing fdlgEventDetail, you’re back on...

No, it's not--just a single form with some command buttons.

Okay, I thought DLookup was an easy way to look into another table to see if something is there or empty.

These are different--command buttons on another form that was created from a table. They don't want to have to click the button to see if there are any attachments.

Yep, DCount did it. I am using IsNull for EventID and it seems to be work. Below is what I got: If IsNull(DLookup("EventID", "Event", "CompanyID = " & Me!txtCompanyID)) Then Is that okay or should I change this also?

I have a field in Event table called EventAttachment. EventAttachment is an Attachment datatype. I want the code to see if it is null and if so put No Attachment in the caption. Sometimes it works and sometimes it doesn’t. For instance, Record 455 has no attachments but it displaying...

That's it. Wonderful! Thank you.