Search results for query: *

I am having major issues with the synchronizing of a listbox with a subform on one of the pages on a multi-tabbed form. Is anyone able to offer insight as to the steps in linking listboxes to subforms on a multi-tabbed form? The error message that I receive when I try to enter something into...

Currently using the following code to sort a listbox on a Access form; Dim strSQL as String strSQL = "SELECT Company, [First Name], [Last Name] FROM YourTable" Select Case Me.[YourOptionGroup].Value Case 1 strSQL = strSQL & " ORDER BY Company" Case 2 strSQL = strSQL & "...

Having major issues with trying to setup a subform on a page within a multi-tabbed form on a Microsoft Access 2000 database that will only display the accounts assigned to the particular employee. Currently using a global variable. Considering switching to using the Windows login name...

I have a list box with check boxes on a page within a multi-tabbed form. What I would like to do is offer the ability to sort and subsort on the fields that are displayed in the list box. How do I accomplish this?

Currently have a form with multiple tabs that are visible depending on the specific user. When the user logs in, he/she is directed to the "Account Review" tab that only shows the accounts that have been assigned to them. Now, I have placed a listbox on the "Account Review" tab within the form...

Assistance needed to solve problem. Every day I perform an update query and then two append queries from an Oracle 8.1.7 database to a local Access table. Is it possible to store the number of records updated and appended to a local Access table (Titled "Update_Append Log") on a daily basis...

I have spent over 9 months developing a Microsoft Access database and now the new Manager wants me to share the code with a fellow co-worker. Can a employee copyright a Microsoft Access database or any other intellectual property? Is it possible to copyright within a few days? Thanks in...

Task: Have a list of 900 unique account numbers that should appear in one of the 200 Microsoft Excel workbooks that are located on several network drives. Initially, I sorted the 900 account numbers and was opening up each workbook and searching for the account number! However, this is not...

One of my tabs on a multi-tabbed form is titled "Reports." What I would like to do is for the end-user to see all of the Reports within the database populate the ListBox and then upon clicking on the command button to the right, the specific Report is previewed. Upon clicking on the other...

I have a multi-tabbed form and the last tab is for the end-user to logout of the database by clicking on the tab. What modifications do I need to make so the following code will work? Private Sub Page8_Click() On Error GoTo Err_cmdExit_Click DoCmd.Quit Exit_Page8_Click: Exit Sub...

Hopefully, someone can assist in this, Upon deleting several fields on my main table, I am prompted with a error dialog that requests I enter information for all of the fields that were just deleted. What am I doing incorrect? Should I delete the links to the other tables before I delete the...

Hopefully, someone can help with this problem. I have a multi-tabbed form that is used by Employees and Manager. The Manager assigns accounts for the 6 employees to review. Each employee should only be able to see the accounts that are assigned to him/her. Currently, upon entering one's...

I am interested in displaying all accounts that had the first payor payment greater than 50 days after the discharge date. How should the following sql script be tweaked to correctly display the desired results? (Note, payor payments are captured in the account payment detail table only under...

A challenge! Using Access 2003 database with links to an Oracle 8.1.7 database. Have a form with a set of 30 textboxes - 6 rows with 5 textboxes per row. The label for the 5 textboxes are - "AccountNo", "Charges", "Payments", "DateCreated" and "InMainTable?" Instead of the end-user entering...

Context I need to append ,on a daily basis, to the local Microsoft Access table all accounts that had a payment interface the Oracle table titled “ACCOUNT_PAYMENT_DETAIL” 1 day before the present day and update, on a daily basis, several fields on a subset of the records in the local Access...

Need some insight, Ideally, one should not store calculated values in an Access table. However, at the request of Management, I have no choice! Therefore,based on extensive reading, it appears that the most efficient method is as follows: Append process Step 1: Create Passthru query Step...

Currently, have 2 tables as depicted below. Ideally, I would like to "automatically" assign accounts for review by employee staff. Upon automatically assigning encounters for review, the date assigned field is populated with today's date and the status field is populated with "open."...

Creating UDF for the first time. I am interested in creating an User Defined Function within an Excel worksheet that uses ADO to pull SQL results from an Oracle database into a cell. For example, I have account numbers in column A of a worksheet and would like to enter the following function...

Using SQL.REQUEST function within Microsoft Excel (2000) to extract data from an Oracle 8.1.7 database. Format of SQL.REQUEST function is = SQL.REQUEST("DNS=FCC; UID = jt_jacxw; PWD = 2ABDcv;,,,"Select * from Account_Review") Upon opening the Excel workbook, I am prompted 4 times with the...

Currently, have a Access table, that is updated daily, with fields such as: Contract---AccountNo----OriginalValue----TodaysValue X22--------ABC4---------$1000.00---------$2000.00 X22--------ABC5---------$2500.00---------$2600.00 X22--------ABC6---------$1500.00---------$1600.00...