Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ascheper

    programming for a touch screen

    Thank you for your reply Scott, much appreciated!
  2. ascheper

    programming for a touch screen

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

    Choppy scrolling

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

    Choppy scrolling

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

    Save stored procedure output

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

    I have a stored procedure that work

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

    Save stored procedure output

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

    I have a stored procedure that work

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

    Save stored procedure output

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

    Save stored procedure output

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

    Access Multi-Table SQL Statement Help

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

    Save stored procedure output

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

    I have the following code in the Af

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

    I have the following code in the Af

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

    Running sum problem

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

    Append Data

    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?
  17. ascheper

    Append data to a text 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?
  18. ascheper

    Export date with DTS to text 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...
  19. ascheper

    Export date with DTS to text file

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

    Stored Procedure code

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

Part and Inventory Search

Back
Top