Search results

Adding a date field to your sample This example you have posted has really help me out in trying to create a database that keeps track of employee's vacation time. The calculations add up perfectly until I tried to add a date field in the Order Details Table(I renamed It ALUsed) in the database...

I apologize for not explaining myself well. I am a beginner when it comes to creating functions and using VBA to do calculations. What I am trying to do requires programming and I have posted a function below that creates a temporary table to track whats received,shipped,and whats on hand. I got...

I am having a time with this database. I pretty much have everything working the way I would like but I am having trouble with one last piece. This database was created to keep track of inventory received from a vendor to our Warehouse , shipped to location, and the amount distributed from that...

After an Order Is placed by a customer in my Orders form, The customer name replaces an existing customer in the Orders tables instead of going to a new record of its own. Could someone help me please!!! Orders Table : CustomersTable: OrderDetails: OrderID CustomerID...

I am trying to build a database that will keep track of purchase orders by my company and orders by customers. I have a table called Inventory that contains the product name and number of units in stock. I am trying to use an update query to add the number of items order by my company to the...