Search results for query: *

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

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

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

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

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

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

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

Based on some recent reading, it is my understanding that an ACCESS ADP uses LINKED tables. That is, the upsizer creates some kind of internal ODBC connection to the SQL database. Furthermore, because it is ODBC linked, the ADP actually runs the Access Jet engine and not the SQL engine. That...

I just ran my first Access MDB to ADP Frontend is on my development laptop. MDBE 2005 Express is on my laptop and SQL 2005 workgroup was just installed on our server. Application for first convert is very simple Access 2003 application having just 4 tables, 2 forms and 2 queries...

Windows XP SP2 Office Pro SP2 I have a problem with TransferSpreadsheet. My code worked fine (for several months) until I added a new column to my export. The newly added column is "ERPEndDate" If I stop the code run and look at the query, the ERPEndDate is there. However, it does not get...

I have (intentionally) hidden some queries and tables. My problem is that I cannot remember how to UNHIDE them. As I recall, there is some startup key sequence like shift and something that causes the hidden object to display. Anybody know the answer? Thanks, Brad

This question is about filtering (and sorting) a query on a field that is derived from a function. Here's the issue: * I have a table of insurance applications (tblApps) * Some tblApps records are new biz and some are renewals * New Biz apps have no previous policy that is expiring * Notice...

Anybody know how to force exclusive access to an Access Database Application? I occationall need eclusive acces to our production system to import code updates etc. My problem is I cannoy get everybody to off the system long enough to complete the imports. So, I would like to have a routine...

This is about a problem with WORD docs being created from ACCESS and saved to the server. Windows XP SP2 on all workstations Server has Windows 2003 We have an Access application that creates Word documents, saves them on the server and writes hyperlinks to associate these Word docs with an...

Windows XP SP 2 Access 2000 and 2003 We have experienced problems with some of our older Access database applications. The issues relate to multi-users and sequential number assignment to records. These applications use Access .mdb (linked) tables. Auto number key is (intentionally) not used...

Access Pro 2003 on XP SP 2 I have a form with a tab control having 5 tabs. I can't get the tab page click event to be recognized. This simple code doe absolutely nothing. Private Sub pagBinding_Click() MsgBox "Single click" End Sub Any ideas? Thanks, Brad South Burlington, VT

As you will soon see, I am new to SQL. I have a SQL 7 installation on my laptop used for development (with Access 200 front-ends). My SQL installation failed and I could no longer connect to (local) SQL 7. I think the (local) server was OK because I could work on my web page application...

I have a problem with Access quoting application that creates Word documents. An insurance underwriter makes a few selections on a rating screen and then clicks a button to generate a Word document. Word opens, selects a template, interrogates the database, populates some bookmarks, creates a...

How can I set up (VBA) a method for assigning unique invoice numbers in a multi-user application? I currently get the highest number from the table and add one. However, the number is occationally duplicated when more than one user hits the right timing. Any suggestions? Thanks Brad South...