Recent content by wilderfan

I tried that and still had problems. However ... that prompted me to try FormatCurrency with the option of 0 decimal places. And that worked. :) Merci !

Unfortunately, that didn't work. After making the changes, the dropdown contents of the combo box still show the amount field with 2 decimal places. Oddly enough, when I go back to look at the field properties in the query builder, the changes I made have disappeared - even though I had...

Thanks, Ranman256. Works great. There is one other minor change I would like to make to the combo box. One of the visible columns contains $ figures from the query. In the query and in the original source table, the $ amounts are formatted to show zero decimal places. But in the combo...

On one of my forms, I have an unbound combo box based on a query. The query contains 6 columns. The 1st column is the "bound" column, but it is not seen by the user when the user clicks on the combo box. The user sees only the contents of Columns 2 through 6. After making a selection and...

I appreciate all the suggestions. I especially liked the Mendip article and this excerpt: "... there is some disagreement amongst developers about the use of table relationships. Some developers apply them rigorously to any tables with linked data. Others hardly ever use them. "

Is it possible that using 2 copies of a table in a Query Design Window is OK; but that it is NOT OK in the Relationships Pane ? Perhaps that is the reason why the relationship lines in my relationships pane appear to be unstable.

I'm happy to follow the recommendation from Minty and I 100% agree that the revised ER diagram is the way to go. But I'm stalled for the time being. Access file is attached if someone can assist.

The revised ER diagram in my previous post seems to be "re-setting" itself when I re-open the diagram. That is, the relationship line between the alias Department Table and the Reporting Periods Table has disappeared; and the old (original) relationship line between the Departments Table and...

Thanks, Minty. So something like this ?

Before I get too far into working on my "Funding Applications" database, I wanted to confirm if the E-R diagram contains a circular design problem. Description of the db: It's supposed to track Funding Applications for various Projects under the control of either a single Department or...

Yes, there could be multiple contractors and / or multiple individuals working on a job. Initially, I thought only about individuals working on a job. Hence, my initial view that the attributes should simply be: PersonID, FName, MName, LName, Other But then I realized that Acme Roofing could...

Seeking some feedback on the appropriate design of the tables in an E-R diagram. One table contains a list of jobs (tblJob). Attributes would be: JobID, JobName. Second table is the linking table between the jobs and the persons performing the jobs. (tblJobPerson). I was planning for this...

No responses from last week, so I'll try again. I'd like to export the contents of a recordset to an existing Excel file. Ideally, I'd like to open a connection to that Excel file and loop through the 1st recordset and copy its contents into a 2nd recordset linked to the Excel file. Does...

I see that my code didn't get "blocked off". FYI - I did apply the pound sign. Don't know why it didn't work.

I'm spinning my wheels on this. Trying to copy a recordset into an existing excel file. Here's the code I have so far. Any suggestion? Private Sub cmdExport_Click() Dim conn As ADODB.Connection Dim conn2 As ADODB.Connection Dim rst As New ADODB.Recordset Dim strSQL As...