Search results

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...

Thanks, Nigel. In the Control Panel, I had set it to English (Canada). Once I changed it to English (U.S.), the Date Picker then displayed the format that I prefer (which happens to be the American format). Now both of my Date Picker controls show the same (U.S.) format. However, I am still...

Location is Vancouver, Canada. The file I'm working on has 2 controls that use Date Picker (on different forms). In one case, clicking on a calendar date (but before hitting enter), the format is mm/dd/yyyy; but in the other case, the formate is dd/mm/yyyy. I've looked at the formatting of...

I'm using Date Picker to input a date on a form and I've just noticed something odd. The property sheet for this control shows the following format: mm/dd/yyyy I'm happy with that formatting and that is how the dates are ultimately stored in the table. BUT ... When selecting the date from...

Inserting some Current Event coding for the 2nd Form worked. I simply "called" the Form Load event within the current event and that seemed to work. Thanks again, Paul.

I've run into further complications. (What else is new?) When I open up the 2nd form which is used to input dates, everything works fine until I try to input a second date. I think one problem relates to the passing of info using OpenArgs. I have successfully split the OpenArgs string into...