Search results

I'm using Access 2003. I'm trying to make a combo box refresh in a given form after making changes to the cb from another form (while the original is open). So here's the sequence: 1. User opens main form containing cb control. 2. User adds or changes an entry in the table feeding the cb...

Not sure how that will help me. I'll give a few more details. Form frmLoading (see attached) currently displays the calculated field "Amount USD" by pro-rating the "Actual Amount" on the parent record (or the "Estimated Amount" if no "Actual Amount") by the Tonnes on the current record...

I'm using Access 2003. This might be a bonehead question, but is it possible to use a multi-table query for a form's Record Source and still be able to update records in one of the tables? I have the following query as the Record Source for a form: SELECT tblLoading.LoadingID...

You make a good point. Actually, I have it coded so that if the user selects anything from the combobox controls, I disable the textbox until they first blank out the combobox. So I think I'm OK there. Thanks for the reminder. I'm gonna take another look at my code to ensure that these cases...

This works great! And I appreciate your pointing out why the .Text property is so important. (I prefer to understand how the code works.) Thanks! Have a great day! Wayne

I'm using Access 2003. Is there a way to detect whether a user has begun typing in a textbox? Or whether, after typing something into it, they have erased what they have typed? I have a Search form with a criteria value of type text that the user enters into a textbox. I also have other...

Works great. And it's short and to the point. Thanks.

Worked great! Thanks. Wayne

I'm using Access 2003. Sorry if this is a dumb question, but is there VBA code to detect whether a given form is already open? (I've googled for a while, but I can't seem to find the answer.) Thanks. Wayne

This worked. Actually, based on your suggestion, I just added the following command to the After Update event and it fixed all: DoCmd.GoToRecord , , acNext Thanks for the help! Wayne

Thanks! That worked. I think I understand the first two parts of the format string (pos number format; neg number format). But what do the last two pieces represent (;;"0.0")? Wayne

I'm using Access 2003. In a form I have a textbox control that displays numbers in Standard format with three decimal places. I'd like to be able to display them with a negative number format (displaying parentheses rather than the negative sign): Unfortunately, I cannot seem to get it to...

Hi, Michael, I think I understand what you're saying, but still not quite sure how to implement. My form is actually a subform that's nested two levels deep. Because the subform needs to talk to the parent forms, I need to requery both the parent and grandparent forms whenever a row is...

I'm using Access 2003. In a form's AfterUpdate event, I want to know whether the row that was just updated was a new record. I've tried testing the .NewRecord property, but that doesn't work. (Apparently, by the time we're in the AfterUpdate event, it's no longer considered a new record.) Is...

Beautiful. It works! Thanks for your help. Wayne

I'm using Access 2003. I'd like to prevent users from entering a duplicate Claim Number in a field. (That is, if the entered Claim Number is already in the table, block it and throw an error message.) I know I can prevent that by creating a table index on that field with No Duplicates...

Actually, I started out with a Recalc, but some of the dependent calc fields were not updating correctly, so I had to resort to a full Requery.

This worked beautifully. Thanks. Actually, I had to tweak your code a bit. Here's what worked: Forms!frmClaim.SetFocus Forms!frmClaim!subClaimParty.SetFocus Forms!frmClaim!subClaimParty!subLoading.SetFocus

I'm using Access 2003. I have a subform that is nested two levels deep (it has a parent and a grandparent form). In the AfterUpdate event of the subform, I requery the grandparent and parent forms (and restore to the same records displayed before the subform update), then I requery the subform...

I'm using MS Access 2003. I notice that if I'm tabbing through a subform, then click into the main form, then tab through until the cursor again enters the subform, the focus immediately jumps to the last control in the subform to have had focus before I had clicked into the main form...