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...

Hi, How can I use F6 instead of clicking on the command buttom?? Thanks Ali 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

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...

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...

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...

Hi, I'm very confuse because of thinking about where I have to put this question? I'm searching for the way to see data from weighing machine and I found many sites and many vba codes which all of them explain how to read serial port, but I don't know how I can see the weight data in the...

Hi, I found the sample which will resize the forms as per resolution, That's So nice but I did as It' writen in but when I copy & Pase that code to new module of my database, I can't call it!!! In Instruction of this sample is written: Enter the following line of code:" ResizeForm...

Hi, I have a bound form which I have a command button in it. with this button user can open the new form with data based on first form. now, if the first form when the record is new... I have the DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 before open form...

Hi, I have seen a strange calculation in access!!! I have a Invoice form and there is subform which have 3 bound textbox. in subform record souce, I have a calculation like this: Subtotal: [text1]*[text2] The problem is: every thing works ok, just some times in depend of value of...

Hi, I have a continoius form which has a bottun on each record to delete record. and when the user clicking on it, the popup window will apear that are you sure? yes or No. Now, my problem is I put a query in onafterdelconfirm of forms to run that query when the record actuallu deleted...

Hi, I want to make limitation in my report chart to view just the value more than 5%, because below 5% in 3D circullar chart the value name will be unreadable!!. thanks for any help A. Fekri

Hi, I have headache problem in my tables data: I need just 2 decimal on all numbers in the fields just when needed. for example If the number has no any decimal should not show any decimal place in filed data and when I entered the "25.0245689" just show "25.02" I used fixed or round...

Hi, to change and update the data of a field in a table with a data which stored in a field in another table, I usually useing updtae query. but this time always the error message make me crazt: "operation must use an updatable query" the query SQl in like below: UPDATE [Inventory items]...

Hi, I'm really confuse to select data type for my fields. I want to have decimal number in my fields only if the number edited have decimal otherwise the fields should show the number without any decimal. I used single, but I don't know why in a query when the number is like: "19.4" or...

Hi, I try to use this faq702-4282 but the only problem is: when I run this form as an admin group user, all the users namse in combo box created in one row which separated by ",". So like this I can not select one of them to change their password!!! Can any body help me how to correct...

Hi, In my database, I need calculator any time. So, I want to use the key like F12, when press it the calculator which is exe file run on my database!! how can I do? Thanks Ali