Search results

Thanks Steve, I'll reinstall Access and move on. Fingers crossed! I appreciate your input.

Hi Steve, For some reason it looks like I'm running in safe mode on this post so I'm not able to show a graphic of my references or use QUOTES or CODE icons. I was able to find my hidden Mac libraries, but not able to find any references to MS Word that I could share to Windows. I reloaded...

Thank you for the indepth response and pics! You are correct, the error I first get when I open my db regards broken references. With Parallels, printer, USB, etc have to be shared so the Windows side can see them. I'm wondering if I can share software (libraries?). I'll look through my...

The first error I get is when this line is encountered Set objWord = CreateObject("Word.application")

Hi All, I am running Parallels on my Mac to create a dual platform since MS hasn't released a Mac version of Access. My computer is getting slow, so I loaded Mac's version of Word and Excel and removed them from my Windows side so I have more space for Access. Now Access is complaining that...

Sorry, I didn't realize you posted a response to the "p0" question. I'll get started on this one again and follow up.

Hi Mark, Thanks for the effort! In the search form, I typed in 'George'. More records were returned than should have been. The hierarchy you used is correct so I'm trying to figure out your sql statement. Sorry, I write like an end user not a programmer. What does 'LIKE p0' mean (where...

Hi MJ, Using one table to store one record was my attempt at storing the selection from the listbox. The table would get rewritten every time the code executes. Thank you for the suggestion. I have googled listbox but have yet to find someone using vba to get the listbox's selection. Your...

Hi Mark, I'm not trying to be stubborn about setting the People as the top of the hierarchy. This would be a total teardown of everything I've built (20 years ago) and I no longer have the skillset to do this. I've actually forgotten how listbox works and am now stumbling around trying to...

Yep, you're seeing my problems before I've even encountered them. I'm still trying to get my sqlstr to read correctly. Okay, so there needn't be an rsA and rsB. PeopleID is a unique identifier so once a record is selected on my listbox, IF I can capture the PeopleID, then I can do a findfirst...

Hi MJ, Thanks for looking at my db. So would the combo boxes always show or would they be on a pop up form? As you can see from the size of Neighborhood Input Form, there isn't much room for additional forms or footers. I think the unbound pop up form with an unbound listbox is what's...

Hi All, I probably should have started this as a new thread but since MarkK had given me the solution and I had follow up questions I stayed with this thread not knowing if he would read my new thread. As a quick overview: I am trying to search within a subform for the next matching record...

I'm getting an error "Object doesn't support this property or method" when I changed my code from Set Forms!frmResults!lboResults.Recordset = CurrentDb.OpenRecordset(sqlstr) to Set Forms!frmResults!lboResults.ControlSource = CurrentDb.OpenRecordset(sqlstr). Your original...

Hi MarkK, 'open frmResults DoCmd.OpenForm "frmResults" 'set recordsource to sqlstr Set Forms!frmResults!lboResults.Recordset = CurrentDb.OpenRecordset(sqlstr) You're right! I thought I was setting the control source. That wasn't intentional, what's the...

Hi All, Sorry for the long delay--I get a chance to work on this every few months. I liked MarkK's idea about opening the results of my search in a listbox and started working on it. My function opens a pop up form containing an unbound listbox then I realized how do I get the answer from the...

Hello All, To JDraw, I'm still working on the last project you helped with. I have a neighborhood address form and on it a family subform and a people subform, which contains a phone subsubform. I would like to look up double click the field for people by first or last name, email address and...

Do you have a suggestion for resetting the recordset? If I look up 'Moore', then look up 'Asten' I get record not found since I've already passed it to get to 'Moore'. Is there some sort of recordset reset I can use at the end of the search function?

Yay!!! I like that! Ok, I'll give that a try as a pop up. Thanks!!!

Picture this...one form with two subforms and one of those subforms has two subsubforms. On this "form" I can see all of the info I need. However, when I look up a family, say the Moore's, I only see the first family in the db. I have to go into the tables behind the forms and find the...

I'm now testing with clones. My problem is if there are multiple names to be searched, the user has to say 'next', and the code starts again. That's why I'm writing to an unbound text box as a place holder to start the next search. My code was similar to what you posted and I couldn't go to...