Search results

Hi i allready have the syntax in the criteria for the query it is: [ Forms]![Orders]![Order id] But the porblem is when i click print i get the critera box oming up asking for the order number how can i get it to just print the current order and order details without actually typeing the...

Attached is the attachment sorry if its a bit too small woudnt allow me to add anything that is bigger

Hi all, ok i have a bit of a problem here and this is it. I have set up a quesry based on 2 forms 1 orders and 2 order details. i have the set a criteria on the report to print a order number i have then set up a report based on the query. Then i have created a command button on my form up...

Hi, Yes i have done that i have set the parameter in my query as : [ Forms]![Orders]![Order id] and i have set the report up also and added a button to the form with the follwing code (i have tried a few different methods: Private Sub Command106_Click() Form_Orders.ODS.SetFocus Dim...

Hi all, I am wandering if someone can give me some help on this, Baiscally i have a form with order and order details tabels i have a query i can run and brings up the order and all the order details based on the order id. The problem is that i have created the report and i have addeda button...

Hi Firstly thanks rabbie for the reply i will have to try this out later but what does the chr(13) and chr(10) stand for? thanks

Hi there, I am creating a customer search form where you enter the customers details ie name, tel address postcode area notes, etc, and then i have a button which takes cerain parts of the customers details and places them on another form which is the orders form. the problem is that for the...

Hi Garry Thanks for the reply yes that does work but it seems to miss a few out for some reason. just having a go at it now

Hi all I have a subform which loads the items from a table the form is non editable just for viewing the items, the problem is how can i A. limit the subform to only show the first say 10 items in the subform B, to have a command button on the form where the the subform is on (command button...

Sorry Ken didnt see your post there, yes thats looks pretty neat and kool would it be too much trouble if i could have an example programme of that possibly?? many thanks again guys

Hi All Thanks ZigZag at first i didnt have this in mind but it shore can do the thing i was wanting to do i think it might eb a bit limited to take it further but its what i was looking for so thanks a million and thanks for the example your the man most deffintaly thanks guys

Hi all Thanks Guys for your views and thanks ZigZig for the working example what you have shown that could possibly work for but as am a newbie dont really know what you ahve done on the subforms so was wandering how would i get that into the 3rd subform, also with this idea there could be quite...

Thanks doc man for the reply WOw ou ahve gone into pretty much quite a bit of detail there, havent been able to check it out properly yet as am still at work, but you are talking abour creating everything dyamnic even loading the buttons up and moving them, i dont want to do that all the...

Yep thats what is the big porblem, i know it cant be that hard i have seen it done in a similar way and also i have done this in visual basic but command buttons there are just all called say cmddepartment and they are all stored in an array. Lets just see and hope someone knows how to solve...

Thanks guys for the reply firstly the test command button doesnt work at the moment only the first 2 command buttons actuallu run and call the loadprod procedure and also i am a newbie to programming so bare with me please. Secondly thanks ken for the reply and i know what you are saying about...

Hi All I have been having problems with some code inside this programme for a while now and i have hit a blank wall, i have tried all sorts even posted on here with the porblem but no look so am having to try again with the database this time. The problem is that i am trying to load the items...

Hi Thanks Boblarson the code you provided kept on looping thtough and only showing the last depname but witha few changes and a for loop its done the trick now so thanks alot, now the only thing is to click on the department button and load the products in that particular item, if anyone has...

Come on people surely somebody must know to get the captions of command buttons on a form loaded from a table??

Hi Thanks Pbaldy for your reply and yes that would be a good idea but unfortunatly not in my case is i am using a touch screen pc and its basically used for retail and the buttons will be departments and the other buttons will be the items so the user just clicks the neccessary department...

Hi There I am wandering if anyone has a solution to this problem i has basically have 2 tables 1 called departments, with the fields: Dep No, Dep Name, then i have another table called Items, with the fields: Item No. Item Name, Item Price, Department. What i want to do is create say 10...