Search results

Works perfectly ^^ thanks a million for the help. I'll use what I learned to go ahead and work toward completing the rest of the file.

Thanks a million- but I am trying to walk backwards through how you did it. I'm noticing in the control source for the deposit sum that you just referenced [frmInvoiceInfo], but [txtDepositSum] wasn't a column there... (=[frmInvoiceInfo].[Form]![txtDepositSum] ) I'm trying to get a better...

Attached is a version of the invoice with enough fictitious data for the relevant functions in question. After entering frmCustomerInfo, you'll notice frmInvoiceItems as a subform. In it are LineTotal values that equate to $335.50 ($8.50 + $327). In the table above it is a Deposit for $150...

Initially: I was intending to just place a new field for the information I wanted into frmInvoiceInfo. I wanted it this way specifically because I need it to show up in rptPrintableInvoice whenever I go to print it. It would be convenient to be able to store (not simply view them in isolated...

This has been helpful so far, but... From what I'm understanding, I'm to create a field in tblInvoices (via query) that calculates the totals I want? My endgame with this field is to have it show up on the rptPrintableInvoices, however. So would I just make that field, have it show up in the...

I wanted to take the values from the frmInvoiveItems' [LineTotal] field, subtotal all of them for a given invoice ([InvoiceApplied]), and place them in a new field under frmInvoiceInfo that I haven't created yet. (I.E. I have three different items under frmInvoiceItems for one invoice. They...

Ah- I'll go and get started then. Sorta need to start working on it to get the picture there. I just had it backwards mentally ><. Thanks a million. You were extremely helpful

With the first one- there are P.O. boxes for the business. Customers pay "x" amount monthly on them. I was hoping that tblMailboxes would keep track of that value with users only having to interface with it to input payments. Example: Person "A" owes "X" on their mailbox. The amount that they...

1. How do I make a price increment by date in a table field? 2. How can I total up all of the "TotalDue" invoice values for a given Account_ID into a field in tblAccounts?

I had a couple of relatively simple questions this time- assuming tables can even be used to serve this purpose ><. 1. Under the table 'tblMailboxes' in the attached database, I wanted to make a field for a price that increments (preferably monthly, but daily at a smaller increment is fine...

The issue with the form was largely resolved when I made another one. I no longer have any reference errors- but I made the layout somewhat similar to the last one. The problem was solved, but if I could only know the reason why- or why it happened in the first place... :/

At this point I'm starting fresh by just creating a new form and working my way up from there. I guess my initial concern is if my tables in the attached database are a good base for the form I want to create. I was told before to try to reduce the amount of redundancy in my database by...

Let me clarify: The table I most readily see the normalization problem with is the Invoice table. How can I more clearly represent the data I intend for it to have in such a way that the individual values each have their own invoice number/ID?

Based off of what I'm seeing the big problem is my Invoice table specifically. The issue however, is that I'm not entirely sure how else to represent the data in a less redundant way. The problem specifically: I'm attempting to organize workflow in a small business in a more efficient way by...

So as a new developer, I'm running into some pretty mundane issues here and there. Specifically- I've designed (most of) a database that I've attempted to have up and running for a small business. A few days ago, I tested some of the features, and successfully printed from the Invoice form...

Sensible- I suppose it'll be something that I have to live with. I've definitely gotten a lot of useful information over the past few days, however. Any other questions I foresee- concerning forms especially- escape the scope of the thread. Forms are largely foreign to me altogether- although...

Actually yes, that does make abstracting it a bit easier, but it still leaves me with a question or two after the fact. Since I can't exactly use static prices as a unique indexed value (multiple items of varying prices- some of which are the same), I'm at a bit of a loss on how to go about...

Thanks. A lot of my problem stems back to revisiting some basics. But while I'm re-watching some old tutorials, I do have some more specific questions that I'm attempting to answer along the way. Attached is the edited version of what I have (information outside of pricing is gutted, of...

I essentially created an account since I can't seem to find a straightforward answer much anywhere else (plenty of hints on auto-filling forms- but that isn't particularly conducive to my specific need on this). I've attached a blank copy of my database. I may need some help overall- but the...