Search results

I want to run a macro which is having three action queries from the another database when i click the button from my current database. I am using Access2010. How to do it. Please help.

But when same data repeates in many records, i want to select all those data's and replace at one time.

Is it possible to have a Find & Replace in the table using access forms. ( Like the inbuild option in Excel ), I want the user to search some data & replace with the new data which may present in more than one record. I want to do it with forms, because i dont want the user to use the tables.

Hello, I am putting my effort to create a tracking tool to simplity the work flow and status in my team. My table is like the attached file. I have the work input from two source one i upload directly from the DB2 database and sometime i add the changes manully ( i have dataentry form for...

Thank You,:) What if in the case of One to many relationship database? how to link this to a form?

:banghead:Is it possible to link One2one relationship data base to one form?

Hi, I have a table where in 286 different fields have to be updated by the users. ( Nature of project :( And i have 10 fields which are coming as a input from another table, so i use Append and Update query to add the new datas and update the datas in case of any changes in the input from...

Re: DCount funtion in Form [Solved] voilà...!!! Its working!!! Thank you so much...

I tried both and still have the same error. When i try like this its working =DCount("[A2p]","[Customer Table1]") but this not meeting my requirement, i want have the data with No. I get this "No" from the users updating the check box and in my table i kept the field property as textbox in...

like this #Error

Hi, I want show the count data in one of my form. So i use Dcount in control source but i get Error for the below 2 fields. =DCount("[A2p]","[Customer Table1]","[A2p]='No'") A2p - is field from table Customer Table1 in this i want to count the No A2p is text box format in my table...

its working :) thank you

Hi, In my access form, i have four check box ( 3+1), from this, if the user select any one or more than one check box from the first three boxes, i want the fourth one to check automatically, is it possible? please help!

:cool: I tring to create a tool in my team to track the work. I receive the data from engineering team lets name it as MAster database( in DB2 database - Read only ) and then i want to assign the data to each member and staus will be updated by them. :) So my Idea is upload the data from...

U r right, thank you paul. its working now.

Hi Nigel, When i use this fSetAccessWindow(SW_SHOWMINIMIZED) in my Home form, it hide this form also along with the access window. how to fix this.

How to update data from one table to another table using form. I have data coming from design team in Database 1 and using form i want search data and assign the job to a person and store it in the database with his name. I have to do this because database from design team is read only...

Hi JHB, this exactly what i am looking, could you please help me, how to do it?

Hello All, Is it possible to create clustered & stacked column bar charts together in a same chart? please hlep!

Dear All, In my access query, i link an excel file from our share drive with the Query - When i share this query with Multiple user - While User1 using this query, if the second user tries to run the same query i am getting the follwing error msg. The Microsoft Jet database engine cannot open...