Search results

That worked...Thanks for the help. MK

Hi Rich, I finally had a chance to use this code but when I'm getting a run time error. The error states "The Action Method requires a Form Name Argument. Here is a cody of my code. Private Sub Form_Open(Cancel As Integer) If (RecordsetClone.RecordCount) = 0 Then MsgBox "There are no...

Thanks Wazz...I'm still fairly new to VBA. Would I do this on the form load event? Any chance you have some sample code that would be helpful? Thanks MK

I have a form that is based on a search query where a prompt is displayed for the user to enter their search criteria. The form then displays the associated records with that search criteria. This is working great with one exception. If the user enters no criteria or searches for something that...

Thanks Guys...I think I have it working now.

I'm not sure if this is even possible in Access. But I would like to change the properties of buttons based on if data is entered in specific fields of the tables the buttons are associated with. Specifically, change either the button color or the text color on the button. Does anyone know if...

Thanks WayneRyan...It looks like that worked perfectly. MK

This is basically what I'm trying to do. if RecordID does not exist in TableA, I want to run a save process and then continue on with my code. If RecordID does exist in TableA, I want to skip the save process and continue on to my code. This seams to be a pretty simple If..Then..Else...

Hi Uncle Gizmo....I've actually already figured out how to fix my problem. Thanks for responding. MK

passing value from query form as search parameter to another query I have a form that is based on a query. The query allows the user to enter a String and will search several fields of the Parent table for any instance of that String and will return the entire table. I have a button on the...

That's great. Works just like I wanted it to. Thanks for the help dK.

Thanks dK. That seams to work (I had a minor Syntex error). One more questions. It displays a pop-up box that states "you are about to append 1 row". Any idea on how to turn this off? Thanks MK

I would like this to occur regardless of creating a child record. All tables have seperate data entry forms. This is basically a database used for tracking different types of repates. There are many types of rebates available and some people may qualify for one rebates or multiple rebates. I...

I have a database that has one parent table and multiple child tables. The parent table has a RecordID field (primary key) that is an AutoNumber. All the child tables have RecordID field with a one-many relationship to the parent RecordID field. What I am attempting to do is have the RecordID...