Search results

how do you display the information? do you have customer details at the top and then stock details in a subform? would it be possible to attach part of your screen so i can see how you set it out. Also, where does the subtract stock calculation/function go, In the command button? What is the...

no, it wont let you put flash in a subform.

sounds like a good system.. mine is similar, however the stock is carpet and each piece of stock is pretty much unique. this therefore means that there are thousands of pieces of stock, all different, the only way to bring up the correct details would be by entering a stock number or searching...

no, stock will have already been logged as it come in i want to bring up an existing piece of stock to link it to a customer as they buy it. i have attached what my current form looks like. but i realised that a sub form of the table of stock would only add new stock, not append/change...

hi, i have three tables - Customers, Sales, Stock i have a form (like an on screen invoice) for sales. This shows the Customers Details and what stock they have bought. The customer details are the main form and i have a sub form with the stock, however i realised that this would not work (as...

it was comical but that one worked thanks!!

i have no idea what you just said..:( im fairly new to the whole code thing so i dont know anything... could you perhaps give me an example of how the code should look? thanks again

ive tried many times now and the code still wont work; Private Sub List30_DblClick(Cancel As Integer) Dim sForm As String Dim sArgs As String sForm = "Sales" DoCmd.Close acForm, sForm For Each Row In Me.List30.ItemsSelected sArgs =...

im having the same problem, have you solved it yet?

the stock is carpets, there is only ever unqiue pieces of stock. therefore customer would only purchase one, two or tree rolls of carpet, all different

but wont that tick/untick ALL records? i only want to tick/untick the pieces of stock that the customer is purchasing, not every record in the database. is there not some sort of VBA/code that could be used on click of a command button to tick/untick those selected records?

yes, csutomer Id is the PK in that listbox query. Sorry if its blatently obvious or if im just acting like an idiot but in that code which bits do i alter to make it work with my db. thanks for everyones help

thanks, but i need the code for dblclick comand button. maybe a dlookup function? i dont know. any help?

hi, i have a form of customer details and a subform with their purchase of stock below it. I want to create a button so that when clicked it ticks all the boxes in the subform for the "Sold?" column. There may be mulitple pieces of stock, so i want it to tick ALL the boxes in that purchase...

Hi, I have a form (called Customer Search) with a list box of all customers details. When i double click on one customer i want it to 1) take their customer ID number 2) close the current form (called Customer Search) 3) Open another form (called Sales) 4) insert the customer ID a Text Box...

no, i agree, i just cant think how to successfully join the tables or how to arrange the tables. do you have any pointers to how YOU think it would best be organised? thanks

yes you would be right in thinking that it is only length that is a variable. width remains either 4 metres or 2 metres (depending on type of carpet) but it is always the length that changes, never the width. Also, sometimes carpet is cut into standard room sizes or pre ordered sizes. This is...

Hi guys, I'm still working on my carpet/flooring stock control system. - On arrival some carpet is cut into standard room sizes and sold (no problem, its just logged as individual pieces of stock) - On arrival of some stock, however, the whole roll is put on display to allow customers to cut...

could you show me how the code should look. im not sure where to put it

yes it does, but it does not reset the list box to display all of the records as in the beginning. Null must be entered manually before it displays all records.