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 bkrike 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: *

  • Users: cbirknh
  • Content: Threads
  • Order by date
  1. cbirknh

    Another truncate transaction log question

    Hi Everyone, I am running SQL Server which is backed up nightly using a veritas backup exec full database backup. One of my transaction logs has grown to 5GB and I was hoping to truncate it for now and also figure out a system for it to truncate itself in the future. I have tried dbcc shrinkfile...
  2. cbirknh

    Front-end updates with DOS batch file

    Hi Everyone, I am running an SQL Server 2000 backend with MSAccess projects (*.adp) front-ends and am struggling to find an automated way to send out revisions to the front ends. I have created a *.bat file which deletes the old version, inserts the new and opens the program. Unfortunately (as...
  3. cbirknh

    Bookmark, Recordset.move hiding records

    Hi, I have form listing all appointments on a specified date (or set of dates) and a "cmdOpen" button which opens the appointment details form and closes the appt list form. I would like to set it up so when the user reopens the appt list form, the focus is returned to the same spot on...
  4. cbirknh

    Connecting Access runtime app to SQL2000 in VBA

    Hi, I am trying to connect to SQL server 2000 using an application created as an access data project (*.adp) and deployed with office developer (Clients Access2002 runtime and WinNT/Server SQLServer 2000 and Win2000 server). The application initally opens the login form and runs code to see if a...
  5. cbirknh

    Records based on ADODB recordset not updatable

    Hi, I have a continuous form (developed within an Access Data Project .adp) which is based on an ADODB recordset (view code at bottom). I have had no difficulties viewing and editing forms populated with this method on my desktop computer, but when I installed the application on my laptop, I...
  6. cbirknh

    Set Subform's Recourdsource to Stored Procedure

    Hi, I am sorry if I am posting this on the wrong forum; if that is the case, please direct me to the appropriate one. I am trying to use a SQL Server 2000 stored procedure ("dbo.spPatientLTComplications") as the data source to a subform in an access .adp. I set the recordsource using...
  7. cbirknh

    If/then expression in stored procedure

    Hi, I am new to SQL server from MSAccess and am trying to rewrite some of my old queries. In MSAccess, I could use the Iif function for derived values like "Iif(A=B,1,0)", but I can't figure out the SQL server equivalent. Is there such a function? If so, what is the correct syntax...

Part and Inventory Search

Back
Top