Search results

Hi and welcome! You are getting the "indeterminate" relationships because the links are between an arbitrary field in the data (such as membernum) and not between a primary key (like ID) and a well defined foreign key. I would start by defining clear primary keys for each table (usually the...

Hi and welcome - I just recently came across a discussion of a supposed "OnRecordExit" event. However, this appears to be a beta feature that never made it to release. There is a discussion about a work around at http://support.microsoft.com/default.aspx?scid=kb;en-us;304139 hth, - g

Great! Sounds like you are getting the hang of this stuff. I'll outline my thinking on how to handle the remaining piece, although I'm sure that there are other approaches (and no doubt better). 1. When I say that the data from the calendar is "stored" temporarily, that could be as simple as...

Great! Glad that it helped.

Not positive if this is your problem, but give it a try - Explicitly declare your parameters using the Query / Parameters menu item (while in design view). Make sure you set [How Many Days] to Integer or Long. (I suspect what may be happening is that Access is evaluating [How Many Days] as...

Haven't done this on my own, so pardon if I just confuse things. Take a look at the built in CreateControl function: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acmthCreateControl_HV05186366.asp Also, if you can create constraints on the number of additional...

Hi Victor - You should be able to modify the recordsource for the subform and then use the requery method. E.g. strSQL = "SELECT * FROM tblData WHERE ( <some conditions>) " Me.frmsubSubform.Form.RecordSource = strSQL Me.frmsubSubform.Form.Requery I have had problems in the...

Sorry for the delay. Life was very complicated here for several days. Okay, thanks for posting your database. [By the way, very nice clean looking interface!) As I thought, you are creating a record for each month and each program. While you could in theory make this work, it goes against...

You're welcome! Glad that it worked.

(Sorry, overwhelmed on this end, but I'll try to get back to this soon!) -g

Sounds like you are missing a policy number there. I did not include much in the way of error handling. No wait, I didn't include ANY error handling. :-) You may want to run a query on the original data to check for missing values, values outside reasonable limits, etc. - g

Okay, I think that I am getting it. It sounds like you are trying to have a single record for each month (per ProgramID). Or have a family of records to cover every day of each month. Instead, I think that I would approach this by having another table: tblTaskCompleted -------------------...

Okay, that's beyond me. Sorry for the irrelevant posts!

Amanda - See the attached database. There are two tables. The first, tblData, should look like what your raw data is. The second, tblOutput, should be blank initially, but will contain the results of what we put in there. There is also a form. Open the form and click the button. Then go...

Try the attached. You can open the form frmCalculate and hit the button. It should write the records to the temporary table tblzDurations. Look at the code and see if you have any questions. You do need to include the DAO object library in your references for this to work. I have included a...

Sorry, my example is missing something. If you have a multi-record recordset then the following moves through each of the records rs.Edit <fill appropriate fields> rs.Update rs.MoveNext It is also possible to declare a bookmark in a recordset, but the documentation probably...

Hi again! I think that I may still be a little confused, but tell me if this is along the right lines. I would start with a form based on the Program ID. I would include the basic calendar on that form (maybe as a subform??). The calendar would always be set to display the desired month...

See if you can duplicate the problem in a small stripped down db (if necessary you may need to include a stripped down version of the linked table). If you can't duplicate the problem in an example db, then it probably means that there is something specific to your configuration. I think that...

Hi - A couple of thoughts come to mind - 1. Write one procedure that uses a CASE SELECT statement based on an integer value (corresponding to Button number). Each individual OnClick event calls the common procedure and passes the button number to it. 2. Similar - Write a common procedure...

Hi change your If Not rs.EOF to a while statement... While NOT rs.EOF rs.Edit <fill appropriate fields> rs.Update wend hth, - g