Search results for query: *

Hi, I want to use any code in one of my form to type "000" instead of "0" when I press zero (0).. example: normally when I press 1 2 3 0 will type 1230 But I need when I press 1 2 3 0 to be typed 123000 is there any body to help...

Thanks, I think it's the one which I need. But unfortunately It was not clear for me how to create these macros. I made as per instruction 2 macros and made the first line, but in this instruction has 3 line on the bottom of each macro which I don't know how should I write on my macros...

Hi, How can I use F6 instead of clicking on the command buttom?? Thanks Ali Thanks & Good Luck Ali Fekri

Thanks so much it was so perfect. Thanks & Good Luck Ali Fekri

Hi to all, I have a calculation result on my form and I want to create a button command to make the result Round to 500 or 1000. for example: result Round 1350 1500 1780 2000 340 500 910 1000 any one can help me...

Hi, I need to disable usb and cd drive only on one of the users. but others users can access both usb and cd drive. the user is a member of domain Group. I would appreciated if any one advise me. Thanks Ali Thanks & Good Luck Ali Fekri

Hi, I made an input mask on one of my text box in form. and I need to open a specific form when the value in that text box isn't appropriate the input mask specified. Thanks for any advise. Ali Thanks & Good Luck Ali Fekri

Thanks I don't know why I couldn't open this link!!! this method is working well until user preview page by page. If user jump for example from page 1 to page 10: The total page of page 1 will add on page 10 and in the end of page 10 will show sumurise page 1 and page 10. and all the page...

Thanks But this site looks like down. I couldn't access to this site!!! Do you any other address of him? Thanks Ali Thanks & Good Luck Ali Fekri

I have 3 column in my report which in each group will continue to more than 50 pages. So, I have to make sumurise in end of page and also say in the first of page the last page sumurise. for example: A B C From Page 1 200 500 100 to ali...

Hi, in my report, I have a Unbound text box in report footer and I have a calculation in report detail section which I will keep one field value to unbound text box and will add in each record. I will use the page sum in last page to continue adding new values in next pages. every thing...

Thanks for your reply, So, You think the Level Security is more stronger than MDE?? I used it before but because of username & password question in first of program I stoped to use it. I have my own form with Local Language to ask their username and password. Can I use Level Security but...

Thanks for your reply but I'm not agree with you. because this way is more secure for the companies. if they want to kepp backup of their years data they can do and if the current year file damaged, last years are safe And also after 20 years accounting data they have not the large kb file...

Hi, I have an accounting Program which made by ACCESS 2003. one year Accounting Data will store in the separate mdb files which all tables are linked to the Accounting program. when they start new year program will made one copy from mdb file and named by for example 2008. Now, when...

Hi, In my Program database there is several link tables which linked to another database (storing Data) which protected by password. I don't want any user can read the data without runing Package. But recently I found that some users do the following way and can read the data without...

Thanks so much I used it and found should change some things on and finnaly it's ok now. I bring one of the record here for example: 0S20 03221 0S20 03221 0S20 03221 0S20 03221 0S20 03221 0S20 03221 0S20 03221 0S20 03221 0S2 I changed your method like this: " :chr(3)" x =...

Thanks for your reply But there is one problem which I couldn't use Mid and I forget to tell before: If you see the table in attched, the data which recieved any time are not same. and will start with different part of the value. So like this I couldn't use Mid to say start from which part...

Hi, Finally I found how to connect my database to the serial port which is Weighing Machine to get the Weight value. But the data which I received is attached in a table. I know the first 6 number after chr(3)in data which is received repeatly is exactly the weight. So, I need just make a...

Also I found this thread thread702-593810 which deulyd explained perfectly.. the only thing which I couldn't find is: he told in this thread, that I have to write his code in "OnComm" event which I couldn't find on Mscomm control!!!! it has no this name event!! UPdate event enter event...

thanks PHV as usual you are coming to help me.. Thanks one of them is : Private Sub cmdOpenPort_Click() PortName = VBA.Right(Me.cboPorts.Value, 1) x = Me.intBaudRate PortSetting = x & "," & Me.txtParity & "," _ & Me.intDataBits & "," & Me.intStopBits ' Open the serial port...