Search results

Hi, I have use : Hide the database window DoCmd.RunCommand acCmdWindowHide Unhide the database window DoCmd.SelectObject acTable, , True Instead of Hide the database window DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide I have takeout this line : DoCmd.SelectObject...

Yet, it works but in Excel file, the cells are in gray background and the words are in white. How can I change this format ( in Excel or in Access) ? Another question, I want is to importe data from Excel, I have try to create a same command button but I didn't see where I can find. I have look...

Thanks for your reply. Yet, but I doesn't hide the database window which you can uncheck (hide this window) by the setup in the main menu. This is fine but if I want to reactivated how can I do this ? Thanks again, Le

Hi, How can I customize a menu bar? Example, if you a viewer, the menu bar is deactivated and if you are the editor, the menu bar is activated but only the import and export functions. Is it possible? Thanks, Le

Hi, I have try to create a command button in the form that send all data to a file but it seem don't work. Can you give an example? Thanks, Le

Thanks, Look where ? Le

Hi, How can I export or import data from my database to Excel? I have securise my database by uncheck all features on the start menu bar. Then, with this I cann't access any more to my tables, if I want to import data from Excel to my database, how can I do this? Thanks

Can you explain more on looping throught the form collection ? I don't quit understand. This sound good for me because I hide one form at the time. Thanks, Le

where should I put? In the form #1 ? If so, the problem is, I have serveral Main form which can enter in the form #1. So, YourForm should be which main form name ? Example : Main form #1 , #2 and # 3 can open form #1. So, if I open the form # 1 with the Main form #3, when I close the form #1...

Hi everyone, How can I reapeare my form when it is invisible ? I explain, I have a Main form and when I click on a button it open another form #1 then the Main form is invisible. when I close form #1, the Main form didn't reapeare. So, how can I reapeare the Main form? Thanks, Le

How can I programme this? Open the main form and then check the if statement. Le

Thanks, Yet I have try that, the popup form open up before the Main form open. Le

Hi, My problem is where I can put a condition statement which a popup form will appeare when the condition is true but before that I want the form open and it check the condition statement. Any ideas? Le

Hi, My problem is : I'm refereing a field in the subform, a count field which count the number of client names. My subform has to put to allow add data if not, when I applied a filter and the search is zero, my count field in the main form gives me an error. Any ideas for not put my subform in...

Hi everyone, Please help. I have a form and multiple subforms. And each subform is separeted with a break page. My problem is when I open this form, it shows in the middle of two pages, it means it shows two half subforms. I have try to set gotopage 1 in the open main form, it works but the...

Try this Put on the subform ; in activation control : Me.Recalc Le

Thanks again, Le

I think the simple way to do this is : 1) created a count field in the subform i.e created an independent field. Give this field a name say " txtcountsubLiq" and in the control source : =Count("fieldName?") (that you want to count) 2) goto the main form, created the an independent field...

See attachement. Maybe this help... Le

I have put in my query that you have suggest but a popup form ask me the " LastUpdateDt" parametre? Le