Search results for query: *

Can anyone help me real quick, please? Thanks in advance. I have a table that contains all update history of every single check. Within each check, I need to pull out the TimeStamp of a update batch (regardless of stage) WHEN the ProblemID #1 is not included in that batch anymore. In the...

Can anyone please help me out with this: LoanInfo table: LoanNum 1A 2A 3A 4A 5A 6A 7A 8A 9A 10A I want to get the maximum number (which is 10) in the table so I can increase 1 unit for the next LoanNum (11A). I have a sql statement works in sql database but when I use CInt, it doesn't work...

Hi everyone, Please help. I need to update my NewMgrID in tblManager table. What I need to do is group the records in tblManager by State, then within each State, sort them by HiredDate in ascending order. I have to update the NewMgrID starting with the record that has a smallest HiredDate...

Hi all, Please help me how to count records when opening a recordset. I want to know if CA is in my State field already of tblManager table. Function ForCount() Dim rs As New ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "Select * From tblManager&quot...

Hello, I am look for help. I have 2 tables: tblState and tblManager. The tblState table has 2 varchar fields as followed: State LocationID ===== ========== AR 012 CA 015 The tblManager table has the following fields: ManagerID LName FName State HiredDate 1...

Happy New Year to Everyone!!! I have a problem that needs your help please. I need to count how many business days between a StartDate and EndDate. This is the example that I have been trying to figure it out. I need to count number of business days between 9/18/2002 and 12/31/2002...

Hi Everyone, I have a problem that need your help please. I have a main form links with sub form by LicenseID. I have a table called tblLicenses. This table has LicenseID as the primary key and AgentID as the secondary key. One Agent can have licenses in many states and one state has many...

Hi Everyone, Please help me to figure this out as soon as possible. I have a sub form with its record source is table named "tblLoanProgram" that works fine, but I need to put sort by "ExpirationDate". For this reason, I change the record set of the sub form...

My Balance table has an BalanceID field as Autonumber type. This Autonumber field is not a primary key. It's just an identifier for a composite key (as primary key) that includes 3 fields. These fields are: 1. Social security number 2. Type 3. SubType I cannot use the social security...

Hi everyone, Can you please help me to set a default for a date field. If I enter a new record any day of the week, I need the default date of THURSDAy for that week. Thanks in advance!

Hi Steve and Everyone, How is everyone doing? I still need some help with a problem. I am having a problem with the tenth decimal numbers such as 0.1 and 0.10, 0.2 and 0.20, ... For this reason, I can get up to number 9.9, then the next number is back to 2 again. When I reach to 9.9, my...

Hi Everyone, Can anyone please help me out because I am in a rush to catch up with my deadline. Thanks. I have a form that is adding new Managers. Each manager has a unique ID number and I can only use the ID number from 1 to 999. In order to keep historical record, after I use up to 999...

Hi Everyone, Can anyone please help me out because I am in a rush to catch up with my deadline. Thanks. I have a form that is adding new Managers. Each manager has a unique ID number and I can only use the ID number from 1 to 999. In order to keep historical record, after I use up to 999...

Hi Everyone, Please help me out. I need to have 2 combo boxes to search on the same form. One searches by Manager and one searches by Agents. I use "ApplyFilter" for both combo boxes, but when I switch from one combo box to another, these combo boxes don't filter out the record...

Hi everyone, Can anyone help me to use the activex Calendar. Thanks. I want to use a "Date and Time picker" Calendar on a sub form. However, if I don't check the "CheckBox" property to YES, I receive the following message: "Can't set Value to NULL when CheckBox...

Hi all, Can anyone please help me to sum up all the year-to-date amounts of a spicific employee. I would like to show the YTD amount on my form and report. Thanks in advance for your help.

Hi all, Can anyone please help me to sum up all the year-to-date amounts of a spicific employee. I would like to show the YTD amount on my form and report. Thanks in advance for your help.

Hi all, Thank you so much for helping me out with my previous questions. Now I have another Problem that needs to be resolved Asap. I have 3 tables: Employee, Payroll, and 401K. Employee is the main table and EmployeeID is in both Payroll and 401K tables. Because the user doesn't always...

Hi everyone, I need help please. I have a Salary table that stores each employee's weekly payment amount. I need to always show the total of all payment amounts of each employee on the form when I search or add a new record for that employee. For example of a current record on the form...

Hi everyone, Please let me know how to create an array of check boxes on an Access form. Thanks a lot for your help in advance!