Search results for query: *

Problem: when run in Citrix, Access goes out and opens shell of table, but doesn't return any data. Any help appeciated 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...

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'&quot...

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

Hi, can anyone help with Drivers for CD Rom: TORiSAN CDR_U112 Any pointers gratefully received 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...