Search results

Well, I have been able to do it in excel now....please see the attached file. It took time to learn the different syntax in Excel. Regards Raghu

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

People are atheist when it suits them and are believers when it suits them. It is driven by guilt. I was vacillating for a long time before I became a complete non-believer!

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

Apologies for the delay. When the big “C” strikes everything becomes out of focus.

Hi Everyone, I have to split a set of dates depending on the dates in a background table. Basically we have a rate rise for an item every so often. Suppose I want to calculate the value between 01-Feb-15 and 21-Dec-15, it is quite simple if there is no rate change. But in my calculations there...

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

Thank you very much...

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 Sydawn, I live in Melbourne, and my email is raghu[dot]prabhu[at]gmail[dot]com Regards

Hi Sydawn, Have a look at this....

Hi Sydawn, It is possible. I will do it and send it to you tomorrow. Raghu

What do you mean?? Please sketch on a paper, scan it and upload it.

Hi Sydawn, Here it is. You can type over the records in tblClassification. Hope it is what you are looking for. Basically I copied tblLevel and renamed it tblClassification and typed Classification1 to Classification4 Then I changed the query to include Classification field. Then I input...

Hi sydawn, welcome to the forum. Please upload a copy of your database with minimum data or test data and I will modify it for you. Raghu

Thanks a lot to everyone who has commented and answered. Basically these are certain transactions. The object of this exercise is I have to create a string to programmatically delete a huge number of transactions in our pay system. There are 6,000 employees (pid) and 300,000 transactions to...

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

spikepl Thank you very much. Private Sub chkAddToTaxZone_AfterUpdate() Me.NoOfDays = (-1) * NoOfDays Me.FNTotal = (-1) * FNTotal Docmd.save End Sub This code is doing what I want it to do... Is doing

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, What is the syntex for setting various properties such as default value, Caption etc Public Sub AddDate2AllTbls() Dim tdf As TableDef Dim fld As DAO.Field Dim strTableName As String For Each tdf In CurrentDb.TableDefs 'scan each tbl strTableName = tdf.Name If...