Search results

Hi, I've earlier posted on the same request but, I'm quite unsuccessful in getting that yet. I have a unbounded form which has all the fields same as the table. Now I want to search a row from the table with the Ticket number and First Name. After retrieving all the fields instead of using...

Hi spikepl thanks for your response. I've tried with both bounded and unbounded form controls. I'm missing something. If possible please help me with the coding. Linked Table name is DATA

Hi I'm successful in adding data from the form to the table using VBA. But I couldn't retrieve and edit the data. For retrieving and editing the data I have a different form "[Forms]![Editor]". I have all the fields listed in the image in both the form and table (see the attached image) 1. I...

I'm able to log a new record successfully from DB1 to DB2 1. I'm finding a way to retrieve the updated log using a search option. e.g., If they have updated an activity as "Pending" I should allow them to pull that row back using search button and edit accordingly later. (multiple fields are...

Thank you RX for replying to my thread. Whatever you've restated is correct. The first db where I have the form and macros is 2010 format and the second db which is stored in a shared folder is 2007 format. I've actually created the linked table and my concern is now the VBA program to search...

Hi I have two different database files. One is 2010 ".accdb" format where I have created a form and the inputs to the form is getting saved as records to an access.mdb file in a shared path. Now if the users want to edit the existing record I should allow them to search their previously...