Search results

No. I have never had to build a db for business accounting. I have only used off-the-shelf accounting programs. I suspect calculating interest/late fee will require VBA and be rather complicated.

Can you just copy/paste the SQL statement into SQL View of query builder? Actually, I had wrong SQL in prior post. I have now edited it. Look again. However, should have been simple for you to correct it.

Arnel, your query is returning bill 3 as outstanding and a TotalBill amount of 5184 which is double the actual bill. My simpler query returns only bills that have unpaid amount. To view all bills, just remove the WHERE clause. I would probably not use filter criteria in query and instead apply...

You have BillNo in Payments so there is no need to put CustomerID in Payments. Is BNos defined as primary key instead of autonumber? Still doesn't provide data. Should I assume a bill can have multiple payments? This could get rather complicated. SELECT tblBills.* FROM tblBills LEFT JOIN...

So do you assign payments to specific bills? Provide sample data. If you want to provide db for analysis, follow instructions at bottom of my post.

Doh! So simple and obvious.

Lookup table is one way to go. I have a database that required some text fields to be free-form data entry but there was enough similarity in the data entered they are almost duplicates but not quite. So I used the input field as source for a combobox to "assist" users with data input but not...

This is an extremely common topic. More references: https://www.access-programmers.co.uk/forums/threads/concatenate-records-from-a-query-in-1-line.333069/ https://www.accessforums.net/showthread.php?t=90489&page=2...

I tested CJ's idea. When you type the label caption, type shift+enter after each letter.

And if you want the names alphabetical: =ConcatRelated("NamePrename","DailyOff","IDDate=#" & CDate([IDDate]) & "#","NamePrename")

There is no function ConcatRelated() in your db so No, it won't work. Here is Allen Browne's ConcatRelated() function http://allenbrowne.com/func-concat.html Do you want output like: 1-Alex, 2-Tom, 3-Perla, 4-George, 5-Peter A little modification of Allen's code can do that. First add...

Here is a good article about syncing subforms https://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp In this case, one subform data is actually parent to the other subform but this allows both to be viewed in Datasheet.

Read the code, understand the code, modify as appropriate. This line .Filters.Add "Access file", "*.accdb" restricts files to view. What file types do you want? If you want to allow all then: .Filters.Add "All Files", "*.*"

Right. You have Microsoft Access 16.0 Object and Microsoft Office 16.0 Access database engine Object but not Microsoft Office 16.0 Object

Certainly looks the same. If you want to simply add 3 fields of one record, that does not use Sum(). Just: =Field1 + Field2 + Field3 Sum() is an aggregate function and would be used in a query or textbox of form footer or report footer to sum all records.

Q1: 10 fields Q2: no expression provided but what happens?

Use FileDialog to navigate to a file. This is a common topic. Example: Function GetFile() ' Requires reference to Microsoft Office xx.0 Object Library. Dim fDialog As Office.FileDialog ' Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With...

And what is being done that the progress bar shows activity for? What do you mean by the ODP "does not show" - does not show when db first opens? AFAIK, it isn't supposed to. Open it from the DatabaseTools tab on ribbon when you need to use it.

You want to 'batch' create records for all names on particular date, consider: CurrentDb.Execute "INSERT INTO Daily(IDDate, NameID) SELECT Date(), IDN FROM Names" Then apply filter to form to return Date() records. I advise against LOOKUP fields in table.

Fixed the link in earlier post. Could just Google the phrase and get a bunch of results to review. Back to the original question - code for your report print button. Printing only for latest date, something like: Private Sub Open_Report_Click() If Not IsNull(Me.txtDate) Then If Me.Dirty...