Recent content by eyalco

I have an invoice form (access 2003) where vat is a part of payment. The problem is : when VAT changes, I want the new VAT to be placed in my form. I have a VAT table where I have [from date] - [to date] and the relevant VAT. I'm trying to use : DlookUp("[MyField]","MyTable","#07/02/2009#...

Thanks. I placed this there : "DMax("CheckNumberFieldHere", "tableNameHere")+1" and it's ok but when I go to the next row, the check number goes 0 but there's another row with the following needed number. The following desired number skips a line. Can you please figure this one out? Thanks.

I have a receipt form (access 2003) where I write checks received. My question is : how do I automate check numbers (it's a running number by oreder), same bank (all checks are from 1 bank : how do I make each line in the receipt writing the same bank automatically) etc'. Thanks.

I have an invoice database where customer pays for a service and receives invoices. How do I create a return invoice (sorry if I miss name it right) - where cus pays for the whole year, receives an invoice for the whole amount but business agreement ceases to exist, so funds are needed to be...

I have an invoice project which functions quite well. What I need to do is print only a copy of the invoice report (the 1st print order generates "original" + 2 copies. How do I select only a copy invoice please? Thanks

I have an invoice form with a sub-form (the invoice items, prices etc). everytime I enter the form, I need to undo anything written when I leave without saving (only when I press yes for saving should it be saved). How can I do this both in the form and the sub-form please? Thanks.

I have an invoice database. The invoice number is handled by dmax and is ok. I need to allow the user to to have the opportunity to start the invoice number from other number then 1, unless he approves starting from 1. This is a choice he gets only when he starts using the project. from then...

Thanks. It works. :)

I have an attendance form where I write the date' entry hours and dept. hours and get a summation of worker's hours per day, salary etc'. I recently updated from access 2000 to 2003 - I didn't have this kind of proclem in the past. The problem : I punch in 08/11/08 (without the /) - the 8th...

I'm having a problem with this age formula in the query : AGE: DateDiff("yyyy",[birth_date],Date()) & " " & " years" & " " & "and" & " " & DateDiff("m",[birth_date],Date()) Mod 12 & " " & "months" Need your help guys in 2 probs : 1. age calculated is not right. 2. need to compute what w'd be...

I need to store a "calculation" which involves values from child records - it is a receipt storing totals from the receipt details. The record is bound and I need it to update it's totals when each item in receipt is inserted. I guess I'm looking for a form event which will operate (the after...

Thanks Bob. Working.

I have a report (receipt) which i filter by customer_id but the receipt items, which are placed in a subreport, are not filtered so every time I want to print, I get the customer I want but the sub report shows all items from all customers. How do I filter the sub report as well? (the filter...

Thanks. Will that address the fact that I need the invoice and receipt to be linked together? How will I create the receipt number in the invoice ? Thanks.

Hi guys. I'm building a receipt/invoice database - I've started with the invoice first, then the receipt. I have invoice = parents and sons + receipt = parents and sons tables + a customer table. I want to issue 1 receipts with 12 checks (for each month of the year) and then, everytime a check...