Search results

So like: Private Sub btnLogOut_Click() Dim DB As DAO.Database Dim RST As DAO.Recordset Set DB = CurrentDb() Set RST = DB.OpenRecordset("LoginLogout", dbOpenDynaset) With RST .FindLast "UserName = '" & txtUserName & "'" .Edit...

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...

here is my DB

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...

Works perfectly now. Thank you so much!

here it is. If you notice any other flaws please feel free to let me know! ;p

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)...

when I try to execute it it says it can't find "my query" and highlights this in yellwo wehn I try to debug it: x = DCount("[Current Stock]", MyQuery)

here is the value in the record source: SELECT [Inventory Stock Levels].* FROM [Inventory Stock Levels] WHERE ((([Inventory Stock Levels].[Current Stock])<nz([Reorder Level])));

Alright well I have input the code, but when I open it is says there is an error. I presume that this is because I actually need to replace the words that are in quotations. So in the "my query" do I put the name of the report? What about the expression and criteria?

Where do I put the code?

*bump I really need elaboration on this please.

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...

alright, so how do I incorporate this? I have a form that opens up and displays the transactions, but how do I get it to work with the report?

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...

that worked, but I forgot that there are several reports linked to this query. Is there a way to get it to only do it for one query?

Thanks worked perfectly.

what specifically? I tried deleting those three. And one at a time, but the error still comes up.

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))...