Search results

Thanks for you prompt reply. Can you help me in this.

Thanks I am little confused... the text file created at the end is saved in a folder Named "ADVICE" say in the name TFILE1.TXT, TFILE2.TXT etc. now I want to encrypt the file the samples are attached. Encription has been done using Hekapad.

Hi Everyone, hope all of you are safe. In my data base final output is converted into a text file Now I want to encrypt the data. Is there any way to do it. Thanks

IP numeric TYPE as Text AAO_Name as Text COMORG is a combobox to fetch data for Type COMIR is a combobox to fetch data from AAO_Name

Thanks I have changed TYPE filed into ORG but still getting Run Time error 2471

Me.TOTIP.Value = Nz(DSum("IP", "qmaster", "TYPE= " & [COMORG] And "AA0_NAME = " & [COMIR])) WHAT IS WRONG IN THE CODE I AM GETTING TYPE MISMATCH QUERRY NAME=QMASTER IP NUMERIC FILED TYPE AND AAO_NAME TEXT FILED COMORG AND COIR ARE TWO COMBOBOX IN THE SAME FORM

PLEASE CORRECT THE CODES. I I AM GETTING ERROR TYPOE MISMATCH X = Nz(DSum("Cost", "RoomOccupations", "MRO_DONE = FALSE" And "[DepartureDate]" < Date))

THANKS , I GOT THE SOLUTION, ERROR WAS IN APPEND QRY PLEASE CORRECT THE CODES. I I AM GETTING ERROR TYPOE MISMATCH X = Nz(DSum("Cost", "RoomOccupations", "MRO_DONE = FALSE" And "[DepartureDate]" < Date))

INSERT INTO FINAL_ACCOUNTS ( collection, Expense, TE_NO, TE_DT ) SELECT [CASH ACCOUNTS].collection, [CASH ACCOUNTS].Expense, [CASH ACCOUNTS].TE_NO, [CASH ACCOUNTS].TE_DT FROM [CASH ACCOUNTS];

Hi Everyone I have a table which will be appended from another table through an Append Quarry. When ever the destination table is empty, it is not working. After adding a record in the destination table ..it works fine. Is there any way to append a Table having no record at the beginning.

Hi Everyone If anyone has a Room Reservation System, please post me Thanks

Thanks to all my dear sir Only one problem i am facing when ever I switch between dates it displays Gross Value after several attempt it generates the actual values between the dates... Nothing is being shown different in Immediate window

Thank you sir,,, but it display the Gross Total and Zero in other cases between dates are not taken randomly..

yes they are on the from but the problem lies with the code starting from And [settelment_date] between "#" & [Text0] & "#" and "#" & [Combo4] & "#") if I removed this code the total sum is appearing on the screen but it is not taking between dates with the codes mentiond

Thanks for the support . but still not resolve ... Code error is flashing with Red I used in the Click event (1) me.TCMP.value=DSum("Chamt", "total cmp", "finyear = " & [COMFY] & " and section = " & [TXTUC] " And [settelment_date] between "#" & [Text0] & "#" and "#" & [Combo4] & "#") (2)...

where to correct

Dear Sirs, I have a Table "total Cmp" in which the fields are finyear,section. Chamt and settlement_date I want to get the value of total amount in the filed Chamt by cliking a command button and display the result in a textbox TCMP I am using the code below but I am getting error type mismatch...

Hi ! All I am having a small registration form where user need to enter name, User ID password and an account number of the Department. I have crated a combo box fetching all the Account No from the data table member, and it was running well.. and it gives error message when already register ID...

Thanks