Recent content by tcarnahan

Thanks for the info, MackMan! I checked your linked example, and if you notice, they talk about using DoCmd.MoveSize just like my example above. Yes, I have a problem with my continuous forms not sizing correctly. The DoCmd.MoveSize used to take care of all of that. However, now it does not...

I am using a sizeable border.

Some time ago when I was programming in Access 2000, I used to get frustrated because I could never by sure what size a pop-up form would be and where it would appear. As a result, I used the code shown below to precisely size and position my form, then set PopUp = True; Modal = True. It did...

These records are not summaries. The table was intended to be a lookup table. I am keeping historical records of what the members have paid and the lookup table is a historical listing of what the dues amounts were for the organization. I have business rule logic that says "if the the member...

Since the dues for this organization change each year, I needed to associate the year and the dues amount. It seemed reasonable to include the boolean field to indicate which record represented the current year. If I understand correctly, are you saying to create a one record, one field table...

I have a table with fields for the year, dues, and a Boolean field that indicates whether or not its record is the current year record. I have a form based on the table that is used to update the table. My business rule is that only one record can have the "current year" field checked. I...

Sorry ... my comments (above) were in answer to your questions about my goals/objectives. I just went through all the great links you presented and they are right on. Exactly what I was looking for .... Thanks for your help! :)

My background is as a database developer, however, I have not worked with design/modeling in a long time. My "gut" tells me when tables are not normalized and I need to ask the designers to go fix the database. Many moons ago, I worked with Texas Instruments tool (can't remember the name...

Can anyone recommend one or two books (or resources online) that deal with database design / modeling that: don't cost an arm and a leg don't go step by step building a database design easy to follow have tips and tricks for how to develop entities and relationships Also, can anyone...

Thanks Paul! The combo-box undo did the trick!

Paul, I spoke too soon. My code (above) goes into an endless loop. I added the red line numbers so that I could describe what is happening. When I start to type a name into the combo-box [cbo_Selector], names are supplied in the box until the control holds a name not in the table. I press...

Here is my code in the main form. I got rid of the second form: Private Sub cbo_Selector_NotInList(NewData As String, Response As Integer) 'Suppress the default error message. 1 Response = acDataErrContinue ' Prompt user to verify if they wish to add a new value. 2 If...

That would work if I wasn't using a combo-box to navigate. The user types in the first several characters of the last name they are looking for in the combo-box on the main form. On Change, if the name exists, I have code that goes to that record on the main form. If that name does not exist...

Paul, Thanks for the quick response. That solves part of my problem. The other part is this: Both forms are bound to the same table. When I close Form B, not only do I need to have the combo-box refreshed, but I need the main form (Form A) to display the new record so that the user can add...

I have been working in the database world for over 20 years, but most recently with SQL Server (I left the front-end development behind). I had programmed in MS-Access for 10 of those years, but there is a lot that I have forgotten :banghead: and it appears MS-Access has a lot of new...