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

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

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

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

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

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

Hi Guys, Does anyone know how to make a procedure for sending email to a list of recipient with different report's contain. For example I will send some purchase orders to some suppliers with email. The previous post that I have known were discuss about sending the same report to a list of...

Hi Guys, I have 1 form with 2 subforms, the main form link with first subform with 1 keyfield say BATCH_ID (ONE TO MANY RELATIONSHIP). The second subform have link with the first subform with 1 key field say DETAIL_ID ( i HAVE ONE TO MANY RELATIONSHIP IN FIRST SUBFORM AND SECOND SUBFORM). My...

Hi Guys, I make a software for container depo and warehouse, and I want to calculate how many container come in each day in the certain month. For example : container code date in (mm/dd/yy) xxxxxxxx1 12/01/01 xxxxxxxx2 12/02/01 xxxxxxxx3 12/02/01...

Hi Guys, Does anyone knows how to make “event Not In List” for the data which were come from a query. Lets make me clear this : 1. I have 1 combo box which it’s data comes from a query, combo box is fill the field contName in my batch entry form. 2. The query is comprise of 2 table : Container...

Hi All, Does anyone know why Access 2000 cannot accept the line "dim .... as database" which was ok in access 97 and how to change it so can run in Access 2000 (with ADO ?). thank's in advance

I realize this is a dumb question, but I am really want to know how to put a sum per page in Access 97. What I found when I move the =sum([fieldnumber]) in page footer in report, always appear "error". I can put it without error in report footer but it sum up until the end of report or...

Hi Guys, Does anyone know how to print a SUM OF THE PREVIOUS PAGE ? For example : Page 1 : Part description value Part A 10 Part B 20 Part C...

Hi Guys, Does anyone know how to print the previous page's sum. for example : In Page 1 : part desc value part A 10 part B 20 part C 30 total 60 In Page 2 : total from previous page =60...

Hi Guys, I have problem in making vertical lines draw along the detail section because it depend to where the record stop. I mean, the height of the lines depend on the amount of the records and I want make vertical lines in every field (make a column) where it begins along the part between...

Hi Guys, Does anyone know how to make a function for calculate a date with a function so the result is a same date but in the next month. Lets i make example : I have a field date 27 february 2001 and I want make a function that can make a result in another field as 27 March 2001. Of course, I...

Hi All, in Excel 97, we can use goal seek formula which is very usefull for calculate a value from a loop. Does anyone know the formula in ACCESS that similar with this function? Thanks in advance Budi