Search results

I would like to automatically compute previous day balance of an Item in PrevBal Field in other table.

Table: Date Item Quantity ------------------------------------------------ 10/20/2013 Item-A 2 10/20/2013 Item-B 4 10/21/2013 Item-A 2 10/21/2013 Item-B -1 ===================================== On...

Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?

I get zero(0) using this code. But it works when I reverse the code. pubUserID=Me.UserID Is it correct?

What is the best way to capture the users that modify the records in the database? Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the...

Very well explained Thank you.

I think you have to make another table for the selected products and use CustomerID as foreign key. Just in case you need the data regarding of how many customers choose that particular product, its easy to pull out the records.

Greetings! Everytime i make a report in Access, first thing i do is build a query and then use it as a record source. I try the other way, I go to create report design directly and do the drag and drop of fields. My question is, which of the two methods is ideal? - Thank You -

Thank you.. But if i am going to enter a new record for example Item-B with an ID of 4, and previous entry for Item-A has an ID of 3, i will get the previous balance of Item-A instead of Item-B. I think the code will work only for a table using only a single item?

I have a table composed of the following fields: 1. Entry_ID: 2. Item: 3. Previous_Balance: 4. Increase_Or_Decrease: 5. Current_Balance: Once the selected item had been entered, i want the Current_Balance of previous entry of that item to be forwarded automatically in Previous_Balance field...

----------------------------------------------------------------------- Thanks you plog! Problem Solved! Could I ask another question? Referring to the code above, i use only UNION instead of UNION ALL. I've noticed that the two transactions in 08/03/2013 Cash In at 100.00 each appears only...

----------------------------------------------------------------------- It looks like this: Select Cash_In_Date as Date, Cash_In,"" as Cash_Out FROM CASH_IN Union Select Cash_Out_Date as Date,"" as Cash_In, Cash_Out FROM CASH_OUT...

I have a Union Query which the result was like this: Date Cash_In Cash_Out 08/06/2013 100.00 08/06/2013 25.00 08/06/2013 50.00 08/06/2013 20.00 ------------------------------------------------- What I wanted to get is this: Date...

Create a Command\Action "Outputto" to export the Report in Word or PDF Format.

Set your ComboBox Name to: MyUserID Set your Password Textbox Name to: MyPassword

Private Sub YourSecondButton_Click() Dim PasswordLookup As String Dim SecurityLevelLookup As Integer PasswordLookup = Nz(DLookup("Password", "User", "User_ID=" & Nz(MyUserID, 0)), 0) SecurityLevelLookup = Nz(DLookup("Security_Level", "User", "User_ID=" & Nz(MyUserID, 0)), 0) If PasswordLookup...

Guys I just want to share this VBA code for those who want to ensure that the data entered is all in capital letters. Just a little favor, please give me a feedback if it does not work in other Access versions or if there's possible negative effect in using this code. I prefer to use this one...

On the drop down of PropID properties > After Update Event > Macro Builder > Select Requery

Start to learn Access now! Here's a short guide for step by step learning process: 1. Tables (Fields, Data Type . . ) 2. Relationships 3. Forms (Entry, Editing, Viewing...) 4. Queries (What records do you want to get?) 5. Reports (Print output) 6. Split Database (To allow more than one users)...

What is the best practice for data management once your data base stored too much records eg. Loan records being used for 5 years already? Should I transfer manually those who have remaining balances into new database? Or there's other easy way to handle this? Thanks!