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...

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...

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...

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

I would like to write a number of Records to PDF format, ie one record at a time into individual files. Creating the new filenames is not a problem, but how do I write the new filename to the Print Dialog and close it through code. Whenever I print to PDF, it insists on manual intervention. PS...

I have a spreadsheet containing macros, that processes a lot of Subtotals, averages etc. I export a query into this speadsheet, then open the spreadsheet and click my Macro button. This works fine when done from Access 97 When exporting from Access2000, I get Access Violation, Sharing...

I have an Excel Spreadsheet where macros manipulates exported Data from Access This works fine when using Access97 When using Access 2000, The export also works, but I get an "Unhandled Exception Error in Excel.EXE Oxc000005 Access Violation, Followed by a message stating that Memory could...

This code worked perfectly well in Access 97, but now the event does not fire. Any ideas anyone - help gratefully received strSendTo = "name@ems.rail.co.xx" DoCmd.SendObject acSendNoObject, , , strSendTo, _ , , "CD Accepted", "Hi Renae, CD for " &...