I have a Stored procedure, which produces a fine Crosstab result when Doubleclicking on the procedure, and supplying the required parameters.
However, when running from a button it runs, and then closes down without showing the result
Set conn = CurrentProject.Connection
conn.Execute...
Hi
Just had a similar problem
Even with an Identity column, you still need to set the Access Index key as well for that column
Then it should work
Regards
Hans
I have a Stored procedure, which produces a fine Crosstab result when Doubleclicking on the procedure, and supplying the required parameters.
However, when running from a button it runs, and then closes down without showing the result
Set conn = CurrentProject.Connection
conn.Execute...
From within Access, Choose File | Get external Data | Link
Then choose File type: Exchange and you should be looking at your Microsoft Outlook Folders
Select any one
Good Luck
I have an excellent function in Access 2000 that performs the above, Enabling buttons on EOF and BOF.
Trying to get the same result in SQL Server does not work too well.
Has anybody got stored procedures to perform the above
Any help appeciated on this steep learning curve
Regards
Hans
Hi
I am trying to produce a Stored Procedure to print a Timesheet based on multiple entries for any given Chap/Chapess in any given week
Here is my attempt so far
CREATE PROCEDURE qselTIMEDataOne (@timeTeamID int, @timeWeekEnding datetime)
SELECT timeTeamID int, timeWeekEnding datetime
FROM...
Hi
I am trying to get over the Docmd.ApplyFilter problem in my adp database, backended to SQL2000.
The following code does not filter my form
any ideas welcome
Private sub cmdLeft_Click()
Me.ServerFilter = ""
Me.ServerFilter = "teamEmpStatus = 'Left'"...
I am trying to create a stored procedure using two parameters to append a new record to an existing table
any tips gratefully received
Any takers?
Cheers
Hans
Hi
I have successfully linked my Access application to a specific Email folder in Outlook.
Now I need to move the email to a diffrent folder once the content has been processed.
Any idea anyone
Regards
Hans
I have a tabbed form, that clients want to be able to send to the printer, tab by tab. So far no problem.
The problem is that I can not control how Access prints the form
Any ideas wellcome
Thanks
Hans
I have a need for automatically check for emails in outlook, then import Subject and Body text into Access
Does anyone have a good solution
Thanks
Hans
I am trying to insert a record in ODBC Linked Table through Code from Access 2000 front end using ADO.
No relationships exist and I have full rights on the table.
Each time I succeed in creating the record, but on editing the record, I get a write conflict.
I have tried uing an append query...
Hi
I have the solution to your problem (curtesy of Myron, JSS Software Solutions)
Please email me at wrangh.railtrack@ems.rail.co.uk
and i will send you the required code and the dll to go with it
Regards
Hans
Hi Chrissie1
Because we are not sure, we will be allowed to keep our SQL Server and are trying to make our code capable of returning to the Access environment if necessary, without a code rewrite.
Cheers
Hans
I am making my application ready for backending to SQL Server using ODBC.
How do I do 'Set rs = ..." without using db.OpenRecordset.
I need to loop through a table picking specific records.
Regards
Hans
I have all my Access Forms set to Cycle through Current Record.
Some users have mice with scroll buttons, and this overwrites the Cycle Statement above.
How can I stop that?
Hans
Fixed it. I had to open a report and print to PDF Writer, to get to the 'Preview File' Tickbox. Once that was unticked, things worked a treat
Cheers
You have made my week
Hans
There is aknown bug in Access 2000 regarding the SendObject
The following code solves that
Dim objOutLook As Outlook.Application
Dim objNameSpace As Outlook.NameSpace
Dim objMailItem As Outlook.MailItem
Dim strSendTo As String
Dim strSubject As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.