Search results

I'm really glad that I found this calendar as I was trying to desgin one myself. I am looking for a few differences on my input form though and cannot seem to adjust the coding or make it work right. This form uses one large text box to input text. What I want is a drop down to select a...

Have a crosstab query for a running 12 months that is used for a report and I noticed today that each month is correct except that it is also picking up Feb of last year as well as this year. All other months are good. No other pre-queries have any date ranges in them. Anyone know what I have...

Is there any chance I could zip up a copy of what I am working on and have someone take a look at it. I actually have 2 problems to solve. (1) the issue of the contract num and the activie contract num. Depending on what number is input the correct member files will appear and active contract...

Thanks. Very interesting for a novice like myself, so I will give it a try.

If you mean use a Combo box, I went that route initially. However, there are about 900 records now and more coming so we felt that it was not the most streamline direction to date and the users did not like the idea going through such a long list. That is the reason for leaning toward the...

I am using an after update event as below: Private Sub ContractNum_AfterUpdate() Dim szSQL As String szSQL = "select * from qryMembership where Contract_Num = """ & Trim(Me.ContractNum) & """;" Me.RecordSource = szSQL End Sub This is what populates the additional...

I know to most this is simple, but as a newer user putting everything in its right place is hard. Have checked multiple posts for my situation and cannot locate. I know I need to use DLookup. Membership table used to built form has among others, a contract #1 field (9-digit Soc.Sec. #) and a...

Actually, I was working on that very problem of the form update situation when I read your response. Had to adjust my queries and change the data input from Yes to No. It is OK now although when I zip it up it becomes read only. In any case, the calendar control still does not work If I can...

I apologize but when I pulled the files into my zip file I pulled from the linked files rather than the data files. Hope this new attachment will help.

I have attached a condensed copy of my form/sub-form that has calendar controls on it for the RecvdDt and the Compliance date. I have it set up the say way as I have on other databases and it will not close/populate once opened. I have reset the events on it multiple times and I just can't get...

When got to work to try it, the compliance form worked very well and the 3rd tab was viewable. Based on what you have seen in the database, does this seem to be built in a manner that is most efficient? Is there any way that my report card form can be built in such a manner that all fields...

Prior to leaving for work, I am quickly trying to see what you did. The Compliance report is now populating as it should but as I look at my compliance form, the thrid tab for Compliance is not visable. Also, it appears that the form cannot be used to add new entries at this time. What are...

I am attaching my DB that I have compacted so you can get an idea of what I am trying to do. In the tables, you will see one called Test that consists of fields I think I need to get the report to work out right. The Compliance report is also there to show you what I need but each report will...

Have a database that I am working on this is constructed to perform Compliance tracking of wellness activity by employees. Have all my tables, queries and a form that has 3 tab controls as well as a subform on one of the tabs. It is necessary to create a quarterly report card based on 6...

I guess you were right about my DB....it was a mess. Thanks for the directions on where to find the information on normalization. Some great stuff and very helpful. I am correcting the DB at this point. One other question if you do not mind. I have searched and searched for the answer, and...

A different way of approaching it but works great. Thanks for the help.:p

After posting this question, I did go with the sum feature and that works fine. Then what I could not remember was how to divide by the count of the months. So again, I played and figured it out. My forumula works great and now reads: =Sum([Fatique])/Count([Date]) Sometimes I surprise...

I have a report that is the result of data imported from Crystal Reports to Excel to Access. In Excel, the Cell is listed as a General Number and formatted like 00:00:00. The first 2 zeros are for Minutes, the second set for Seconds, and the third set for partial seconds, whatever that is...

Have a couple of queries that I am trying to joing and I am having problems with matching the date and figures from one query to the other query. In other words, 1 query has has a date field with measurements that began effective Oct 2003. The other query has a date field with measurements...

I did it. For some strange reason I did not think you could go back from Access2000 to 97. Someone mentioned this to me, but I am glad to know that it is not the case. Thanks again.