Search results

Thanks Gina. That's a lot of code to grasp at once and my head hurts:confused: I'll move on to something else for now:)

as you guessed, it didn't work! after typing the search text and clicking on the SEARCH button a dialogue box popped up showing: [MacroError].[Description]:confused: However when I finished typing in the searchbox and clicked the button, the find/replace box popped up. That is not what I...

I selected "macro builder" for the double click event and went back to the On-Click event and the pop up came back. I'll apply the Filter. Hope it works. Many thanks Gina:)

I clicked on the GOT FOCUS event and had a pop-up. It asked what I wanted: Macro, code builder, etc. That is what I need for the "ON CLICK" event but it doesn't pop up:o

I did many times but whenever go back and I click on the ellipse (...). It recreates the lines:banghead:

it still took me strainght to : Private Sub cmdSEARCH_Click() End Sub

nah! I didn't.

Hey Gina, one more thing. In the On Click Event of the SEARCH button, it automatically takes me to an empty VB subroutine. At the beginning, when I clicked on the ellipses (...) it would show an option of macro or procedure. Now it goes straight to procedure. How can I switch the window from VB...

sorry didn't mean to be a nag. I'd checked yesterday's thread before starting this one and there wasn't an update at the time. Thanks again. and you as well vbaInet!!

tis working now. Thank you Gina:)

Hi, could someone help me with the code to fix this SEARCH button please?:confused: When I type in the searchbox, the subform pulls up the data already. The button gives an error when clicked. I would get rid of the button but the searchbox looks better with it. Any help is appreciated.

a thousand apologies. okay this is the correct one.

okay not sure what happened dere but this is the embedded code: OnError Go to Next Macro Name RunMenuCommand Command SaveRecord If [MacroError]<>0 then MessageBox Message = [MacroError].[Description] Beep Yes Type None Title EndIf...

Please see the attached.

hey GinaWhipp, I looked in the event tab for the button and there is nothing in there. How do I get the embedded macro...?:confused:

I don't have any code for this button. I reckon that Access did whatever it did when I specified, button should save a record. I just need the form details to be cleared after it saves...

hey GinaWhipp. Just to clear the form after saving, and the cursor go to the beginning of the form for the next entry. Thanks much

hi, I'm a beginner with VB. The SAVE button on my data entry form saves the data but it does not clear the form afterwards i.e. for the next record to be entered. Could someone advise on the code to do this?:confused: I created it using the control wizard. Any help is appreciated

Okay I think I got confused because in my Access what I have is the combined subform/subreport icon. Apparently the subform container is already applied at the end of the creation but I was still trying to get the separate subform icon to act as a container. my subform is populated with the...

um, apologies if this is not a bright question. In creating the subform, I referenced the obstetrics table and the subform was created with some of its fields but how do I get it to lift data from obstetrics? I imagine that as the database grows, I'd want the subform to dynamically adjust itself...