Search results for query: *

Any thought on the need to setup frmTabbed (the main form), the subform (that contain the various controls) and the listbox on the query that will actually restrict the end-users. I will place the listbox directly on the page within the multi-tabbed form. Thoughts? Comments?

The code now "blanks" all of the rows!

Basically, I am trying to allow the end user to only see his/her accounts upon logging into the database. Maybe, I have not set this up properly. My setup is as follows; * Inserted subform on a page of the multi-tabbed form that is based on a query to allow the end-user to only see his/her...

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?

Oops! The title should read - Synch Listbox to Main Form and enable sort using Checkboxes

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

Remou, Good point about the field names. I will modify accordingly. The Access database is linked to the Oracle database. How would the original code that you posted change if I want to automatically capture the date/time that the query ran, and the number of records updated and/or appended?

Currently, the Update and Append Query are performed using Jet Sql. Additional Context follows, I am interested in initially setting the 3 queries to command buttons on a form that will be accessed by the manager. Command Button 1 is for the Update Query Command Button 2 is for the first...

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

Step 2 was done to put all of the controls that are on the main form onto the subform that is on the tab titled "Review Accounts." The main form appears when the administrator clicks on the command button titled "Assign Accounts." Therefore, I wanted all of the controls that are on the main...

firefytr, Any additional insight regarding the automation of hyperlinks? Thanks in advance.

Thanks for the insight. Approximately 85% of the development work on the Access database was performed at home during the weekends or after work using my laptop computer. As stated, the main point is documenting this which would be rather difficult at this point. Overall, it appears that...

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

Upon revisiting this issue, the following thoughts. I believe that the way I am creating the subform on the tab titled "Review Accounts" is the problem. Specifically, below are the steps that I took to setup the subform: Step 1 - Created subform on tab titled "Review Accounts" Step 2 - drag...

The code works perfectly on 15 to 25 accounts while searching within 10 to 20 Excel workbooks. Would it be relatively easy to modify the code to allow for the following: Only search the first 4 column of the 200 Excel files. (Is the code searching every column on the Exel files?) Include...

firefytr, Upon trying the 3rd iteration, A system error was generated and the code stopped running. I think what might have occurred is that one of the files within "C:\Reports" was not a standard file containing the accounts but an analysis performed by someone. The following questions...

firefytr, Additional issues; It appears that the second iteration of running the code resulted in Microsoft Excel being in a locked state. Then, I tried to use "CTRL-ALT-DELETE" and could not. Therefore, I had to shutdown the computer. Upon shutting down the computer, a dialog box appeared...