Search results

Hi All I have a main orders form with a order items subform in it. The order items has fields for the product, the QTY ordered and the selling price, linked to the parent form by order number. I have an unbound pop up form which comes up if the selling price is double clicked for price...

Thanks for all those examples, I will go through each one, digest them and understand them. I need to rethink the format as I have now realised I can't use the unbound text box in the products subform due to it putting any typed value in one box into every box. So that idea is out the window

This is what I am trying to achieve, I know I could use a simple cart subform with a combobox on each cart record but thought this would look better. I will take on board your comments, they make sense and will have a rethink,

Hi Thanks everyone, progress is being made. using the ? in the immediate box, I can see the SQL line and checked each variable and each shows the correct value, so far so good. This has brought up another problem I didnt see coming due to my lack of experience. In the unbound subform I list...

Hi I have taken the " off the value section and that now passes. I now have the Current DB.Execute strAppSQL, dbFailOnError line showing red and a syntax error I also tried your debug.print line in the immediate area and it didnt show anything after pressing enter. I must be doing something...

Hi I will give that a go. Learning something new every day. Thanks I am getting this line as red; strAppSQL = "INSERT INTO SalesTransactionItemsTB ([ItemPurchased],[ItemQTYpurchased],[RetailitemPrice]) Values ("ProdOrdered & QTYordered& ProdRetail")" the error is expected end of statement...

Hi I should clarify The main form has two subforms, one being a child of the main form. ie. main form is transactions and subform is items in that transaction. The form with no parent/child relation is just a list of all products with just a filter box to shorten the list and quicken...

Hi Taking advice from here, I am trying to move away from Macro's and use more VBA, although it is a learning curve. I have a main form with two subforms, one showing current products, and another like a shopping cart. The idea is the user picks the product, enters in a text box the quantity...

Ah, I will look into that Thanks

Hi Yes, I do usually do use the master/child fields on my subform but on this form and subform there is no linked data. I will have another subform which stores the items purchased on the transaction which will relate to the individual transaction and will be linked using master/child. This...

That works thanks

Hi All I have an unbound form with a subform in it in continuous form layout. The subform lists a query with all products along with the product category. In the subform header area I have a combi box which lists each category, the idea being the user can select a category and the continous...

Hi All that makes sense, I will adjust the code now thanks

Hi All I am writing vba to check if a record exists before I open a form and am going back to basics, doing one step at a time before adding the next step. I have a query called [SearchPOQ] which lists all the purchase order numbers already entered. I have a primary key field called...

Hi Thanks for the feedback. I will change the Dcount to not use the strings. I did that as a first to copy the syntax so I ensured I followed it. Where are you getting the ProdOrderID will be null. I was intending that the where command should be where ProdOrderID is equally to the POSelected...

Hi I decided to split the functions and design two forms and not use the one for both functions, I have worked out the where function which works for both forms and have moved onto the next refinement where i want to check that the 'purchase order' requested does exist in the form/query and if...

Thanks all, definitely food for thought. i originally thought the less forms the better, thats why I tried to use the same form for both searches, then thought the path of least resistance was two forms. I didnt think about a search box on the main form, thats also an idea, I have used VBA...

Thanks, I thought that might be the case. I think I may have been lazy in trying to use the Main Purchase order form for too many things rather than more forrms. I now think I can easily do another form where the main form is the purchase order and then use the where command to find it. That...

Hi Sorry 1. click logon, there is no logon programmed yet 2.click the purchases button 3. click the view purchase order button which will bring up the modal form I am talking about 4. the bottom text box is where you enter a number. 1 is the only record entered thanks

Hi Yes, maybe I am going about it the wrong way. The main form will open a specific supplier, the subform holds 'many' purchase orders. I want it to bring up the customer and then show the subform for that chosen purchase order number. Maybe I need it to query the purchase orders, find the...