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.

I'm new with SQL 2005 Express and I'm stuck - again Windows XP Access 2003 Access Project (on my laptop) I am re-writing a fairly large application. I have a problem with stored procedures. More specifically, I cannot change data when I run a stored procedure (used as RecordSource). The form...

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

Perhaps I should have included more info. This is in fact code used to run a stored procedure that is used as a recordset for an access bound form. The code is called with this line LoadFormRecordset Me, Parent!AgencyID, "sp_Agt_Page_Producers" And here is the actual stored procedure that...

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.

Microsft Access 2003 SQL Server 2005 Express Windows XP Beginner with SQL Server 2005 Express I have a problem with a combo box. The problem is the cruser will not "jump down" the list while making an entry. The column is properly sorted. The cursor does not jump down until the full number is...

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

Access 2003 SQL 2005 Express Windows XP I have a problem with the number of records being displayed in a combo box. I am using the following stored prrocedure as the ROWSOURCE for my combo box. ============================================================ USE [MGA] GO /****** Object...

This should be simple but I cannot figure it out. I want to set a form text box to the result of an SQL 2005 Express user function. The function works and returns a value when I execute it from the QUERIES screen in my ADP. Access Data Project Access 2003 SQL 2005 Express For example...

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