Search results for query: *

Actually, all. I have a main form that has a tab object. Each tab has a form on it. Some of the tab forms are linked to the main form and some are unbound. Some are single form and others are continuous forms. Some allow data editing and others are unbound data display only. Most are not...

Thanks for the response. This stored proceedure does have a unique filed - StaffID. I checked the table and that field is definded as the primary key. I tried adding dbo. to each but it makes no difference.

...but I cannot change anything. It can't get much simpler than this sp. ---------------------------------------------------------- USE [MGA] GO /****** Object: StoredProcedure [dbo].[sp_cbo_Staff] Script Date: 12/04/2007 16:32:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --...

Hmmmm...... No wonder I neeed help. I have reading Tek-Tips for several years and never noticed the FAQ. I have added this "How To". Thanks

This is not a question - I am posting this as a simple "FYI" This happen to me today and has happened before but I had forgotten how to fix it. So, I made a note and saved for the next time it happens to me. Here it is. Access 2003 with tables in a separate database and linked to another...

PS genomon Thanks again for the help. I was going to click a formum STAR but can't find where to do that. No wonder I need help! Brad

The suggested code returns an error "cannot rin when closed...." in both the CLOSE and UNLOAD event. However, adding an on error line makes it work fiine in the UNLOAD event. On Error GoTo ErrorHandler If Not rs Is Nothing Then rs.Close Set rs = Nothing End If Exit...

I added that code to the UNLOAD event and get an error. Perhaps I still need to offer more info. This form has a main form in the header section. The detail has a tab control with 6 or 7 tabs. Each tab has a subform on it that links to the header with a key "AppID" common to all forms...

...pstored procedure - if there is any such thing as closing a stored procedure (as mentioned in first part of this string of notes) USE [MGA] GO /****** Object: StoredProcedure [dbo].[sp_Agt_Page_Producers] Script Date: 11/06/2007 16:38:10 ******/ SET ANSI_NULLS ON GO SET...

I am new to ADP and wonder if stored procedures need to be closed like closing recordset in a "regualar" mdb application. That is, in a regular application, I always close my recordsets with the following two lines of VBA. rs.close set rs=nothing Below is some VBA code I am using to set a...

That works great!!! Thanks for the help

Thanks for the quick response Greg. Your suggestion works fine with this code. However, the form will not HIDE. Have I not set HIDE correctly? I right click on the form and set the attribute to "HIDDEN". It is hidden on the forms list but not when running...

I am trying to save a timestamp for when a user opens the database and when they close the database. I have been successful with capturing the open but not the close. The close works OK when the user exits using the appropriate close/quit button. However, they often "bail out" from the (many)...

No luck!! Actually I tried the NOCOUNT before. I think the Expand property should affect this but it doesn't seem to have any affect. I have been through each of the combo properties HELP and haven't found annything that changes this problem.

...& parEnt1 & ", " & parEnt2 '=========================================================== Here is my stored procedure in SQL Express: USE [MGA] GO /****** Object: StoredProcedure [dbo].[sp_SELECT_APP_ByAppID] Script Date: 08/31/2007 09:47:14 ******/ SET ANSI_NULLS ON GO SET...

Ooops! After hours of searching, I discovered a SECOND "number of records" setting under TOOLS > OPTIONS. One is for the database and one is for edits. Works OK after setting correctly! Brad

...the following stored prrocedure as the ROWSOURCE for my combo box. ============================================================ USE [MGA] GO /****** Object: StoredProcedure [dbo].[sp_SELECT_APP_ByAppID] Script Date: 08/23/2007 10:54:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER...

...If (@Claims)Is Null Begin set @Claims = 0 end If (@Affinity) Is Null Begin set @Affinity = 0 end set @dblBasePremium = ((@Rev * 0.00812) + 1650) If @dblBasePremium < 2250 Begin set @dblBasePremium = 2250 end set @dblTotalDiscAndSurcharges = @FeeOnly +...

Awesome! That works great. Thanks

I am having a problem setting the record source for a subform based on an event on the main form. Main form is "frmAppData" and it has a tab control with 12 tabs. 11 of the tabs have subforms. I have a button on each subform for setting the record source - this works OK. I want to eliminate...