Search results

Hi jwindon, Really I don't understand what's DAO and what it will do with the library and the reference. I have simply installed A2K and then all my code did not work. How can I get rid of it all Or do I have to change all of my codes according to the DAO.. Sorry if this question is silly

No sir it's neither disabled nor a label. It was working very well in Access97 but not now in A2K. Maybe any missings in the library Any idea please with many thanks

Hi again, Well, I compile all modules and no problem in there. FieldName.SetFocus work well. But why DoCmd.GoToControl "FieldName" is not working anymore is my problem. I created previous dbs with such command with no harm. Now I'm using A2K. Will that make any difference

Hi All... I always use the command DoCmd.GoToControl "FieldName" but now it's not working and giving a message that the field name is not available. Alternatively, I used FieldName.SetFocus Any Idea Please

Thank you Alans, I'm really using Access 2K. This problem occur now only and not in Access 97. I had to check the reference for the missing library, and I found it. It's DAO 3.6 Again thank you

Thank you

Hi All... In the form code, I tried to declare a variable as follows: Public db As Database Public rst As Recordset etc.. When I execute my code, it gives me error message that : db As Database = Undefined Data Type I built previous dbs with such code without any problem Any help please

Thanks a lot. Will you explain me more how to use Arg please

Hi All... I have a form and wish to open it by 2 buttons. The first button is normal. The other button, I want to display a Delete Button on my form, so those who have the previlage of opening the second form can delete records, while the others who can open form by first button can enter data...

Found the answer Thank you

Found the answer docmd.runcommand accommand fittowindow Thanks everybody

Hi All... I have a button in my form to open a Preview Report. The problem I can't see all the report . How can I make it to open 50% size of original size.. Thanks

Thank you all for reply, I tried to go to Datasheet and Form/Report Template but no choices is there, it's only Normal Template, I can't create a new template and design according to my wish Any more help please

Hi All... When I open any new form in design view, the grids (the small squares) which divide the form horizontally and vertically, its default is usually 10. I want to make it 9 as default. I can't find it in the Option Thanks again.

Hi All... I have a report which don't fit the size of the page when opened. How can restore the size to 75 or 50% of its original size whenever it is opened.. Thanks a lot.

Hello again, When I open any new form, the grids is the small squares horizontally and vertically, The default of it is usually 10. I want to make it 9 as default. I can't find it in the Option Thanks again.

You are not The Doc Man but the Great Man Your idea helped me a lot. Very thankful to you. But I was trying to do it through Properties: Data : Validation Rule but my form was not loaded and therefore it was giving me error. Well, may I ask another question please... If I want to modify a...

Hi All, Whenever I create a new form, the grids of it is 10 X and Y. How can I make the default grid 9 ... Thanks a lot.

Hi All, My question is bit easy. In a form,I have a field named: Quantity, that is to be sold. I want to sell <= the quantity I have in my store. I put the Validation rule as follows: <=[FormNameContaining Quantity].[Form]![QuantityField], but it's giving me error that the form name is...

Hi All, My question is bit easy. In a form,I have a field named: Quantity, that is to be sold. I want to sell <= the quantity I have in my store. I put the Validation rule as follows: <=[FormNameContaining Quantity].[Form]![QuantityField], but it's giving me error that the form name is...