Recent content by darcy

hi, i have an urgent problem. A form that records sales needs to auto increment every time it is opened to a unique value. Currently the query works but the form craps it self and doesnt assigna new value. does any one have any back end vb or front end advice

F_addrecord has a certian item_code which i want to pass to F_colours , to assign colours and sizes to it. Can anyone help me figure out how to just click on the link to F_Colours and have the item_code that it passes to. thanks

got it, thanks

im tryng to find the code to open a .hlp file from a form. and im not figuring it out today, - bad programming day... and tips...

hi, i cant figure out the code to display only one of each record. Each record has many colours and sizes so the database has the same item_code. For a query to add new colours, im after the small command to only display each record once, and not all instances of it. Hope this makes sense...

hi, i have a system that allows multiple items to a perchase. - the query works fine and now its time for the form to do it all pretty like. Can anyone advise me on: how to increment the purchase id for the form when opened to make each purchase new - does the code go on the button, or the...

I guess it would be in sql mode for the query. Click on the drop down arrow next to View and choose sql view

ive picked northwinds apart, but what im after is to (like when shopping and you get a receipt) that the user enters a product id and it displays the data (this part works) clicking the add to list button, the product id and cost is added to a subform and more can be added to. Clicking print...

hey, My database im creating is a shop system with a purchase having many products. I have no idea what the code is to add the items on the add button to the subform is. Each purchase id will have many product ids. recording the id (which is searched for and displayed - working) and the...