Search results for query: *

Thank you for your reply Scott, much appreciated!

Will command buttons work with a touch screen, or will they only work with mouse clicks?

Thank you for the reply. I've searched the MS knowledge base, google, and a number of other tech sites with no luck. The only really odd thing is that our systems with Office 200 still on them work fine and the 2002 systems do not. I even installed the 2 service packs on my system with no luck...

I hope someone can help. We have recently "upgraded" to Office 2002. We use Access as a front end to a SQL Server 2000 database. Under access 2000, whether in a view or a table itself, the records scrolled smoothly. Now, under Access 2002, in a table or view, once data is either...

Thank you cmmrfrds, I'll try that tonight...

Sorry for the delay in reading this, but thank you for the tip, I'm going to give it a try...

Sorry for the delay in answering, yes, the SP is a SQL Server SP. I tried the recordset approach and it doesn't work. VBA doesn't seem to be able to work like that. Still trying to play around with it, but not getting anywhere.

I have a stored procedure that works fine on it's own, now I need to call it in the before update event of a control on my form and save the output in a database field. I've searched MS knowlege and this site for an answer first, but cannot seem to find it. I may not be asking the correct...

I think I may need to create a recordset with the SP and then assign the value to my field...

the stored proceedure simply gets the users login name and I want to store that in a field in the customer table that the the form being used is attached to. I want to place a call to the sp in the before update event of a control, presumably using docmd.openstoredprocedure, and save the...

Try this for the SQL Query SELECT Courses.Course, Caddies.Caddy FROM Courses INNER JOIN Caddies ON Courses.ID = Caddies.IDNUM

Hello, I have a stored procedure that works fine on it's own, now I need to call it in the before update event of a control on my form and save the output in a database field. I've searched MS knowlege and this site for an answer first, but cannot seem to find it. I may not be asking the...

Thank you, I'll give that a try tomorrow and see if it works.

I have the following code in the After_Update event of a field on my customer form. Each time the code runs I get a run-time error 2757, There was a problem accessing a property or method of the OLE object. When I go to debug, the Dlookup rows are the source of the errors. I use Dlookup on the...

I have a formula field (@TotalFaxBack) in a report that calculates commission as: if {@FaxBack} = &quot;Yes&quot; and {#OrderTotal} < 2000 then 25 else if {@FaxBack} = &quot;Yes&quot; and {#OrderTotal} > 2000 then 50 else 0 This is displayed for each order in the report. I need to create a...

Through DTS I created a package to export some data to a text file. Is there a way to append the data to the file instead of overwriting the file?

Through DTS I created a package to export some data to a text file. Is there a way to append the data to the file instead of overwriting the file?

Sorry, bad typing skills...it should read DATA not Date. I am trying to append a couple of different views to a text file. I can get one at a time to work, but they overwrite the previous data. I would like to append the latest data to the end of the file and can't find a way to do it, assuming...

Hello, I am exporting some date through DTS ot a text file and can't get the date to append to the file, is there a way to do that? Am I missing something in the configuration of the package? Any help would be greatly appreciated, thank you. Drew

Thank you for the info SQLSister, I've begun reading Advanced Transact-SQL for SQL Server 2000 by Itzik Ben-Gan and Dr. Tom Moreau and may have misunderstood them when saying that &quot;it&quot; was written in 'C'. I was thinking the actual SP's, but they may have meant the program...