Search results

Both solutions are very good. Each one could be used in different times due to some restriction or other. Thanks once again. Raghu

That was a very good solution. Thanks once again. Raghu

Thanks a lot Big John Booty Cheers Raghu

I have attached a small database. When I try to add a new record I am getting a warning “Field can not be updated” when date is entered in the eDate field. Secondly there is no code behind the “Add Record” button. On clicking this button I want to add a new record in the sub form, how do I do...

What am I doing wrong with this VBA expression? I have a form in datasheet view. The form is based on a query which show the records when the value is false. When I click to make the value is true, the form requires and does not show the record. That is working fine but it is not is not updating...

Tony, Thanks a lot for your response. I couldn't log on to the forum from work. Hence the delay. I have attached a small txt document. Please read it and tell me if it makes any sense. Best font size is 10 on screen rsolution of 1024x768 thanks in advance Raghu

Hi Guus2005, If you look at both the worksheets you can see that the dates are overlapping in the first sheet and they are continious in the second. I have drawn a pictorial graph to make it simpler. I am trying some things. Hope I will be able to sort things. Will keep you posted. Thanks...

Hi Guus2005 and other members of the Access family, I have attached a small excel spread sheet. Please look at it. It has two work sheets. "List of Overlapping Dates" and "Dates in Continuous Order" My database has a table with many fields of which two are "FromDate" and "ToDate". The...

Thanks a lot GUUS2005. It is not that simple. Please look at the attached database I attached here in ForComsuper.zip. I am working on queries to make the dates look like in the list I want. Once I do that I may be adle to do the rest slowly. If and when I solve it I will post it on the net...

Hi Guus2005, Please look at the tab in the spreadsheet "RawData2PullIntoAccess" and the attached database. The database has the same data as in the tab "RawData2PullIntoAccess". I don't know how to take it further after this. Any suggestions will be welcome. Thanks in advance...

Hi, If you look at the attached excel spreadsheet you may be able to get an idea of what I want to do. The first tab has "RawData". The second tab has the data arranged "RawData2PullIntoAccess". The third tab has the "OutputRequired". What I want to acheive is in the third tab...

I have a set of dates. These dates are not continuous. Any ideas for designing a query for the required output? I have a list of “From Date” to set of “To Dates” as listed below. The earliest From Date is 18-Feb-08 The last To Date is 11-Sep-08 Date From ----- Date To 18-Feb-08 -----...

Thanks. Will try that.

Hi All, I want to save a copy of the record in the main form. If some one changes the record in the main form, how do I save it? Generally if a female person gets married her title changes from "Miss" to "Mrs" and her surname changes too. So in this sample database I have tried to save the...

I did as per the instructions. It is not working. Attached is zip file. This contains a help.chm file, helpTest.mdb and a word doc which shows the warning I am getting when I run this. Please let me know what I am doing wrong. Cheers Raghu 13-June-2011 Update .... Came to know if you...

Hi All, Found the solution. All I did was to make MyForm an input parameter for the sub "Audit_Trail" making it "Audit_Trail(MyForm As Form)" Then in the code module of each form I changed the "Call Audit_Trail" to "Audit_Trail Me" What is happening is that when the Form_BeforeUpdate event...

Hi All, I found this brilliant sample database posted on this fourm. It is working fine as for as the main form is concerned. Does not do the updates in the subform. How do I do it? In this case if I make any changes in fEmployees it is working. If I make change in fEmpPartner, it is...

Thanks Working beautifully. Cheers

I have a form with a date field and a transaction number field. The transaction number is of the format 99678*06*10*01234. The first five digits (99678) are source code. The next two digits (06) are the register number. The next two digits (10) are the year the transaction was input. Finally...

Hi May be this will be of help. Cheers Raghu