Search results for query: *

Dear Friends, I'd like to ask questions about my form. I made a form that consist of the delivery docket entry. In the form, we key in Length, width and height of the delivery truck to calculate volume. Volume is driven by formula = Length * width * height, the formula is located in the query...

Thanks alot Ken, I will try your suggestion to copy the parents row first and then the child thank you, regards budi

Dear All, I have several table that linked together. I want to copy the set of the tables and of course i can not append one by one because they are linked. Does anyone know how to copy the certain record in some link tables ? Is it use cascade update related field ? Thanks in advance Budi

Thanks alot Bill, so I cannot use 2 facities together, compact on close with password. However if I ask the user compact manually, it is not practical ways. Do you know how to use 2 facilities together in office 2000 or xp. thankyou

Dear All, currently I run my access 2000 in Office/ windows XP, however the strange happen the password query ask twice. firstly, commonly when I open database, it requires password. however, when I close database, it requires password again. we can cancell it, but it bothering. Does anyone...

Thank you very much for your help, I am sorry reply to all of you very late. For Michael Red & Jamfool, I realize that the equipment can be returned after 00:00 and the problem the computer recoqnise 00:00 as 12:00 the next day. And I have give data type DATE/TIME with Format in form SHORT TIME...

Hi Guys, Does anyone know how to format a field so can receive time 24:00 (12:00 pm). Basically, I make a form that can receive time in and time out of heavy equipment. For example time in = 19:00 and time out 24:00, and I have another field to calculate the duration between them. So duration...

Hi Guys, I have tried with something like =if(cur="USD", format(##,###.00), format(##.###)) but doesn't work. Is my formula is wrong or because the number is under currency format ? thank you Budi

Hi Guys, I am still making program for Purchase Order. Do you know how to change the format number when it printed ? Let's me make clear, our country's currency is not use decimal point so only for example IDR 1,000,000 so in my P.O table I put the price in currency format. When we buy the...

Thanks Michael, Yes, normally when we do "save as" its convert to newest version but somehow it doesn't work properly for some formula (like they make wrong calculation). Anyway, thank you very much for your help. May be this is input also for the excel's user. I will check the...

Thanks Michael, Thank you for your reply Yes, it is simple to save as to newest version. However, this is not I mean. I also have tried save in another location, but sometimes the formula still not work properly. Lets me describe the situation, We have an excel's file for annual budget and we...

Hi Guys, I have one file that have used since several years ago (it may start built by excel's version 97 and have been updated several times until vesion 2000). And this file is have so many formula's and sheets on it. This file was used with so many people since several years ago. My...

Does anyone knows how to make query for find records which are the last record. Let's me make an example : I have database for transaction : Transc _no Equipment_no Repair_date finish_rep 1 1000001 01/02/02 01/05/02 2 1000001...

Does anyone know how to compacting a back end database without change the autonumber field to zero. Normally when we compacting a database, it also change the number in autonumber field to zero. thank you in advance Budi

Brendan, Thank you for your post.your procedure is work perfectly Budi

Hi Guys, I am still have problem with sending report via Email such as sending Purchase Orders which are it's specific to each supplier. What I have got from this forum are : 1. sending report by email to some recipients by putting all the recipients into the "send to" field. 2...

Dave, If you don't mind, would you please send me the database because I need a sample for send invoices with email. Thank you in advance My email address : budijanto@indo.net.id

Hi Stephen, I am waiting for your sample DB. Please!! Thank you in advance regards Budi

Hi Pdtit, I think what you need to send the PO# to the criteria of the query of your report (I assume the PO# is your key field in your report. What I have done was : 1. make a global variable in module. 2. Send the value from the form to the global variable. It can be done with put it the code...

Hi Pdtit, Thank you for your reply. I don't think your post is same as with my problem. In your procedure was send 1 PO for 1 recipient with press 1 button. What I need as Smeadows said : send several PO to it's recipient destination with press 1 button. So, I need to send some different report...