Search results

Hi JHB , Thank you for expend your expensive time for help me and solve my problem . Can you please complete sample database with use update query against table5 and the DoCmd.TransferSpreadsheet to convert table5 to excel file ? Best Regards Jack

Hi JHB , Thanks for your sample database . It work very good and I found control in Company Name and Total Amount , All tab . I have some questions : 1- Can I use report to create Table ? 2- Possible use report output to excel file ? 3- Possible use report to insert 0 into empty fields...

Hi JHB , I dont know which way I can use report to get my request . Can you please use sample database and create report that you said ? And can use report to create table ? Thanks Jack

Hello My Friends , 1-With help of Ben ( my best friend ) , he create an example and solve my problem asked in Post ( Need Help To Search ) . With many thanks from Ben , I put modified example here : After run qry_MakeTable5 , Result as follows : If possible, I need to make some change...

Hello My Friends , 1-With help of Ben ( my best friend ) , he create an example . With many thanks from his help , I put modified example here : After run qry_MakeTable5 , Result as follows : If possible, I need to make some change on query or use any way after finish query remove repeated...

Hi Ben , Thank you for expend your expensive time for help me and solve my problem . As you said , if you permit me to share your example with others , maybe somebody can help me to do that . I wish good days and success in the future for you . Best regard Jack

Hi Ben , Your example was very good and helpfull . I add some record to two databases 1 and 2 . After that I run the query qry_MakeTable5 . The result is as follow : If possible to make some change on query or use a temp table to store result and after finish query remove repeated items and...

Hi jdraw , I send you message on that forum . Please look at this message . Thanks for your attention . Jack

Hi Ben , Too much tanks for your help . You right . I confuse and mistake definition about table and database . Please excuse me . My purpose was 5 tables in a Database . I will test your example and tell you about result . Best Regards Jack

Hi Ben , Because i am new in access and specially not understand link method , is it possible you send me a sample that contain above your comment as following database description : Database 1 : Fields : ID - Company Name - Total Amount Database 2 - 3 - 4 : Fields : Company Name - Code -...

Hi Ben , Thanks for your recommendation . I will try this and hope work for me . Jack

Hi Ben , Thanks for your Response . You are right . The databases really are chaotic . Because they came from 4 places . I should use only company name in database no 1 to search inside all other 3 databases . I am new to access and in my office we have ms access 2010 . Can you please send me an...

Hello My Friends , Excuse me about my bad english . I have 4 Databases . Database no 1 has fields like: id - company name - total amount . Other 3 databases has fields like: company name - code - date - amount . I shall use company name in first record in database no 1 as search string and...

Hi , Excuse me for poor english . I found some sample about forms with transparent background and also translucent form and use them in my forms separately with access 2007.I had two problems as follows : 1 - I couldn't combine these two shape to a form together . 2 - I couldn't put the public...

I have 2 Access 2007 Files ( Suppliers.accdb ) and ( Personel.accdb ) in same folder as part of a program . When program start with double click on Suppliers.accdb , automatically open form Main in this file ( this form work as Switchboard ) . I want to open form PersonelInformation that exist...