Search results

Hi, I have a split database with several attachment fields that work fine. When I try to create a new attachment field in the BE, upon opening the FE, I get the following error: "The search key was not found in any record." I have tried several ways: first create the attachment entry in the...

Hi, I have a real weird problem: 1.) I Created a form: “PURCHASE DETAILS” - the controls on this form exist also on another form: “ORDER ENTRY” 2.) The entries that are on this new form will eventually be removed from the form: “ORDER ENTRY” – but only after I get everything working...

These are the three fields in question: OLD SIMPSON Credit Balance: =DSum("credit - debit", "transactionstable", "customer = '" & customer & " And transactiondate < " & Format(transaction date, "\#yyyy-m-d\#") NEW SIMPSON Credit Balance: =([OLD SIMPSON Credit Balance:]-[Price we...

I am way over my head here - Newbie :( Can anyone please put the exact expression together for me please?

Ok, I only need three fields I just realized. "Add CREDIT to SIMPSON:" is not needed

As a general rule, we should NOT store a calculated value. Lets take a look at this. Lets say we add a transaction today. The closing balance on the previous record was $123. The current transaction was $23, leaving a balance of $100. Now we carry this forward and at the end of the week and...

Only the following 4 fields should auto populate into the next record: OLD SIMPSON Credit Balance: OLD SIMPSON Credit Balance: NEW SIMPSON Credit Balance: =([OLD SIMPSON Credit Balance:]-[Price we paid:]-[Exp/Trans Cost to SIMPSON:]-[SIMPSON Commission:]) Add CREDIT to SIMPSON: Add CREDIT...

Here we go: SIMPSON Commission: SIMPSON Commission: Exp/Trans Cost to SIMPSON: =(+[Export Cost:]+[Transport Cost:]) Total with Exp/Trans/Comm: =(+[Price we paid:]+[Exp/Trans Cost to SIMPSON:]+[SIMPSON Commission:]) OLD SIMPSON Credit Balance: OLD SIMPSON Credit Balance: NEW SIMPSON...

Well, I have to get to 10 posts before images can be added.

Hi Bob & Vassago, Bob's link explained how to carry ALL fields over with the possibility of excluding some. Since I have about 100 fields and only need to carry over 4 fields, I thin I need another approach. I tried to insert screenshot, no go. The following fields should show up in the new...

Dear Vassago, Thank you very much for your lightening fast help :) In record #1, I have a credit balance. Upon creating a new record, I would like this value to be shown automatically. In other words, I need the field auto populated from the previous record when creating a new record. I hope...

Hi, Can someone please help me with the following two issues: 1.) I need the formula to calculate 15% in a new field from an an existing field. Something like: =([15%] of [price]) 2.) How can I get some fields to show automatically on the next record? Thanks for all your help! Robert