Search results

Hi All, Attached is a small database. Please look at the spread sheet first. There are 3 worksheets. First one is the raw data. In the second spread sheet I adjusted it into a format to pull the data into Access table. The third spreadsheet is the output required. How do I do this as...

Attached is a full working version. Thanks to those of you who responded.

Thanks....Working fine. Cheers Raghu

the Update Command Button Enabled when Values have been entered into all Fields AND the Enable Update Check Box is Selected Same scenario for the Insert Command Button/Enable Insert Check Box

This suggestion is not working. The buttons will be enabled only if all the text boxes are filled. Cheers Raghu

In the form of the attached database both the “Update” button and the “Insert” button will be enabled when all the fields are input. I want to enable only one button at a time. When the check box “Enable Update” is checked I want the “Update” button to be enabled and when the check box...

I found the sample database and dlls on Steven Lebans site and modified it and it is working well. I have attached it below. Hope it will be of help to you. Cheers Raghu Prabhu Melbourne, Oz

Hi All, Sorted it out. Here is the solution. Please name the first query “QryInitialQuery” ****************code for QryInitialQuery************* SELECT IIf([commDate]<[tblH42.StartDate] And [EndDate]<[cseDate],[commDate],[tblH42.StartDate]) AS sdate, tblH42.FullName, tblH42.StartDate...

Hi, Please look at the database. The following is the query I tried and is not giving the out put I require. SELECT tblH42.FullName, tblH42.StartDate, tblH42.EndDate, [EndDate]-[StartDate]+1 AS Days, tblAllDedRate.dailyRate, [Days]*[dailyRate] AS PayOwing FROM tblAllDedRate, tblH42 WHERE...

Hi All, Attached is a small database. There are two tables. How do I design a query to show the output as in the xls spread sheet. If you can not open the spreadsheet please open the txt file. The actual database contains 160000 lines in "tblH42" The database in 2003 format. Thank you...

Thank HiTechCoach for this. Will implement and get back to you. Regards Raghu

Thanks a lot for this suggestion. Raghu

Hi all, I want to know how to send the data from a query to an excel spread sheet in the same directory as the database is located in. The excel spreadsheet should be named Sent01May10_01.xls if it is the first one to be sent on 01May10. It should be named Sent01May10_02.xls if it is the...

I have a number field ServiceNo. It has 7 digits maximum. First I want to change it to a text field then I want to add an alphabet to this field on the left hand side. For example if the number is 8014342 I want to add A to the right and make it A8014342. I want to change the field to a text...

Hi All, My name is Raghu Prabhu. Live in Melbourne. I am 49 and mechanical engineer by training. Dabbling in access programming for the last few years. Cheers Raghu Prabhu

Sorry for not getting back earlier. If you have not sorted it yet, please post your sample and I will do it for you. Cheers Raghu Prabhu

Hi I have used the following code to increment... *****************qryForArmy***************** SELECT tblTheLot.numTXNNo FROM tblTheLot WHERE (((tblTheLot.numYear)=CInt(Format(Date(),"yyyy"))) AND ((tblTheLot.numService)=1) AND ((tblTheLot.numSource)=[Forms]![frmMainMenu]![List0])) ORDER BY...

Thanks to VbaInet for your suggestion. I have been playing around with a number of dependent combos. I may have arrived at my own unique solution. Attached is "CasCombos25Mar10.zip" to illustrate my solution. This is working fine for 4 dependent combos. I have tested with 10 dependent...

Hi All, Having problems with cascading combos. This is the first set of cascading combs. (two combo boxes in this set) On Form1 how do I make the combo show what the user has been allowed to input? The first combo box list shows the users and the second combo box list shows the...

Hi All, Attached is a small database, which generates dynamic reports. I have been able to do it with help from other users of this site. Looked at their samples and was able to come with this. Please leave my details but, feel free to use this code. Raghu Prabhu Melbourne