I have an MS Access 2002 Application in which i am trying to use web service. As given in the microsoft site, i installed the "Web Reference Toolkit" and also included the "Microsoft SOAP Type Library" in my project references.
Now the problem is: when i search for a webservice which is created in DOT NET, the toolkit finds it properly and displays all the methods in it. But when i try to search for a web service...
RajaKannan
Last Activity: May 25 '07, 11:23 AM
Joined: Oct 11 '06
Location:
-
Using WebServices from an MS Access Application
-
Thanks a lot. It worked when i tied up the date fields in the sub report with the parent report.... -
Do you mean that i will have to make my subreport get all possible values from a table and then while including it in the parent report, filter the records of the subreport? Can you please explain on how would i accomplish this filtering?
Thanks
Raja...Leave a comment:
-
Subreports in MS Access
Hi
I have a parent report which displays records based on the start date & end date given by the user. I want to include a sub report or a sub form in the report. The values in the sub report should be based on the start date and the end date given by the user.
Can you please tell me on how would i pass values from parent report to sub report?
In the sub report i will a stored proc which accepts these... -
Thanks a lot dude. Works out exactly as required. Thanks for the quick response.Leave a comment:
-
Stop unloading the form
Hi All,
I have a form in which i have few mandatory fields. Wheneve the user tries to save, i check for these fields and alert them, if thet are empty. I have a CLOSE button in my form and whenever the user clicks the CLOSE button, i ask the user whether he wants to save before closing the form.
On the Form_Unload event, i check whether there are any new changes and if yes, i pompt the user for a save. But if they have... -
Yes, Finally after lots of searches, i asked the user to rebuild his PC. Thanks !!!Leave a comment:
-
Close all open forms in VBA Window
Hi All,
I have a Access ADP application in which i have around 250 forms. When i select View Code from my access window using ALT + F11, i see the VBA window with all the 250 forms open. And it really opens slowly, as my forms are bulky. Everytime i need to close all the 250 VBA files and then select the file in which i need to work.
Is there any shortcut key or a way to close all the forms with a single click or a... -
Thats a very good question. Actually its about the PC. The same user when logging in from a different PC does not face this issue.Leave a comment:
-
Nope, his account is properly setup and checked it up personally. Could it be because of some patched which gets installed frequently???Leave a comment:
-
And one more thing, the same application works for all the users correctly, only one user is facing this problem. I was terrified to hear this.Leave a comment:
-
I am very sorry not to mention that part of the code!!! But i have set the object already and this is how i do it.
The function returns the object correctly and i have confirmed that. Can you please tell me on what other probalities are there??Code:Set objOutlook = GetOutlook(MakeVisible:=false)
And thanks for your quick response.Leave a comment:
-
Object Variable or with block variable not set
I am getting this error when the code enters this part of the module.
The error mentioned in the title occurs when the bold portion of the code is executed.Code:MailboxResult = GetMailboxInfo("OutlookID") If MailboxResult <> "Error" Then [B]Set MyRecipient = objOutlook.Session.GetRecipientFromID(MailboxResult)[/B] Else GoTo Code_Exit End If
... -
Sub Form in a Report
I have a report in which i am trying to include a sub form. The Sub form is already there and it is used in another form also.
The subform's RecordSource points to a SQL Server stored procedure,
Now, when the report is opened, i have a value which i need to set in the place of 1855. But when i tried to refer to the subform like this:Code:exec sproc_MOR_Tickets 1855
...Code:Reports![rptMORTradeCaptureReview]![SubFormMORTickets].Form![TradeRef].DefaultValue
-
Printing a wide form in 2 pages
I have a form which is very wide, approximately fits into 2 monitors. While printing this form, i get 3 pages as output. I want to squeeze them into two pages.I have even set the margins to a minimal value. And i have tried both portait and landscape. Initially when i tried with landscape, output was in 8 pages. Then i converted them to portrait, it reduced to 3. I still want it to be in 2 pages. Can anybody help?
Code Snippet
...
No activity results to display
Leave a comment: