Search results

Hi All... I'm appending a data to a table containing primary key for the no. How can I delete the previous no. and update the new one.. Thanks in advance

Thank you

Hi All... Will anybody tell me how to put a chart in my form please. Thanks a lot

Hi GP IIf Function if to filter your data into a new field. If you have a condition and your data should be accordingly, you can use IIf function. e.g. a field with some figures . In a new field If the first field contains 1 put a specific value let us 2 otherwise, put 3 so you put the code as...

Right..In a tabular form. The first field is No. I want to return the number of records in the Field: No to an unbound field. So, if the records is 1 record only for the given item, it should give me 1. If more than 1, it should give me 0. I tried DLookUp function as follows in the control...

Hi, yes every thing is going well to some extent. My point is If the employee is having more than one record, then the 300 days should not be counted for the second record. If only one record, it should stick to the rule. I mean, when the employee complete 300 days he can be eligible for holiday...

Hi All... I'm trying to build an expression in the form using DLookUp Function. I have a tabular form for the staff of the company where according to their contract period and contract date, I can calculate their holiday's entitled. If the employee is on duty for more than 300 days, then he is...

Hi All.. I'm started a dbs for a hotel. I stuck in the point where if the telephone call is done internationaly, I want my dbs to pick the telephone number so I can continue rest of calculation like time used and do the rest. Does anybody know how to link the normal telephone with the dbs to...

Hi All.. I'm started a dbs for a hotel. I stuck in the point where if the telephone call is done internationaly, I want my dbs to pick the telephone no so I can continue rest of calculation like time used and do the rest. Does anybody know how to link the normal telephone with the dbs to pick...

jwindon, I'll try the code. Thanks a lot.

True Travis. Thank you

Great deed. It works great. Thanks a lot.

Hi Surjer, Thanks for your reply. Well, I tried to put the code On Click of the button Private Sub Sketch__BMP__Click() DoCmd.RunCommand acCmdInsertObject End Sub It's giving me an error, InsertObject in not available now. I don't know why Any more suggestions please. Thanks

Hi jwindon Thanks to your reply. Well, sorry I'm not familiar with writing the code in modules. I tried to create a module named: OpenFirst. I wrote the code as follows: dim stDoc As String dim stdoc1 as string stdoc = "ContactDetails" stdoc1 = "MainForm" Docmd. OpenForm stdoc docmd.close...

Hi, Thanks for reply. Right it is true. It'll disappear from the list after uncheck it. But in case of importing, easily all the tables and queries can be imported to a new dbs. If it is MDE, then forms,reports macros and modules can't be imported but not the tables and queries. Any more...

Hi All... In my main form, I created a OLE field type to place the photo of my employees. When I double click the Ole, nothing will happen. I have to right click and go to insert into then a list of: Open with will open to me so I can choose Photo Editor or any other ... My point is to put a...

Hi Randonblink, I have the same problem in hiding the bar, will you send me any sample dbs as well. Very thankful to you. haytham11@hotmail.com

Hi All... In my database, I have a full security, so nobody can access tables and queries in design mode. I disabled the shift key as well. When I submit it to my customers, he created a new dbs and imported the tables and queries from my dbs. Is there any way to prevent importing tables by code...

Hi All, my question is when I open a form th' a command button from a switchboard, I want to write a code to close the main form, so by closing the form, the first one will not appear. Any help please... Thanks in advance

Hi All ..It's my second time to post this question. Hope someone can help me. I have a question about AddMenu in Macro (Menu Bar) . I can create it easily by macro. But it's not much secure so it is prefered to use the code instead of it. May anybody tell me how can I do so Thanks in advance.