Search results

Hi, i have a table which contains various information about stock. i have a field which contains a reorder level, which is basically the minimum number of each item to be held in stock at any time. (basically if the stock level drops below this number, the amount below it is, needs...

Hi, i have to list boxes, List2 and List4 which are updated from a query. does anyone know how to get it so that when i click calculate, the value in List2 is taken from the value in List4, giving me a quantity. the value has to go into a text box any ideas welcomed jared james

hi, apologies for that, had to update some details to make it clearer for you. my mistake. jjames

thanks mate

report, nice one mate

hi, nevermind sorted it now, you were right, just added hidden on the end. thanks jjames

may have forgot to mention, i dont want the form to open. and i dont believe that code prints it, just opens it.

i dont want the report to open

hi, i have button on a form which prints a report. can anyone post the code required to get the report to print. report name : qry_invoice i just cant suss it out. my current code is: DoCmd.OpenReport "qry_invoice", acViewPreview, , , acHidden DoCmd.RunCommand acCmdPrint but that just...

hi, i have button on a form which prints a report. can anyone post the code required to get the report to print. report name : qry_invoice i just cant suss it out. my current code is: DoCmd.OpenReport "qry_invoice", acViewPreview, , , acHidden DoCmd.RunCommand acCmdPrint but that just...

hi, when i press print on a form, a report is printed based on the info in the form. is there any way to get the report to print when the print button is pressed, without have the print dialogue box appear? jjames

i put that second code into my form and everything scr*wed up to put it mildly. all buttons and codes stopped working and i had to get rid of it to get it back!!! jjames

Hi, sorry to bother you all again . . . i have a form which you enter invoice details into. it has a subform which is in datasheet view which you can select multiple items in. (you choose an item, it gives you the price, you enter a quantity.). So nice and simple. I have a save command on the...

heres the screen shot:

hi, it doesnt work? jjames

Hi, sorry to bother you all again . . . i have a form which you enter invoice details into. it has a subform which is in datasheet view which you can select multiple items in. (you choose an item, it gives you the price, you enter a quantity.). So nice and simple. I have a save command on the...

nice one mate jared james

Sorted it now, i got the code from some other forums. its really simple: [Text Box Name].Value = [Text Box Name].Value & "The value you want" For example: [Amount Paid].Value = [Amount Paid].Value & "1" Jared James

Hi, i have a table which has car registrations in. I need it so that when the user enters data it goes straight to upper case for storage OR I need it to be viewed in uppercase when a query is run. either one will do. Please dont mention input masks because i cant use them in this instance...

hi, im trying to make a simple till system with the standard key board layout of a till: 7 8 9 4 5 6 1 2 3 0 00 How do you get the numbers to display like they would on a till or calculator. As in when i press each button, it is displayed in a row. So if i pressed 10.00 it would display as...