Search results

Thanks Pat, I'll try this and will let you know.

But I am using Quickbooks, they have made an audit trail report on users, at what time, record entered, edited or deleted by the user.

But if you go on real sense, the same invoice should have to be edited and even i have not seen any software showing this type of correction transaction.

In a form view, its a good idea but sometimes users makes mistakes and you have to edit the record then ...

What is the best way to add time stamp in a form property default value or in a table default value for the record saving purpose. Some uses in tables and some uses in forms. Which way is best.

Let's start, It's mean that I have to add date and time stamp on each record on the time of saving record. But the question is how we will get that. I will try first through google that stuff, after that i will share with you. If you have any links kindly share...

Thanks for understanding someone's thoughts and feelings 💐💐💐💐💐💐💐

I hope so you will share your expertise to improve my skills.

Thanks Pat and CJ, all the people here in the group are very cooperative. They are giving their time, skills and expertise whatsoever required. Sure, I will recommend CJ if the employer required any customised software. But I am making Inventory management project to improve my skills and I...

If someone could do me a favour to make a single form for data entry as suggested by CJ and Pat, I would be thankful.

Use Dlookup function on field2. It will give you the result what you have required.

Thanks CJ, I will let you know after weekend... Happy weekend

Thanks Pat for the Suggestion, I agree that I should have to use a single form as already suggested CJ ... but i am not a programmer so i will move on as simple as i could do. Don't mind it.

Hi , CJ, How are you. Kindly check the following issues; a. Qtyonhand: I want the qty on hand up to the transaction date b. QuantityDifference: PhysicalQty: Adj - Qtyonhand up to the transaction date. The database file is attached herewith. Thanks

https://quickbooks.intuit.com/?sc=seq_intuit_qb_click_giants

Scenario: Combobox with list of accounts as shown in the picture. For the data entry purpose you have to choose from the list. Requirement: As you will click on previous record button, It should have to go for those records as per the selection in the combo box.

On load my forms open on new record, I have to make selection from the said Combobox for data entry and i have also applied filter on the same combobox. I want as I select from combobox list it should have to stay on the current situation but it goes to first record. I have attached snapshots...

I have applied filter on a form. The code is as under; [Forms]![TransactionsMain].Form.Filter = "[TranTypeFK]=" & Me.TranTypeFK [Forms]![TransactionsMain].Form.FilterOn = True It goes to First Record of Filter but I want it on absolute position. Kindly suggest

I want text colour black and selection/Highlight colour is another one.

Is there any alternate solution...