Search results

Hi Dbl I tried to import it too, but when I selected the corrupted database to import, it does not recognize the database and nothing happens. I need atleast retrieve data's from just 3 tables. Please help me, if do you know any good utility to repair database. Thanks Prao

Hi All Suddenly my database got corrupter. I am not able to open the database. The Access is getting open, but it does not show login form of my application. When I open the database, in the startup there is logon form. It will open and I use the F11 button to bring the database. I tried to...

Hi Sohaila Thanks for the reply. Regarding crosstab, I have not used the crosstab queries. Regarding the build the report thru wizard. No the wizard did not arranged the column in vertical order. First I created a query with union, the first part of union will be "Contract" total for the...

Hi All I need some help in displaying the data in column. I have a table, which as a column "Position Type", the data stored in this column is "Contract" or "Perm". The data is stored in rows. Example : Log # Sales Rep Position Type ------ ------------...

Hi Carolyn Thanks for the reply. But what you suggested me is round about method, which my company people wont like it. They want to send the email from the application, by just clicking a button. Thanks prao

Hi All This question may already been posted by someone, but I tried to search for right answer, but I never got one. So please help me. I have a form with one record, I need to email the data's in the form in a formatted way. Formatted means, for example All the column names on the left...

Hi all There is any way to access the Outlook contact database from MS Access. I need to send a email to a group of person, I will create the group in the Outlook Contact Database and use it. Is it possible and how can I achieve this. Thanks

Hi All I have text box and command button. When user hits the command button, it opens the dialog box, the user now select a word document file. Once the user selects the document file, I paste the same in the text box. Now I was the text box to be hyperlinked, so that when user clicks on the...

Hi All I have DLL to encrypt and decrypt the password. I registered the DLL in registry using regsvr32 EBServer.DLL Then in my program I declared a variable of type Object. Then created the instance of the EBServer object and stored in the vairable. Dim oPwd as Object Set oPwd =...

Hi Hay Thank you very much for the reply. It is working fine.

Hi Hay Thanks for the reply. I have a question for you. Where do I need to use these lines of script from your program. Private Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Thanks

Hi All How to get NT Userid and Password inside Access. Thanks

Hi All How to disable a menu item in a Custom menu bar. Thanks

Hi Rich Thanks for the reply. Yes, as you said, it is One-to-One relationship. Can u tell me how to do this. I created a Continous form, inside that I attached the subform, which is the Free form. But when I run the form, I only see the Continous form and not the subform. Moreover, the...

Hi all Guys, you heard about ONE-TO-MANY form, I need to create a MANY-TO-ONE form. I need to have a tabular form (I mean Continous Form) on the top and Free form at the bottom. As the user scrolls the Tabular form (I mean Continous Form), the data in Free form must change. This I want to be in...

I have a text box and below that I have a list box. I have populated the list box with data from contact table (last and first name) When user type some letter in the text box, I need to highlight the Contact name starting with that letter in the list box. This is something similar to the...

Can somebody tell me, is it possible to use the Windows Address Book (which we use in Outlook,Word etc.,) in MS Access. In one of my application, there is a email facility. I want to give access to the email address in Windows address book. Thanks

I am not able to understand what you say. Can you email me the form, if you dont have any problem. By the by, where are you from ? I have given my email address in one of the reply.

What do you mean by total column. Do you calculate "Total" for any column or what ? I cannot understand your question. Can you be more precise and tell me what happens to your form. Whether it is not displaying the data or getting an error ?

Ok, I got it. It is very simple. Just build the query dynamically and set the query to the record source and do a requery. Ex : We will take the customer form. When you select a customer name from the combo box, the form will show the details for that customer. //Write this code in the On...