Search results

The only thing I would do is have 1 database for the customer details then use a subform for the orders This eay you will have a 'contacts' database good for repeat business. and the orders in one place Hope that helps

Got it working perfectly using =Nz(Sum([StockIn]),0)-Nz(Sum([StockOut]),0) It was to do with Null values in records that was causing it to not display

That doesnt work comes up with a 'The expression you entered contains invald syntax. And I tried it the other way losing the [ ] still dont work

Sorry I have this in the forms section but no one seems to look there so trying my luck here I am having a problem in my form, I have a stock control that has tabs, on the tab (Activity) I have a subform that is populated by a table called Stock Activity and simply shows all the stock in and...

I am having a problem in my form, I have a stock control that has tabs, on the tab (Activity) I have a subform that is populated by a table called Stock Activity and simply shows all the stock in and stock out. In the footer I created a text box (text17) have this sum...

Yeah i thought about using a -1 but i dont want to have to leave that to people to remember to do. as for the stock code just 'display' the results, so total stock. - allocated stock = free stock

1 how do i cal in the stock control file so that it shows what stock is in each location and the other issue is why isnt the 'stock data' tab showing the total stock, free stock, as I think i have the cal in the footers correctly Thanks again for looking at this

As I have stock activity table would this not infer with that? or are you saying have two tables on a stock activity and another warehouse activity and populate both? A little unsure here

I have a stock control system, and we have 2 warehouses I have a Table called Stock control that has a sub form called Stock activity. This works fine. and in the footer calculates the stock in and stock out, giving me a 'free' stock. But now I have 2 warehouses and I need to show where that...

Done by having a auto number and a order number and via a calculation, messy but it works

I have a database that has order numbers, I want to start the auto number at 7013 instead of 1 from the table, but there doesnt seem a simple way to do this any ideas? thanks

Hi Guys I have a complicated ordering database and I need to put in a login and access rights. IE:- 1 person as the right to enter orders but not allocating orders another person has the rights to allocate but not dispatch and so on What would you guy recommend ?

I do but I am in Upper China am working off mobile (worst ever) can we do yahoo right now,when I return we can skype

Hi Guys I need a Good Access Programmer. I am from a medium size company (£4m+) and we have out grown our sage system. Putting together a ordering system (Sales and Purchase) thats bespoke to our company Contact me for further info

Hey cant seem to send a private message on here..... to answer your questions existing business £4m+ turnover currently using sage to order process, but we are fast growing out o that and the only way forward is a bespoke system les talk on yahoo or something

I have a order system, On the purchase order form I have a Sub form for the orders. Each line has a Line price ie:- ( qty*Price=total) I want to display the total order price outside the sub form. Whic I have done but it only adds the first line of the order, how do I get it to add all lines...

its just returning in the target txtbox #Error Doesn't say anything about Line 42..... (sorry a little bit new to access)

I have tried this just as you have said and i get a #error returned Any ideas?

I have a order system, On the purchase order form I have a Sub form for the orders. Each line has a Line price ie:- ( qty*Price=total) I want to display the total order price outside the sub form. Whic I have done but it only adds the first line of the order, how do I get it to add all lines...