Search results

I want to have two different tasks run when I click the "logout" button on my form. Both work fine independently, but I do not know how to get them to both work at the same time. One is a Macro entitled "Open Work Hours" and the other is a code in visual basic which I place as "event...

I am making a database to keep track of employee work times. What my superiors would like is for employees to type in their employee ID number and when they enter it they are sent to a form to put in time information. They would also like it if the form automatically have the employee name on...

I have a macro that i have set to run at the opening of my database that is supposed to display the number of items that need to be reordered. Only problem is that when it tries to run it says it can't find the input table or query. Here is my code: Private Sub Form_Open(Cancel As Integer)...

So I have two reports and I want the record source for each to be different. Only when I change one it automatically changes the other. I think one may be the sub-report of the other. I downloaded these reports so I was not aware of that when I used them. Is there anyway to break the...

Okay so I have a report that I want to show data from 2 specific dates when it is opened. In the query that it is linked to one field has the expression: Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions].[Quantity],-1*([Inventory...

I have a database that keeps track of how much of certain items we have at a given time. I also have a report that lists the items that need to be reordered once they hit the reorder level. Is there a way to have a pop up or alert when the database is opened that tells the user that there are...

I have had this expression work before, but I accidentally deleted it and when I put it back in it came up with this: Syntax Error (comma) in the expression Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions]!Quantity,-([Inventory Transactions]!Quantity))...

I have a report that displays Item, Transaction, Quantity, and Created date. i need to have it so that when I open this report it asks for the date specifications. A beginning date and an ending date. How do i get it to do this?

Can you upload any picture from you computer into a form or report and put it in the Header?

There was a field in a template for inventory that I downloaded that I did not need so I deleted it. It was a field for location, but all of the inventory is located in the same area. But when I go to the reports for stock levels by date, item, or reorder level a pop-up appear that states...

Okay so I would say that it is safe to assume that my attempt at my first database is crude at best. I was just wondering if any of you design pros might be able to help me figure out what I need to create. Alright so this Database is meant to keep track of inventory items that are held in a...

Alright so i have these few tables and a couple of forms to go with them. I was just wondering if anyone would mind taking a look at the structure of my tables to see if everything looks okay, or if not any suggestions would be much appreciated. This is my first attempt at a database.

How do you make a query that takes data from one field and get it to subtract from the correlating field in another table? For instance: I have 43 Gears. The next day 4 of them are used for repairs. So I have one table "Item Use" with Gears-4 and the original with Gears-43. I need the 4 to...

Note: I did try searching before posting Alright so I have a table titled "Current Inventory". This table consists of item IDs, the item name, and the current amount of that item among other things. I currently have a form which edits a table titled "Inventory Use" which is used to display...