Search results

I have 2 tables with the same kind of data. The transaction table is for employees who manually enter data and the second is for employees who will use a scanner. I want to be able to show the information (as it is) from both the tables on the report. Will i need to make a query or can i do...

Hello, I have a form that displays the system date and time for every entry. When the data gets stored in the table, the date and time do not get stored. How can i save the date and time with all the other information. Also, everyday when i open the form, it shows me all the data from the...

I have a table where i enter all my transactions and then use a query to differentiate and calculate the final result. the query alculates for each transaction and gives me the final result but with an entry for each transaction. each of these calculated by my query is shown in the report. i...

Hello, I was writing a query in order to subtract all the requisitions from my invnetory. I have a query to add all the requisitions. Then i use that sum and subtract it from the total inventory. (the query below is the second one) I may have many requisitions for the same product in one...

When i get a report, it has pages full of information. I want to be able to display a selective report based on the date. Is there any way that i can enter the date and the report shows me information based on that date alone. Thanks

I have the following query: SELECT Inventory.[Product Number], Inventory.[Make/Model], Inventory.[Stock Quantity], Requisition.Quantity, [Update Inventory].[New Quantity], [Check Stock].[Avaliable Quantity], [Check Stock]![Avaliable Quantity]+[Update Inventory]![New Quantity] AS [Net Quantity]...

I have trouble adding pictures to my forms. On the form when I add a picture, it just shows me the link and when I double click on it, it displays the .gif file. ( I did define it as an OLE object in the table) I am not sure if there is something specific I need to do in order to display the...

can i use the result of one query to calculate something in another query

Can i apply a filter to a report , to show only the data itmes that i need. how do i do this can anyone help

I am not sure if i can do the following and how I have an inventory table and a requisition table. I already have a report that displays the difference betwen the quantity in the inventory and the requisitioned quantity. All i want to do is to check if the left over quantity is below a...

Hi all, Just wanted to know, if i could publish one of my reports on the intranet. and how do i do that. thanks

Hi My repair form pulls data from the vendor table to display the vendor information. Whenever i try to open the repair form, it gives me a popup first that says "enter the extention number" regardless of entering data or pressing cancel my form gets displayed. When i enter a number (a...

I am trying to do the following: 1. every time i enter something in the inventory table, i want it to be able to iteratively check for any avaliable stock and update the quantity instead of making a new entry every time. 2. Also, every time i do a requisition, it must "Subtract" that amount...

1. how do i auto populate a form from another table. like a repair form pulling up information from the vendor table. 2. I have been trying to pull information into my form 'check stock' from a table called 'inventory'. i want to be able to just enter the serial number and then autopopulate...

i have a form and it always displays the first record as it opens. i dont want it to display any records and be just blank. i have tried the code on Form_load for i = 1 to col.count col.item(i)="" next i dont know whats wrong with this code. please help

I have a table called the inventory table with a field called stock quantity. i want to be able to have a consolidated quantity for all the stock with the same Serial number and not have different entries every time i input a quantity. Also, i want to be able to subract from this consolidated...