Search results

Great. got that one sorted thanks very much. having another problem now with the parameter clause in the following code PARAMETERS [CAN Number] Text ( 255 ); SELECT [Historical Casing Jobs].CUSTOMER, [Historical Casing Jobs].INVNUM, [Historical Casing Jobs].[CAN Number], [Historical Casing...

I have the following sql code which i have written to search our current and archived records by vehicle registration number. I get an error in the FROM clause, but as i don't really know sql (i poached the code from forums) im not sure why SELECT CUSTOMER, INVNUM, [CAN Number], DELIVERY...

Superb Thanks.

Hi, I have an append query which archives some data depending on the status of the record. I get the following error message: "Microsoft Access set 2 field(s) to null due to a type conversion failure, and it didn't add (0) records to the table due to key violations, (0) records due to lock...

No the FJ and CAN prefixes are not variable, although the number portion will, i would assume, vary in length based on the sheer number of jobs we handle

Yeah thats right they are both the same number, eg 12345, but they have the different CAN and FJ prefix, and a CAN number has the -1 -2 etc at the end how would be the best way to go about splitting them?

I have a database which helps us to manage part of our tyre fitting network, based in access 2007. When we attend to a vehicle, the job is given a job number e.g. FJ12345 (it always begins with FJ) We then help to manage the retreading or recycling of tyre casings. In the tyre casings...

My bad. It was just that when i ran the report it stuck every invoice in continuously, but when i print it does break the pages up so that is great. Thank you for your time! It is very much appreciated

I have reattached the file David thank you for your patience. I have put in the statements that we need on our real invoices, if you could show me how to place them in the invoice without messing up the "1 invoice per page" format we need i'd be very grateful Thank you

Thats great thank you. The only problem i am having is that when i edit the report in design view to add our payment terms (at the bottom of the onvoice) + bank details (below customer address) for payment, it stops putting each invoice on a seperate page and just runs them one after the other...

Many thanks for your reply David, database is at the following link (i kept getting a connection failure trying to upload through this site) http://rapidshare.com/files/292861995/Blank_Accounts_DB.mdb.html I have been reconfiguring the database so i could convert to access 2003 (it used to...

Thanks for your answer. I did think of reorganising the whole report set but unfortunately i doubt its possible as each invoice must have a letter head which draws data from another table to add in addresses etc. The code i have come up with (and please be kind as its my first time...) is as...

Hi, I am a complete newbie to VB so i hope i can explain my problem thoroughly. I currently have a database which allows us to create invoices for all our customers who owe us money. Each customer has a customer code, and at present to create an invoice i have to run a report, enter the code...

my bad was inputting it into the query not the report design thanks for your time

My bad i was entering the exp in query design not report design. Thanks very much for your help

Sorry it wouldnt attach, i've had to copy the report to a blank db file. if you open it in design view, and you should see the total due column. It is there that i would like to display the sum of all outstanding balances for a customer

I've put in your example, and it is just replicating the data at the minute. e.g. Purchase No Outstanding Bal Total Bal Purchase 1 £20 £20 Purchase 2 £15 £15 Purchase 3 £20 £20 But all i want from Total Bal is a single figure, the...

Hi, sorry i probably wasnt clear enough What i have created is an invoice, which is output to a report. The query that runs currently displays all the individual purchases made by a customer, and the amount of each purchase is displayed in the outstanding bal field. What i want to do is add...

Hi, I have a query which makes an invoice for us to send out to customers. I want to add a field which displays the total of their outstanding balance over several months. At present i have the following expression which doesn't work, but i think im on the right lines. Total...

Never mind. I have fixed the problem Thanks very much for your help.