Search results

Interesting thought, but I don't see how it applies in this case, as the comparison is being made between a just entered value and a value in a table that had been entered previously. I will continue to explore out of curiosity. Will let you know if I solve it. Meantime it is working as a...

The only way I could get it to work was to remove the "dialog" and open it as Normal but set it as a Popup, not modular. Upon opening, it sets the calling popup to visible false. When I close it, it makes the calling popup visible again and it lets me return to the proper control. I could...

One last question (I hope). One of my popup input forms is a form to verify timecard info previously entered. It works correctly as a popup but not when opened as dialog (which I need it to do). Sample of code line that does not work: If ([ti1]<>[timein1]) Or ([ti1] Is Null And [timein1] Is...

Minty, OMG! It works! Thank you so much. I am continually amazed both by how much I don't know after all these years and by the bright, unselfish experts willing to share their expertise with the rest of us. I learn something new with every new project.

My OnClick event for the close button on the top popup form: Private Sub done_Click() DoCmd.Close Forms!TimePopupNew![Combo6].SetFocus End Sub The code does nothing except to close the top form. There are other controls on the TimePopupNew form.

I have a popup form that calls a second popup for some info. When the second popup is closed, I want its close button to send the focus back to a specific control on the first popup. Vba to Forms!frmMyForm.SetFocus doesn't work. Is there a way to do this?

Wow, missinglinq! Sure do wish someone had told me this sooner--you solved all of my problems! Many thanks.

I had set up all of the various screens that way and it looked great except that the only way I could figure to get the opening MainMenu to center was to do it as a popup form since it wouldn't open on top of the background colored maximized form when I did it as a centered non-popup. So now...

Access 2010. I am reworking an old db and trying to make it more professional looking. There are numerous small input screens that used to open here and there and I want to center them. I begin by opening a background screen that I wish to be maximized (and stay that way). OnLoad...

The reason? Because the client wants it. They manufacture cushions for the furniture industry and have a complicated scheme for employee compensation. They have time-only workers, piece workers, combinations thereof, home sewers, truck drivers. Most, but not all, get paid for holidays, hence...

Thank you to the many who have weighed in! After meeting with client I have changed my approach somewhat. Now to my current problem: my subform's field [a] <> [Absent] (see attached file). However, "if [a]<>[Absent]" never computes as true (macro attached). How do I determine if the two are...

If no update is needed, ie they just hit enter to pass through an empty control (when in fact the original had an "A" entered), will it catch the difference. I wouldn't think it would need to update anything so it wouldn't do the compare?

There are two text fields for absence in the time table: aVerify and aEntry. The aEntry field is entered when the timecards are entered originally. In the verify screen, aVerify field is entered. After the value or lack thereof is entered, I wish to compare it to the original aEntry field and...

Access 2010. I am in a subform to verify previously entered data (payroll timecard--making a change to a long-ago .mdb). The data to be entered is total hours to be paid, and "A" for absent beside date for each day of week in question. If an "A" is entered into a control, I want to verify it...

My database (with ODBC backend) is used by around 10 users in distant locations. The db is written in Access 2010 and they all have the 2010 runtime installed--all works well. I am contemplating a move to Office 365 for on the development computer--will any of the runtime users encounter...

Oh, wow! Thank you! I had tried the me.refresh but the change from dsum to sum made all the difference. I can live with that. I am always humbled by the number of folks willing to spend time and effort to help those of us who don't always know what we are doing! You are truly appreciated.

Thanks, JHB for the misplaced quotes catch, although it seems to work the other way also. I understand using me.recalc will force the updates. However, it takes several seconds, during which the screen freezes. I am on a gigabit internet connection with a new, fast computer communicating with...

I have attached a skeleton database. Open the Reconciliation form. Clicking yes/no boxes refresh the totals (instantly), clicking the little blue buttons will load $10 in the field and refreshes the form immediately, and pressing enter after entering an amount in one of the charity fields will...

Running Access 2010. My form has two columns that have calculated total (Dsum) fields in the header. If the user presses the Enter key after typing in the value, the total field for that column recalculates properly. If, however, the user simply moves the cursor to another record without...

Oh, my! I just knew it had to be something easy/stupid. Thank you!