Search results

Hi folks, I'm trying to allow my users to do some analysis of existing data. they would like to be able to generate a report which will summarise sales orders against the month they were placed. They would also like to summarise this by between 1 and 4 other fields. I have created a...

Hi All, I have a table within which I store my "Warehouses". The services offered by each warehouse (there are 8 of them) are stored in here as yes/no fields as well as the full addresses of each warehouse. For one warehouse I can therefore say if it contains "Stock" or offers a "Painting"...

Hi All, I have a textbox on a subform to allow a delivery qty to be entered (to allow me to cater for part deliveries). I have a query which totals up the values of this field (so that I have a total of all the deliveries for this record) and compares that value against another field (to...

Hi All, I have a form which contains the Order Header and a subform which is a continuous form and contains the Order Detail. This is working fine to allow users to enter orders onto the system. I've also got a "Complete" button which allows the user to complete an order, i.e. this closes off...

Hi all, I've got an access front-end database running on Access Runtime on a Terminal Server with a back-end on a data server both of which are hosted by a remote company and accessed via Terminal Services. All is well and the database is working fine but because this is a cloud system I...

Hi All, I'm nearly at the point of distributing my database. I have been writing this on my laptop and I need to get it working on a Terminal Server and Data Server at the data centre that host our system which is a remote location. The Terminal Server has Access Runtime only, not the full...

Hi All, I am aware I am not the first to raise this question but I've tried in vain to find a definitive answer and haven't been able to so I am hoping someone can point me in the correct direction! I have a main form which allows me to fill in Order Information within which is a subform which...

Hello all, I've previously posted about my database which is being used to manage stock of Aluminium Extrusions. I can now successfully raise a purchase order with an extruder using the system and can also print this order out using a report. The next stage is what happens when the material...

Hi All, CJ_London very kindly helped me to build the structure of my database so that I can avoid storing calculated costs with my order records. I have stored the costs in my database with a date they apply from so I have a series of costs which I can then refer back to using the order date...

Hi all, I have created an "Orders" form within which is a subform that will contain the lines of the order. Within this subform I want the user to select an Extrusion and Length. The lengths available for each extrusion are not always the same so I want the choice of Length to be dependent...

Hi all, I am trying to design my database according to the rules I see in these forums as I'm hoping that by doing so I can avoid the pitfalls that you far more experienced developers have already discovered! My question is when is the best time to have a "lookup" function for the user...

Hi all, any help you can provide would be very much appreciated! I am developing a stock control system which needs to incorporate two manufacturing processes (I am concentrating on the "Assembly" process first as I believe this to be the more complex one for stock controlling). Initially we...

Hi all, I have two comboboxes on my form. When the value of the first combobox (SourceWH) changes it performs a requery on the second (DestWH) as the drop-down list needs to be filtered depending on the first value. I have this working fine but my problem arises when I need to be able to swap...

Hi All, I'm new to this so apologies if my request seems a bit elementary and I simply haven't understood a basic principle of Access... I have moved across from Excel to Access so this is the first thing of any significance I am doing with Access and as sod's law dictates it is a Stock...

Hi all, I'm very new to Access having spent many years becoming very proficient with Excel including VBA. I'd now like to get to know Access so that I can develop applications that will be more robust and work with multiple users without too much hassle. My problem is building up my knowledge...