Search results

I'm using a form as a method for users to input data and I've programmed an add button so when it is clicked the data in the form is added to the table. Is it possible to add data to the table without the user entering the data or it appearing on the form? For example, I'd like to add data to...

Evening all, How can I enter a default value in a form to calculate a sum based on two other values entered into a form. For example, in my table I have fields for price, quantity and total value. If the user enters price and quantity in the form I want the value to calculate automatically...

Thanks vbaInet, Have started looking at the switchboard manager - this seems exactly what I need. Will then have a better look at the button wizard and see where I get with that. Do you think it's best to get the tables right first? I was thinking it was best to develop some provisional...

I have played around with the form wizard and managed to create a form I’d be happy using for data input. In my mind I need the following: 1) A menu screen. The first screen users see when they open access. In here I will create buttons with VBA macros running when users click the...

Thanks Dave. I think an ordered item table is probably unneccessary - we only manufacture a couple of products and that will be identified in the order number (The order number is a letter followed by a five-digit code with the letter designating the product type). Where a customer order has...

Sorry YNWA, just saw your second post! The search tool sounds pretty much what I'm looking for. Do you have a link to some instructions to create something similar? Is the YNWA because you're a Liverpool fan? What's happening at Anfield this season??!

Thanks YNWA, Sorry forgot to mention I'll be using multiple tables. In my mind I'm thinking I'll have a main customer orders table (with order number, delivery date, quantity required, etc), then reference tables for customers (name, address, id, etc) and currency, etc. The next phase of my...

Evening all, I'm quite new to access and have taken on the quite daunting task of implementing a system to efficiently add sales orders, manufacturing orders and schedule production for a small-ish manufacturing company. My starting point has been playing around with setting up a table for...