Search results for query: *

What is the preferred method to maximize a form - On Click Event? Currently, when the end user enters their username and password, the form is very small and should be maximized. The line "DoCmd.RunCommand acCmdAppMaximize" doesn't appear to work. Displayed below is the code. Private Sub...

Having a syntax error , missing operator in query expression, for the following code. When debugging, the lines after "CurrentDb.Execute "Update tblVar..." is highlighted. Any insight as to what I am missing would be greatly appreciated. Function UpdateAccess() CurrentDb.Execute "DELETE *...

Have code below that I am trying to modify so that a error message will result if the same username and password is used by more than one person upon login. So far, I have not been able to get this to work. Any suggestions? Private Sub cmdLogin_Click() '************************ login...

The query that I will use to "auto assign" accounts to the staff (via Windows Scheduler) is below UPDATE tblVar INNER JOIN tblAssignments ON tblVar.Contract=tblAssignments.Contract SET tblVar.AssignedTo = tblAssignments.Employee_ID WHERE tblVar.DateRecordCreated=Date() And...

Assistance needed, Have several text box controls for data entry on my form; Amount Submit, Date Submit, Amount Received, Date Received, and Followup Date. If Amount Submit is populated, then Date Submit should not be empty and Followup Date should not be empty. If Amount Received is...

Hopefully, this is not a nonsensical question, Upon entering the database, the contents of the listbox on the page within the multi-tabbed form is not displayed. After clicking on one of the option buttons (that I use to sort the contents of the listbox), the contents now appear. Any...

Have the following module that I had planned to not allow the end-user to delete data within the controls on my multi-tabbed form, frmTabbed. The employees are only able to access the "Review Accounts" page of the multi-tabbed form (TabCt10.Pages.Item(2)) and two other pages. There are about...

Have module that contains action query (append query that appends records from oracle 8.1.7 to a local Access table). Can one use a scheduler to automatically enable the action queries within a module to run every morning at 9:00 p.m.? What I have read thus far is that ADO is the preferred...

Trying to determine the most efficient method to import data from Oracle 8.1.7 database and append to a local Microsoft Access (Access 2000) table on a daily basis. Have the sql script below; SELECT DISTINCT AL1.ACCOUNT_ID as AcctOrig, AL1.ACCOUNT_ID as AcctCurrent, AL7.ENCOUNTER_NO as...

Trying to determine the most efficient method to import data from Oracle 8.1.7 database and append to a local Microsoft Access (Access 2000) table on a daily basis. Have the sql script below; SELECT DISTINCT AL1.ACCOUNT_ID as AcctOrig, AL1.ACCOUNT_ID as AcctCurrent, AL7.ENCOUNTER_NO as...

Have a multi-tabbed form. The tabs are titled as follows Administrator Review Accounts Pending Upon the administrator logging in and accessing several controls on the "administrator" tab then going to the "Review Accounts" tab, all of the tabs mysteriously disappears! Any idea as to the cause...

Upon connecting to the internet with my laptop (XP Pro Oper System), the connection to the internet is lost and the computer shuts down after about 2 minutes. I have erased the hard drive and reinstalled most of the software. Also, installed McAfee firewall/Virus software. Loaded...

Hopefully, someone can provide some help on this problem Have the following 5 action queries that need to be performed daily via a scheduler at 9:00 a.m.; Append inpatient records from Oracle to Access via temp tbl Append outpatient records from Oracle to Access via temp tbl Update...

Currently I have the following cross tab query; TRANSFORM Count(qryEmpAccountStatus.AcctNo) AS CountOfAcctNo SELECT L_Employees.Username AS AssignedTo, Count(qryEmpAccountStatus.AcctNo) AS NumAcctsAssigned FROM L_Employees INNER JOIN qryEmpAccountStatus ON...

Hopefully, someone can provide insight on this problem. I have a Excel Spreadsheet with approximately 50,000 records that have "old" (previously used 2 years ago) reason codes in a column titled "Reason Code." This spreadsheet was a document that was created several years ago and since then...

Have a Access Db that approximately 8 employees use. I only allow the employees to view his/her accounts based on their username as displayed in the "AssignedTo" field. For example, the control source for the textboxes on the main form is a query similar to the following; SELECT...

Have the following crosstab query sql script; TRANSFORM Count(qryEmpAccountStatus.AcctNo) AS CountOfAcctNo SELECT Employees.Username, Count(qryEmpAccountStatus.AcctNo) AS NumAcctsAssigned FROM Employees INNER JOIN qryEmpAccountStatus ON Employees.Employee_ID = qryEmpAccountStatus.AssignedTo...

Have two tables; Employees and Accounts. The fields within the Employees table are Employee_ID, Username, Password, Access_Level. The fields within the Accounts table are AcctOrig, AcctCurrent, AcctNo, AssignedTo, and Username. Is it possible to use an update query to populate the "Username"...

Problem: Employer ID number is displayed in AssignedTo field within form and also in main Access table. What is the quickest method to modify the database so that the Access database forms display Username in the AssignedTo field instead of the Employee ID number? Also, anytime I create a...

Having some difficulty with assigning accounts to employees using a combo box on a form. Currently, have a listbox, lstUnassigned, on a form with a combo box with various usernames. I just added a search feature with requery using a textbox. In other words, upon typing account number "124"...