Search results

I have a work book with two worksheets. One is to input data “Sheet1” and other one to hold the details of the users “Sheet2”. It has two forms “Userform1” and ”Userform2” When the user opens the workbook, If the user is not in the “Sheet2” then Open Userform2, input the users details Save...

Hi everyone, In my team at work, we have 6 people and our team leader allocates work. He inputs the details in a worksheet named zMaster.xlsm with the following headings. Item Qty Price Total Invoice Team Mbr Date Alloc A1 22 $44.21 $972.62 AD14256 Raghu A2 10 $210.44 $2104.40 AD14257 Ravi...

I have two columns in the combo box in my form. How do I make the data from the second column populate the worksheet? It is possible in Access, but not in Excel? Please look at the attached file. Thanks Regards Raghu

Our new pay system at work went live in August 2017. This is the new pay calendar (called PayPeriods) Start Date End Date Pay period 10 Aug 17 23 Aug 17 PP0001 24 Aug 17 06 Sep 17 PP0002 07 Sep 17 20 Sep 17 PP0003 21 Sep 17 04 Oct 17 PP0004 05 Oct 17 18 Oct 17 PP0005 19 Oct 17 01 Nov 17 PP0006...

Hello Everyone, I am trying to use an Input Box to prompt member to input a 7 digit number starting with 6, for example, “6014342” to select the worksheet to print. I want to trap error if the number is not 7 digits long or does not start with a “6” or is a blank or an alphabet string. The...

Hi All, My work has banned Access. Now I have to convert to Excel just when I am about to retire. I am trying to select rows within a date range, with the value of "No" in the fourth column. I have highlighted the line of code, not working. Please, someone, tell me what I am doing wrong...

My work has banned MS Access databases. I am finding it hard to manipulate data as required in MS Excel. Attached is an excel workbook with 5 worksheets. The worksheet names are “PreviousFN”, “CurrentFN”,”Omissions”,” Additions” and “ChangedDetails” I receive a report every fortnight with...

I have attached two spreadsheets and a database. E29 and E31 are dependent on D6 and E27 and I have to update the table (M1:Q60) every year from the tax office. This is for financial 2016. I want to replicate this in the database. How do I lookup do it? Thanks a lot in advance.... E29...

Hi Everyone, I have to calculate something and the rate changes two or three times year. This year the dates of rate change are 12MAR15 AND 04NOV15. when I input the "ToDate", I want to split the record For example I want to calculate for the period 01FEB15 to 31DEC15, when I input...

Hi All, How do I requery the list box in the form after the combobox is updated? the name of the combo box is txtFilterClassName. Regards Raghu

Hi All I have a table in a database with 7 columns. The data is sorted by Date1 in descending order. For each pid I want to put the sequence numbers First record has two conditions If string 2 is null then start numbering from sequence1 If string 2 is not null then start numbering from...

I have a small database. In the form I have a check box called chkAddToTaxZone. I set the default value -1. Private Sub chkAddToTaxZone_AfterUpdate() If chkAddToTaxZone Then Me.NoOfDays = NoOfDays Me.FNTotal = FNTotal Else Me.NoOfDays = (-1) * NoOfDays...

Hi All, I inherited an old database. Not designed too well. Nearly 100 tables with different types of names. Some table names start with and "_", some with "tbl" and some just names. I want to add a new field called "TimeStamp", date/time, and default value Now() to all the tables. Any...

Hi Everyone... Attached is a small database with one table with two columns as shown below. Service Service No. 1 F327445 1 421547 1 8014432 2 O22771 2 L185244 2 O852424 3 O321322 3 R552552 3 O8471254 Basically I want to do the following If service is 1 remove the...

Sub DataToBeSent() On Error GoTo ErrorHandler Dim db As DAO.Database Dim rs As DAO.Recordset Dim sState As String Dim sClub As String Dim s As String Dim sSQL As String Dim dDate As String Dim i As Integer Dim activeDir As String Dim FileNum As Integer activeDir = CurrentProject.Path sSQL =...

Hi All, I have uploaded a small database. I keep track of payments for people who receive a language proficiency allowance. Usually the members receive this allowance for two years. Sometimes they receive it for one year. Lang Level DateQuaFrom DateQuaTo DatePd From...

Attached a small database to look at. When the database is opened, form “frmSingleDate” pops open. Click “Do Something”, I get a dialog box asking “Would you like to change the date before proceeding?” Click on “Yes”, form “frmSelectPayPeriod” opens. Click on “Find Pay Day” and a...

I have attached a small database. My organisation pays an allowance for knowing foreign languages. The payment is for two years. The employee has to qualify by passing an assessment. He or she is paid according to the level of competency. There are four levels lower, intermediate, higher and...

Hi All, I have a form with three list boxes. List1, lstPP1, lstPP2 When I double click an item in "List1" I want the item move to "lstPP1" . That I am able to do. For example item is "2012/21". With the same action how do I make the next item in "List1" ie "2012/22" to move to "lstPP2"? How...

Hi All, I am still using Access 2003. Some of the users of the database I creat are quite old. Have difficulty reading small fonts. I use "DoCmd.RunCommand acCmdZoomBox" on double click events of text and memo fields for a zoom box to pop up. My question is how I make the fonts bigger and...